VBA to Split Excel Data into seperate xlsx files
Budget: $10 – $30 USD
-Split Excel File data in tab "Data" into chunks of 9990 rows.
-Map info from 'Data' tab to matching headers in 'Output' tab.
-Keep headers in rows 1-6 in Tab "Output" for each file, so data will always start at row 7.
-Save each file as "WMRepriceFile-1.xlsx", "WMRepriceFile-2.xlsx", "WMRepriceFile-3.xlsx", ect... in whatever folder location. I can edit output location.
-'Output' tab columns A-C are blank. Keep them in each file.
-Map info from 'Data' tab to matching headers in 'Output' tab.
-Grey 'Optional' columns (H & I) in 'Output' tab will be blank, but populate each output file with them.
-Map info from 'Data' tab to matching headers in 'Output' tab.
-Keep headers in rows 1-6 in Tab "Output" for each file, so data will always start at row 7.
-Save each file as "WMRepriceFile-1.xlsx", "WMRepriceFile-2.xlsx", "WMRepriceFile-3.xlsx", ect... in whatever folder location. I can edit output location.
-'Output' tab columns A-C are blank. Keep them in each file.
-Map info from 'Data' tab to matching headers in 'Output' tab.
-Grey 'Optional' columns (H & I) in 'Output' tab will be blank, but populate each output file with them.