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