Hi, This is my first post so hope i'm doing it ok!
I want to copy a formula where:
A1 = B1 (on different tab)
A2 = B5 (on different tab)
A3 = B10 (on different tab)
So as i copy the first cell (or 2) down i want the formula to look 5 rows down on the formula, I have put 4 blank lines inbetween the B1 and B5 and the copied the formula down, then hid the rows, but i have thousands of rows to do so am really hoping there will be a quicker, and easier way to do this!
Bookmarks