G
Gabe
I am trying to summarize one sheet onto another in a
workbook.
The first cell I'm referencing is going as follows:
Sheet 1 Sheet 2
FC4 C3
I then need to link 3 cells over on sheet2 to 10 cells
farther down on sheet1 as follows - coninuing for a while:
FC14 F3
FC24 I3
FC34 L3
I would also like to link 2 cells over on sheet1 to 1 cell
to the left and 1 cell down on sheet2 as follows:
FA4 B4
This will then follow down the sheet as follows:
EX4 B5
EU4 B6
ER4 B7
In other words there will be a continuing instance of 2
columns in sheet2 reflecting data in sheet1. Everything
can be plotted out to connect over to sheet1 and move from
1 cell since the locations of the data will not change.
Is there any way to offset the link? Also I am having a
bit of trouble understanding how the offset function
works. Is there a site I can check out that will explain
it to me?
workbook.
The first cell I'm referencing is going as follows:
Sheet 1 Sheet 2
FC4 C3
I then need to link 3 cells over on sheet2 to 10 cells
farther down on sheet1 as follows - coninuing for a while:
FC14 F3
FC24 I3
FC34 L3
I would also like to link 2 cells over on sheet1 to 1 cell
to the left and 1 cell down on sheet2 as follows:
FA4 B4
This will then follow down the sheet as follows:
EX4 B5
EU4 B6
ER4 B7
In other words there will be a continuing instance of 2
columns in sheet2 reflecting data in sheet1. Everything
can be plotted out to connect over to sheet1 and move from
1 cell since the locations of the data will not change.
Is there any way to offset the link? Also I am having a
bit of trouble understanding how the offset function
works. Is there a site I can check out that will explain
it to me?