Filter Across Multiple Sheets

[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

 

[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.