Macro for getting information from a report

Closed
Kamal Hassan - Aug 4, 2010 at 07:18 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 6, 2010 at 11:02 AM
Hi

I have a report in excel. I want to extract the data from that report to another worksheet with much consolidated information.

For example,

Column A Column B
Name <Want to get this information from that report>
Emp. ID <Want to get this information from that report>

Can someone please help me by providing the coding that I can use to make a Macro in MS Excel?

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 4, 2010 at 08:33 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
1
Thanks a lot RIZVISA1.

My name is Syed Kamaal Hasan Naqvi. Dear why don't you give me your email address so that I can send you the excel worksheet on which I would like to run the macro?

Waiting for your response...
0
My email ID is kamaal_hasan2005@yahoo.co.in. If you want to send me your email ID there, you're most welcome.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 6, 2010 at 11:02 AM
Kamaal, if you upload the file there, I can or some one else can get the file and may be able to help you.
0