Hello. I copied in formulas from another sheet and I'm trying to find and replace [GL.xlsx] in =SUMIF([GL.xlsx]June!$C:$C,[GL.xlsx]States!$B7&"-"&[GL.xlsx]States!C$3,[GL.xlsx]June!$H:$H)-SUMIF([GL.xlsx]June!$C:$C,[GL.xlsx]States!$B7&"-"&[GL.xlsx]States!C$3,[GL.xlsx]June!$G:$G)
Unfortunately, it will only do the search and replace one at a time and it opens the dialogue box each time. Super duper annoying.
Bookmarks