Hi
I have the following code that cycles through my workbook (currently has about 150 sheets so is very large) and copies certain values to my main sheet. It is extremely slow.
I am wondering if there is a better and faster way to do this? I also update my workbook frequently so when I add a sheet, I need to run the code all over again, which is very frustrating. I am looking for a way to also just update based on the sheet I have just added?
This is just one part of the code - it is repeated three more times however I cannot post here as it is too long!
Please Login or Register to view this content.
Bookmarks