Is this possible? I know there are ways to combine all files in a folder, but this would be very useful. Here is what I would like to be able to do.
(Call workbook containing macro book1.xlsm)
1. User Starts Macro
2. Promt user to give file locations
3. Open Works
4. Copy all cells from sheet 1 of the first location into book1.xlsm sheet 1 cell A1.
5. Repeat 3 for second location. Copy data in column A where ever other data stops
6. Close Workbooks
7. Macro continues to format data as desired.
Is there anyway to be able to vary the number of workbooks being combined? Could it ask the number of workbooks to be combine then get that many files names? Could it keep asking for file names until user tells it to combine?
Bookmarks