Previous Topic Next Topic

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

Answer 1 / 1
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
Thank you

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

CCM 2821 users have said thank you to us this month

Report

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...
Report

My email ID is kamaal_hasan2005@yahoo.co.in. If you want to send me your email ID there, you're most welcome.
Report
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.
Ask a question