Hi
I am having difficulties. All help will be greatly appreciated.
I need a VBA to copy the header and only 5 rows (could be more than 10 columns) and saved into a different workbook with the name of the original file ending with an underscore and sequence number.
Please refer to the attached file Test.xlsx (spreadsheet: Original Data) that has a header with 14 rows of data.
Then the result VBA for this attached file would be;
1) It would create 3 differnet workbooks
2) Each workbook will have the header
3) Each workbook will have 5 rows of the data (and the last workbook will have only 4 because the total number is only 14 rows).
4) The name of each workbook would be Test_1.xlsx, Test_2.xlsx and Test_3.xlsx because there are 3 workbooks created.
Thank you very much!
Bookmarks