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

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

" wrote:

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

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

On Apr 7, 8:30*am, JCS wrote:
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

" wrote:
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

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

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

" wrote:

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