
Can I reference a cell in another worksheet like this?
Example:
Worksheet A
A1 Data1
A2
A3 Data2
A4
A5 Data3
Worksheet B (I want to copy by referencing the cells in Worksheet A)
B1 'Worksheet A'!A1B2 'Worksheet A'!(A1+2)~ meaning I want to copy cell'Worksheet A'!A3B3 'Worksheet A'!(A3+2)~ meaning I want to copy cell'Worksheet A'!A5... Note thatA3in this formula comes from the formula inB2by skipping one row inWorksheet A.B4 'Worksheet A'!(A5+2)
The reason for this is so that I can skip the A2 and A4 cells and be able to drag the formula in Worksheet B to extend it without the need to point manually each cell that I want to copy from Worksheet A.
No comments:
Post a Comment