View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] goldcomac@mac.com is offline
external usenet poster
 
Posts: 30
Default How do I compile data?

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