All,
I have developed a system at my place of work that we use to track information from our machinery lines(how much we ran of certain models, scrap, downtime, etc). This inforamtion is then pulled from various other files in sub folders(Quality information, passdown information, etc.) These are all within a master folder. As you all know with the limits of excel, anything in a sub directory of the directory you are copy-pasting, does not update. Is there any sort of macro that can be made that will go through and update certain sections of multiple formulas in cells across a whole workbook to re-establish the link with the newly copied and renamed folders? For example part of a formula contain this "C:/Example/Master/DirectRun/1st Shift.xlsx" and since this is within a sub folder of the master folder itself, this link does not update automatically, I need it to be able to update to things like "C:/Example/{Month}/DirectRun/1st Shift.xlsx"
I will be honest I have no experience with macros at all, I have been going over the forum and I have found topics about how to START this type of macro but have not found a detailed enough article on how to fully enact something of my EXACT needs. I am learning as much about macros as I can in the time that I can do it in so please do no thing that I am just trying to get a one time pass so I can be on my merry way part of my job relies on Excel experience so I am on this forum every single day working on learning this part of excel.
Thank you all,
Jeremey