Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "walkerT" wrote: 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Formula | Excel Discussion (Misc queries) | |||
Pivot table formula | Excel Worksheet Functions | |||
Trouble with formula on Student 2006 learning essentials template | Excel Worksheet Functions | |||
PIVOT TABLE FORMULA | Excel Discussion (Misc queries) | |||
Pivot Table - if Formula | Excel Worksheet Functions |