URGENT - Macro to split up excel file required
Closed - This job posting has been filled.
I need a simple macro to split up a large txt/csv/excel file (150,000 rows) and save it as multiple files.
Ideally I would like a pop up box to ask me which file to split
then how many lines to split (eg batches of 5000 or 10,000 etc) or you could just say split number of lines equally into a given number of files (eg 15 files or 30 files etc).
It is very important that the data doesn't get altered eg numbers truncated etc. Barcodes should remain in 13 digit format as 0000000000000 not 0000000+12 etc.
Ideally I want nothing touched in the files apart from the number of rows.
Also the macro could be run on various different files with differing numbers of columns, so really it just needs to look at number of rows and split these down.
However you do it I need this back today.
PLEASE look at my other jobs as I have other tasks required.