Excel Macro to Copy a cell from multiple sheets into a Single sheet based on a value

[prakashv23]

Hi All,

I am new here and am trying to learn VBA, need assistance on a excel report I am creating.
I have an excel document with multiple excel sheets(sheet1, sheet2...etc), now every sheet contains a cell "total".
Now I want to copy the row containing "total" from all the sheets into another sheet called "report".

 

[kevatarvind]

same code is working in my file correct i have already checked before post this code here

if you are facing problem then pls upload your file any sharing site and paste link here

 

[prakashv23]

same code is working in my file correct i have already checked before post this code here

if you are facing problem then pls upload your file any sharing site and paste link here

Thanks for the response kevatarvind. If it works on you're end ...then it should on mine too.
I am checking the excel doc for any formatting that might be causing an issue.
I would try to validate and keep you posted. In case I run out of options ....sure will upload a file for your assistance.

Thanks again and have a nice day

 

[prakashv23]

It was a formatting issue.
I was able to fix that, i tried this on multiple sheets and its working fine now.

Thanks a lot kevatarvind.

 

[kevatarvind]

Thanks For The Feedback

Your Welcome

Come Back Anytime