I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12 pages will have different cell numbers that this data needs pasted into. Each week the 12 pages need to go to the next line for next weeks data.
Is this possible?
Ex: paste numbers on main page in B2-B12
B2 cell will populate the second page in cell B61
B3 cell will populate the third page in cell B39
ETC.
So you really want to move data from B2-B12, to separate sheets, that are already indexed by the cell row it came from.....then populate the empty twelve slots with new data? Does that sound right?
