csilabgirl
Active Member
- Joined
- Aug 14, 2009
- Messages
- 359
Hello,
I have values on Sheet 1, in cells A9 through A400. On sheet 2, I want to be able to reference the values on Sheet 1, however the formula is every 8 rows. Meaning:
Sheet 2 cell A28 = Sheet 1 A9
Sheet 2 cell A36 = Sheet 1 A10
Sheet 2 cell A44 = Sheet 1 A11
and so on....
I want to be able to drag down the formula on sheet 2, so that I dont have to manually type the cell reference in every 8th cell on sheet 2.
I hope that makes sense. If anyone has any ideas, that would certainly save me a lot of time.
Thanks
I have values on Sheet 1, in cells A9 through A400. On sheet 2, I want to be able to reference the values on Sheet 1, however the formula is every 8 rows. Meaning:
Sheet 2 cell A28 = Sheet 1 A9
Sheet 2 cell A36 = Sheet 1 A10
Sheet 2 cell A44 = Sheet 1 A11
and so on....
I want to be able to drag down the formula on sheet 2, so that I dont have to manually type the cell reference in every 8th cell on sheet 2.
I hope that makes sense. If anyone has any ideas, that would certainly save me a lot of time.
Thanks