AutoFilters - copy and paste from one spreadsheet to another

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?
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Integrating information from Word to Excel (not mail merge) 1
Linking data in MS Word into Excel 5
Need Help with a VBA subroutine 0
External cell reference between two excel worksheets both in One Drive 0
Embed the same Excel multiple times 0
Formula's won't read copy / pasted data ? 2
Excel not responding before calculations 1

Top