hello all,
I have a progress log that tracks the various stages of our part numbers in the certification process. I had asked in a previous thread, http://www.excelforum.com/excel-prog...ml#post4587898, how to populate unique part numbers based on their condition to another sheet. Now, I would very much like to have the entire workbook completely dynamic, if possible. My ideal process would be to enter information into the master, and if that data is changed in the master, then the macro will look for that part number in each of the other sheets, and update them accordingly.
But here is another tricky part... there will also be some editing on the certification process worksheet, such as marking when certain steps are completed. I would like THIS data to also be completely dynamic with the other sheets.
I have tried a few formulas in order to make this happen, and they have been working... however, I have already noticed the program running slower and slower, and it will only get worse as I input new data. So I am hoping a macro will help, but I apologize that I don't have one currently to show you.
I have attached an example of my workbook so that you may better understand what I am trying to do. Any help is appreciated!
thanks in advance,
Riley
P.S. I am not sure how to link a previous post, so i'm sorry if i messed it up!
Bookmarks