I've uploaded a worksheet. It has three tabs, 'Locations' and 'Sample' and 'Desired'. What I need to figure out is if there is a quicker way to add 1176 rows of data from the 'Sample' tab to the 'Locations' tab.
So, for the 'Locations' tab, row 2, I need to add the info from the Sample tab for column C, D, and E. I need to insert 1176 rows so that it looks like the 'Desired' tab. I then need to do this for all the rest of the locations.
I could do this by copying and pasting it - but is there an easier way?
Bookmarks