Find and Replace to edit references

12/12/18 Edited 12/09/19

Hi! 

 

I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells.

Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier!

the original is :

=SUMIFS({DSMONEY18}, {MonthDS18}, @cell = 4, {DSVEND18}, @cell = "Vendor")

Replace with:

=SUMIFS({DSMONEY19}, {MonthDS19}, @cell = 4, {DSVEND19}, @cell = "Vendor")

Screen Shot 2018-12-12 at 12.13.16 PM.png

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    If you open up the formula as if to edit it then just click inside the range reference, you should see that Reference Another Sheet in the helper box has changed to Edit Reference. Once you edit that reference, it should update every occurrence in the sheet.

    thinkspi.com

Sign In or Register to comment.