Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet and Pivot Table
I have a worksheet that draws info from a pivot table which has info for
salesmen. I had to add a new salesman and now all the info on the worksheet is not getting the correct info because inserting a new salesman made all the data move down a few lines. How can I get the correct info without retyping new formulas with the new rows I need to reference?(I.E., instead of AC164 now I need AC 169)Below is a formula from my spreadsheet: Thanks for any help! =IF(Database!$C$2="PRIOR YEAR",'Calc File'!$AC$8,IF(Database!$C$2="DECEMBER",'Calc File'!$AC$164,IF(Database!$C$2="JANUARY",'Calc File'!$AC$320,IF(Database!$C$2="FEBRUARY",'Calc File'!$AC$476,IF(Database!$C$2="MARCH",'Calc File'!$AC$632,IF(Database!$C$2="APRIL",'Calc File'!$AC$788,IF(Database!$C$2="MAY",'Calc File'!$AC$944,IF(Database!$C$2="JUNE",'Calc File'!$AC$1100,0)))))))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet and pivot table | Excel Discussion (Misc queries) | |||
Pivot table - remove worksheet | Excel Worksheet Functions | |||
Worksheet change with pivot table | Excel Discussion (Misc queries) | |||
can i use more than one worksheet in a pivot table ? | Excel Discussion (Misc queries) | |||
How do I use a pivot table value to reference a worksheet | Excel Worksheet Functions |