Macro for getting information from a report

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Kamaal, if you upload the file there, I can or some one else can get the file and may be able to help you.