Pivot table and formula help??STUDENT NEED HELP....

[Guest]

I need help detrmining what function I need to research so I can create a
formula for my worksheet.

Example: I have 4 different worksheets that have payroll, marketing, and
fixed cost for 40 businesses. I want to create a worksheet that will allow
me to pull the data from each years spreasheet for payroll, marketing, and
fixed cost by simpling typing the business name in my master sheet so I dont
have to create 40 worksheets seperatly.
Will I need to create a PIVOT TABLE or should I use another function? Any
help is greatly appreciated....

 

[Guest]

A pivot table is one way to do this, in which the business name would be the
filter you apply to the pivot table.

Other functions to consider would be VLOOKUP and SUMPRODUCT, depending on
what you want to do and how your data are structured.

Dave