Hi,
I have one file with multiple worksheets in it.
Worksheet A provides several columns that references values in another worksheet in the same file.
So worksheet A has:
ROW1 - DATE, VAL1, VAL2, VAL3 etc.,
ROW2 - DATE, VAL1, VAL2, VAL3 etc.,
ROW3 - DATE, VAL1, VAL2, VAL3 etc.,
Row 1, Column 2 (VAL1) in this worksheet would reference SHEET2!B1
Row 2, Column 2 (VAL1) in this worksheet would reference SHEET2!B12
Row 3, Column 2 (VAL1) in this worksheet would reference SHEET2!B23
How can I copy the reference so that it automatically increments for every 11th row?
So if I copy what is in COLUMN 2 ROW 3 of the main sheet to COLUMN 2 ROW 4 it automatically displays the contents of SHEET2!B34?
If I do SHEET2!B23+11 I get the value in that cell, plus 11. Not what I want.
Right now I do this manually - too tedious.
Any help is appreciated.
Thanks,
M
Bookmarks