rajagopal
03-23-2009, 11:22 AM
I've a excel file which has the data of scores userwise.
The users are classified into Group A, Group B based. I will be receiving these data on a daily basis.
I'll open the excel file - Test macro2 and a macro has to be executed to do the following:
1. From Test macro file, the data given for the user ids 673BF,674PB,675CA,677EG,678JD,679AH,681MM,682PF,683LH,686CH
has to be shown in a separate sheet in the same excel file and their details have to be deleted from the main sheet. Rename the sheet as CD_Group B
2. The rows occupied by the above user ids have to be deleted from the main sheet. Rename the sheet as CD_Group A
3. Create a new worksheet and name it as Snapshot.
4. Provide the sum details categorywise. Refer Sample output file
The users are classified into Group A, Group B based. I will be receiving these data on a daily basis.
I'll open the excel file - Test macro2 and a macro has to be executed to do the following:
1. From Test macro file, the data given for the user ids 673BF,674PB,675CA,677EG,678JD,679AH,681MM,682PF,683LH,686CH
has to be shown in a separate sheet in the same excel file and their details have to be deleted from the main sheet. Rename the sheet as CD_Group B
2. The rows occupied by the above user ids have to be deleted from the main sheet. Rename the sheet as CD_Group A
3. Create a new worksheet and name it as Snapshot.
4. Provide the sum details categorywise. Refer Sample output file