Hello. I have created a large amount of Excel sheets with summary tabs for my team, many of whom are not the best at Excel. Each of these has formulas pulling from other Excel workbooks and sheets. Creating them to work the first time is no problem, but these need updated for each project we do and this is time-consuming for me to do each week and remotely since my team is scattered all over the USA. Basically, the file path in the formulas I use will need to change to reflect the new folder the file will be in and the new name of the file. Each project gets its own folder and file name (for example, they have one right now for Illinois in a folder titled 'Illinois Review' with a file name of 'Illinois Summary'). Is there a way to quickly update all the formulas in a given sheet using macros or something similar? I cannot quickly just change one formula and auto-fill since the sheets are extremely large and have many cells that are skipped over or contain nothing that needs summarized.
I hope that question is clear. Please let me know if you need more information. Thanks in advance for any help!
Bookmarks