K
KO
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))))))))
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))))))))