Hi all,
What I am trying to do is copy any worksheets from one file (source) to another workbook (target) which don't already exist in the target file. Is there a way to loop through and compare each of the worksheet names and only copy the new ones while ignoring those that are already in the target? I need to perform this function daily to copy my office's schedule and reformat it for printing. I had it set up to always go to the last worksheet in the source file and copy it to the target but then I learned that two or three new schedules are sometimes dropped at the same time. This is where the looping will come into play. It may take a little bit longer to run but I need to make sure all new sheets are copied and reformatted each time I run the macro. Any help would be greatly appreciated. Thanks.
Tom
What I am trying to do is copy any worksheets from one file (source) to another workbook (target) which don't already exist in the target file. Is there a way to loop through and compare each of the worksheet names and only copy the new ones while ignoring those that are already in the target? I need to perform this function daily to copy my office's schedule and reformat it for printing. I had it set up to always go to the last worksheet in the source file and copy it to the target but then I learned that two or three new schedules are sometimes dropped at the same time. This is where the looping will come into play. It may take a little bit longer to run but I need to make sure all new sheets are copied and reformatted each time I run the macro. Any help would be greatly appreciated. Thanks.
Tom
