Menu
Ask a question Report

Populating multiple cells with information pasted on a main sheet

- - Latest reply: ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 - Feb 15, 2019 at 03:50 PM
Excel Ask a question Report
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.
See more 

1 reply

Report Respond to ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1470
0
Thank you
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?
Respond to ac3mark
Reply Ask a question