How do I compile data?

[goldcomac]

I have multiple sheets in my workbook. Each sheet contains a company
name, address, and I've assigned a Zone to it. Either a 1, 2, 3, or
4.

Can I - easily - create a new sheet which looks at the Zone and says
"this company is in Zone x?"

In other words:

Zone 1
Company A
Company D

Zone 2
Company M
Company G

Zone 3
Company B
Company H

etc.

The purpose of this is to give me a "look at a glance" to see which
companies are in a certain area.

Thanks.

Chip

 

[JCS]

HI Chip,

If I may suggest, instead of having a seperate worksheet for each company,
why not have all of the companies and their zones in one worksheet?
Subsequently you could use Auto Filter or Advanced Filter to see which
companies are in which zones. Just a suggestion.

John

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Summarize multiple sheets
and filter on tag value.
Easy, no formulas, no code.
http://www.mediafire.com/file/oom12zzzkio/04_07_09.xlsx

 

[goldcomac]

HI Chip,

If I may suggest, instead of having a seperate worksheet for each company,
why not have all of the companies and their zones in one worksheet?  
Subsequently you could use Auto Filter or Advanced Filter to see which
companies are in which zones.  Just a suggestion.

John

John,

I have a bunch of other information on each page, not just company
name and address. I didn't mention that because it seemed to be
incidental information. Maybe I should have.

Thanks.

Chip

 

[JCS]

Hi,

What I'm saying is that from what I can see, you don't need a single sheet
for each zone and/or company. Following is what I am talking about: (this
is a list/table in 1 worksheet)

Company Address City State Zip Zone
Company A 1
Company G 3
Company B 2
Company H 1
Comapny I 3
Company C 4
Company K 1

Then do an Auto Filter on the Zone field and select which zone you wish to
see. Only the companies in that zone will display, all other companies will
be hidden.

John