Hi everyone!
I've give myself a project to do. Normally I used a program at work to do the data downloads individually, export each one to excel, and then save them one at a time and name them by their "Order Number." The order number is unique per data set and is a 9-digit number that always starts with a 3.
Today, instead of doing about 80 separate downloads, I tried to group them together into one large download. Success! Now I have one massive file (11,000+ rows of data)(changes month to month. Can be anywhere from 8,000 to 14,000) with no spaces in between the order numbers.
I was hoping to create a macro that could split my single .xlsx file into as many workbooks as there are order numbers (around 80) and save them (name them) as their order number. Also, I would like the first row to be the first row in every new workbook make (field names)
So what do you guys think, is this possible? (Attached is a sample with all the relevant work info taken out)
Bookmarks