Copy and Paste in Excel using filters

D

DA

Help please. I can't not figure this one out.

I have multiple identical excel spreadsheets. One is a "master"
document that acts as a shell. The others, have completed cells with
information for particular topics.
I'm attempting to filter the topic spreadsheets based on the topic and
paste the data into the "master" document. So, (using an autofilter on
both (master and topic spreadsheets) using the "topic") - I'm
attempting to copy and paste the fields from the topic into the master.


The challenge is, I want to be able to filter by the topic, copy only
the items in the filter, and paste the information into the Master - on
the same filtered cells. This is hard to explain, and I'm sure it
doesn't make sense.

Example - I filter the Master to show rows 1-3-5-7. I filter the topic
- which has data only in 1-3-5-7. I copy the filtered cells from the
topic, and want to paste the info into the master but ONLY the filtered
rows 1-3-5-7.

Help!
Thanks
 
A

A

Hi ,
I am not sure whether I understood your problem correctly but can't you
use the sort functionality coupled with a vlookup to address this ?
 

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

copy and paste filtered cells 1
VBA: How can I use a string variable as autofilter criteria? 4
Filter-Copy-Paste Problem 3
copy and paste error 2
Excel copy only visible rows from autofilter 2
Can't Copy and Paste when I'm using a filter List.. hmmm 1
Filter, Copy and Paste 2
Copy and Paste 1

Top