Hey all,
I'm new to programming, and have been writing a VBA code for the following:
Run code from master book
open data books (call them Dat1 & Dat2 but there will be about 200)
copy data from only certain sheets in Dat1 & Dat2 into Master Book
The copy data from only certain sheets is where I am running into a problem. I have set this up by making it to where the sheet name of the Dat1 has to match the sheet name in the Master Book, and when they don't make i generate an error. I had a Error GoTo statement in my code, but it seems to crash after the first pass with an error.
I want the code to be able to ignore the unspecificed sheets, and copy the desired ones.
here is my code:
Bookmarks