View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Philly Z Philly Z is offline
external usenet poster
 
Posts: 1
Default Referencing Multiple entries in a worksheet

I have a master table in my first worksheet with three columns. Column A has
the company name, column B has the company event and column C has the cost
for the event. I also have a worksheet for each of the individual companies.

I'm trying to find a way for each company's specific worksheet to go to the
master worksheet, find all rows for which column A has that company's name
and then output the information in columns B and C into the company's
worksheet.

For example, if there are three entries for company ABC in the masterlist
and three events: company party, recruiting ball and barbeque with a cost of
$100, $200 and $300, I want my company ABC worksheet to say:

event...........................cost
company party.............$100
recruiting ball...............$200
barbeque.....................$300

Is this possible? If so, I would really apreciate any help.

Thanks!