I messed around with Screen Updating and Automatic and Manual Calculations this morningand it shaves a few minutes off the 6.25 hours roughly. But it will probably end up being used (anything helps)
I wrote the if statement that way hoping it would speed up the process (If the cell was blank or equal to 12 it would simply move on to he next row faster before calling on the Goal Seek) it shaved off a few minutes but if I only need to it change 27 cells I can't have it check all 75500 before it saves the file.
Bookmarks