How to split data into multiple worksheets by rows count in Excel?
When you work in SAP Data migration, you'll be automatically forced to get more comfortable with Mircosoft Excel because of the extensive use of spreadsheets functionality to migrate data from non SAP systems to SAP. But SAP's mass updation tool - MASS has a limitation. It will process 6000 records maximum at a time for certain programs. Recently I had a situation where I have to upload 1.1 lakh entries into SAP, which means I have to split the entire data load into 20 jobs. It is not only cumbersome to split manually the 1.1 lakh entries into multiple sheets of 6000 each, it will also lead to manual errors & system performance issues.