Hello,
I am working on a problem where I have to write a VBA code to do the following:
1. Use source file "Sales Data1"
2. Create new workbooks for each Product Code letter i.e. Workbooks A, B, C
3. Create new worksheets within each workbook corresponding to each Product Code i.e. Workbook A, Sheets A01 - A045
4. Copy rows based on Product Code value and paste in the corresponding workbook/worksheet i.e.
Row containing data for Product Code A01 gets copied to Workbook A, Worksheet A01
5. Each row copied should be pasted to the next row in the destination sheet.
6. Close all workbooks except for "VBA Macro" file
7. Create button within "VBA Macro" file to execute all of the above.
I've written Steps 1-3 highlighted above. I'm having trouble with the rest.
Attached folder contains 2 files "Sales Data1" and "VBA Macro"
Many thanks
DP
Bookmarks