PDA

View Full Version : Report creation



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

rajagopal
03-23-2009, 11:23 AM
Please find the base file as i was not able to attach it earlier.

rajagopal
03-23-2009, 10:30 PM
Can any one help with my requirement?

Simon Lloyd
03-25-2009, 12:51 AM
rajagopal, the email system here is NOT for you to get answers to your questions quicker, if you abuse the system again you will incur a short ban!

rajagopal
03-25-2009, 12:53 AM
My sincere apologies..

rajagopal
04-02-2009, 07:09 AM
Can anyone help for my requirement?