This may be a easy question. But i am merging multple workbooks into a single workbook. The process is pretty tedious, but its going well, BUT, i am running into issues, trying to track down the references/links to the previous workbooks the sheets were in. The Edit > Links, is of no use, it tells me where its referencing, but i need to find the cells so i can update the formualas accordingly, to keep everying on one workbook. Is there an easier process to accomplish this? I have managed to trace a large portion of the formulas and correct them, but going thru each cell frm A1:IV65536 will be VERY time consuming. Any help would be appreciated.
Bookmarks