Referencing Multiple entries in a worksheet

[Philly Z]

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!

 

[Roger Govier]

Hi Philly

I'm a little confused by your posting. You start by saying you want the
Company's specific worksheet to go to the Master worksheet.
In your example, you talk about data going from the Master to Company ABC
worksheet.
Assuming it is the latter that you want, then maybe you don't need to carry
the data to another worksheet at all, but this method will allow you to if
you wish.

First create a Pivot Table
Place your cursor in the table of data in your Master Sheet>Data>Pivot
Table>Finish
On the skeleton of the new sheet that is created
Drag Company to the Row area
Drag Event to the Column area
Drag Cost to the Data area

If you double click on the Total figure for any Company, a new sheet will be
created with all of the transactions making up that total.

In order to ensure that your Pivot table picks up future entries on the
master sheet, you would be better creating a dynamic named range for your
source data. Assuming your header are in Row 1 of Master sheet starting at
A1, then on your Master Sheet >Insert>Name>Define
Name myData
Refers to =$A$1:INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1))

Now, go back to the Pivot Table, right click on any cell in the table>Pt
Wizard>Back>Source = myData>Finish
As you add more data to the Master sheet, that will be included in your PT.
All you nee do is Right click on the PT>Refresh to update for any new lines
entered.