Hi,
I have over 100 sheets in an Adjusted Cost Spreadsheet with the following ACB formula in cell K6 but with the starting cell to test for "SPLIT" set to B7 instead of B6:
=IF(B6="BUY";K5+(C6*D6)*E6+(F6*E6);IF(B6="SELL";IF(I6=0;0;K5*(I5-C6)/I5);IF(B6="TXFR OUT";K5+(C6*D6)*E6+(F6*E6);IF(B6="TXFR IN";K5*(I5-C6)/I5;IF(B6="REINVEST INT";K5+(C6*D6)*E6+(F6*E6);IF(B7="SPLIT";K5+(C6*D6)*E6+(F6*E6);IF(I6=0;0;K5*(I5-C6)/I5)))))))
Using the Find & Replace set up as seen in CalcScreen1 attachment, I'm able to click on Find and Replace (Find All is greyed out) each of the starting cells, but the formula doesn't automatically increment (adjust) in the subsequent cells in the sheet. I can copy Cell K6 and 'paste special - formula' to all the cells in the column which will correct the formula, but don't want to manually do this for the remaining sheets.
How do I correct the formula in the starting and subsequent cells in all the sheets with the minimum of manual entry?
Thanks in advance.