Hi,
New to VBA and this is my first shot at some code. Trying to cycle through a user specified directory for all excel workbooks. It is going to copy two sheets from each of these workbooks back into the ConsolidatedWorkbook. Each workbook has a unique name, which i have set up as a worksheet on the main ConsolidatedWorkbook. In an ideal world, it would check if the sheet existed first. If not, create one.
All of Sheet 3 is copied over, but only a selection from sheet 2.
MY below code worked the first time i ran it, but now fails to run.
All help and suggestions welcome...like i say, first crack at coding in VBA so go easy.
Please Login or Register to view this content.
Bookmarks