How to create list from 4 workbooks based on 1 criteria?

G

Guest

Sounds like a job for Autofilter. Apply autofilter to the
records you want to pick from. Set the column D filter to
choose Utilities. You'll get a subset of records
displayed. Select the filtered rows, copy and paste into
your assembly area. When you do the copy, the individual
rows should show that they are being individually selected.

Hope this helps.

-----Original Message-----
Hello, I am looking for some help creating a list of
Click to expand...
entries from 4 lists. These lists are account entries.
Two departments, Utilities and Public Works, are listed in
these 4 master lists.
What I would like to do is take Sheet No, Date, Account
Click to expand...
No., and Amount Spent entries from these 4 workbooks that
contains "Utilities" in column D and put it into a new
workbook.
I can write the macro to sort this master list by date
Click to expand...
once it is created, but I can't figure out how to pull the
correct information from the 4 workbooks and collect it
all into one place.
 
S

setoFairfax

Thanks for your reply!

What you posted is what needs to be done with my workbooks, but I would like it to be done automatically. When I open the master list, I would like it to pull this data from the 4 workbooks. This way it is always up-to-date.
 
G

Guest

Good morning,
Workbook to workbook record update automation is beyond
me, I'm afraid. Cut-and-paste is my only Weapon of Mass
DataTransfer! I guess you'll have to post a new plea for
help - suggest you put automation in the subject line.
I'm certain that one of the MVP experts can get you going.

Sorry, but good luck.

-----Original Message-----
Thanks for your reply!

What you posted is what needs to be done with my
Click to expand...
workbooks, but I would like it to be done automatically.
When I open the master list, I would like it to pull this
data from the 4 workbooks. This way it is always up-to-
date.
 
Top