AutoFilters - copy and paste from one spreadsheet to another

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I have a spreadsheet that I distribute to various people
requesting updates. The person receiving the file clicks
on the autofilter, selects their name, and updates the
spreadsheet. When I receive the updated spreadsheet I
would like to be able to copy from the updated spreadsheet
and paste into my master spreadsheet but when I do this
Excel pastes the information to the unseen rows.

Is there a way to copy and paste from the updated
spreadsheet to my master spreadsheet?
 
The data will be pasted into a contiguous block, even if some rows are
hidden.

Perhaps you could sort by name, instead of filtering. Then, paste the
updated data into the sorted rows.
 
Back
Top