Macro for getting information from a report

Closed
Kamal Hassan - Aug 4, 2010 at 07:18 AM
rizvisa1 Posts 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
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...
My email ID is kamaal_hasan2005@yahoo.co.in. If you want to send me your email ID there, you're most welcome.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.