Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |