Filter Across Multiple Sheets

S

Scott Halper

I have 7 sheets that contain contact information. I want to have a
filter set up on another sheet that will allow me to select a city or
a state and return all the individuals that meet the criteria from all
the sheets into this one sheet. All the sheets are formatted with the
exact same column headers. Thanks for your help in advance.

Scott
 
R

reitanospa1

I would suggest putting all the data on one sheet (which creates a
single database, instead of 7) and use Data/Filter/Autofilter. Excel
treats each block of data as an independent database and does not see
a relationship between tables; Access, however, is designed to do just
that and may be an alternate solution if the data volume is large.

It would be a good idea to construct this from a COPY of the document
either way, but don't keep copies when you're done or you will have to
keep both of them up to date whenever changes are made.
 

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

Sumif across Multiple sheets 2
Summing across multiple worksheets in excel 2007 3
Vlookup in multiple sheets 2
Average across worksheets ignoring zero 2
LOOKUP across Multiple Sheets 4
SUMIFs across multiple sheets 7
COUNTIF across sheets in columns 1
XL VBA function needed for a list of items 1

Top