united2017
New Member
- Joined
- Jun 17, 2017
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a data file consisting of 8 columns (around 50K rows) and I want to split this into multiple workbooks.
Column 5 - has the supplier number and the data in the file is sorted by this supplier number - I want to create separate workbooks for each supplier - and the File to be named the Supplier Number.
I have a data file consisting of 8 columns (around 50K rows) and I want to split this into multiple workbooks.
Column 5 - has the supplier number and the data in the file is sorted by this supplier number - I want to create separate workbooks for each supplier - and the File to be named the Supplier Number.