Hi, am new to this forum, need a macro to convert raw data to final output. Here are the steps:
1. There is a raw data in sheet1 - Wrap text to fit the cells.
2. Sort by FULL_NAME Column, label sheet as Total.
3. From Total sheet, Separate open and deactivated records from the full name column and paste it in next sheets labelled as open and deactivated respectively.
4. Now rest of the records apart from open and deactivated records, sheet name should be saved as Active.
5. Now delete AHW002, CHW002, PVD002 AND TNT002 from ENTITY_SHORT_NAME column from the Active, Open, Deactivated sheets. But do not delete from Total Sheet.
6. Now create another sheet as Count, create a table which shows the total count of records of Active, Open, Deactivated and Deleted (The ones which are deleted - AHW002, CHW002, PVD002 AND TNT002)
1. There is a raw data in sheet1 - Wrap text to fit the cells.
2. Sort by FULL_NAME Column, label sheet as Total.
3. From Total sheet, Separate open and deactivated records from the full name column and paste it in next sheets labelled as open and deactivated respectively.
4. Now rest of the records apart from open and deactivated records, sheet name should be saved as Active.
5. Now delete AHW002, CHW002, PVD002 AND TNT002 from ENTITY_SHORT_NAME column from the Active, Open, Deactivated sheets. But do not delete from Total Sheet.
6. Now create another sheet as Count, create a table which shows the total count of records of Active, Open, Deactivated and Deleted (The ones which are deleted - AHW002, CHW002, PVD002 AND TNT002)