Hi all,
VERY new to VBA. I basally know how to open it and run the code. I need some help!
I have several workbooks that contain information that I need to be put into one summary sheet.
The rows that I need copied over start in Column A and end on Column N in each workbook. However, each workwork will have a different number of rows (some will have 100 rows, some will have 8, etc). Each workbook has only 1 worksheet "Sheet1".
I need each row from every workbook to be pasted into a summary workbook that I have already created "SUMMARY" (I need to have specific formatting so I have to use this existing sheet). I need the rows to be pasted AFTER the titles and headers and etc, which is row 10. I need the rows to paste on the next empty row.
In summary, I need:
1. To loop through all excel files in a folder
2. Copy all the rows (column A-N) starting on row 10
3. Paste in existing workbook (starting at row 10) and continue pasting in the next available row.
I wish I would have learned more about this in school. ANYTHING HELPS!!!
Bookmarks