stratplayer
New Member
- Joined
- Jun 11, 2015
- Messages
- 9
Hi everyone I have done lots of work to take a 20,000 line file and cleanse it into the key elements required to split amongst our team to work on, I did it using VBA and it was only the 2nd attempt at doing such a thing. I am sure if I posted it then lots of people would improve my work, but before I do that I want to do the following if possible and am looking for some guidance in how to do so.
Working on a worksheet named "Working Data"
Prompt user for how many worksheets/files to create for data
Split worksheet into X seperate worksheets. So if there were 10,000 lines (top being a header) and the user selected 4 files then it would seperate it into 4 x 2500 (although last would be 2499). However, in Column C there is a unique ID that ideally I want to keep together in one file. So can the selection keep selecting until the next entry in the file in Column C is unique, then create the worksheet. The remaining data "Working Data" is then split 3 ways, again using same technique... until there is nothing left after a total of 4 passes.
Then saving each worksheet one as 20180715_username where the end user is prompted for the name to save
I appreciate this is a big ask, well in my opinion, any help would be massively appreciated.
Working on a worksheet named "Working Data"
Prompt user for how many worksheets/files to create for data
Split worksheet into X seperate worksheets. So if there were 10,000 lines (top being a header) and the user selected 4 files then it would seperate it into 4 x 2500 (although last would be 2499). However, in Column C there is a unique ID that ideally I want to keep together in one file. So can the selection keep selecting until the next entry in the file in Column C is unique, then create the worksheet. The remaining data "Working Data" is then split 3 ways, again using same technique... until there is nothing left after a total of 4 passes.
Then saving each worksheet one as 20180715_username where the end user is prompted for the name to save
I appreciate this is a big ask, well in my opinion, any help would be massively appreciated.