I've got a LARGE WB (an extract from a legacy system that's been switched off!) that I need to process but it's soooo slow!
Plan is to spilt it into multiple WBs (manual test shows it will perform better as smaller WBs) ...
Every record has a 6 digit ID (NOT a record ID so there can be multiple rows per ID) and I want to split the file by ID range so that all records for a particular ID are in the same file ...
Is there an easier way than doing it than manually (which feels a bit tedious!)?
Thanks ...
Plan is to spilt it into multiple WBs (manual test shows it will perform better as smaller WBs) ...
Every record has a 6 digit ID (NOT a record ID so there can be multiple rows per ID) and I want to split the file by ID range so that all records for a particular ID are in the same file ...
Is there an easier way than doing it than manually (which feels a bit tedious!)?
Thanks ...