VBA Macro to Copy data - Error " Run-Time error '1004':

[MaunishP]

Hi Team,
Could you please check below given error while running macro >

I tried to replace VBA code, however some glitch happed which turned this error. How to get rid of it. Please find attached file also along with VBA code

I havent pasted VBA code here due to character limitations.

Regards,
Maunish Patel

 

[MaunishP]

Pavan.S helped me a lot in my previous post regarding data collecting. Now its time for upgrade

Team, Please help here in this VBA error glitch

 

[Nebu]

Hi:

Please find the attached its working without any error at my end.

Thanks

 

[MaunishP]

Hi Nebu,
Data is showing incorrect on dashboard. Also each sheet has some data, still data is not copied on Dashboard!

Also Check worksheet Reaff Audit, count is showing 108 however dashboard is showing 1386.

Each sheet data needs to be pasted on said header name on dashboard.

Regards,
Maunish Patel

 

[Pavan.Sada.PS]

Hello MP,

Check the attached file..

My codes should work if you clear the below glitches from your file which is currently impacting your final output in the dashboard sheet.

1. I still see that there are some merged cells in the input sheets like (Reaff Emails sheet - Range (W5) and Reaff Audit sheet all the cells in row 5 and so on many sheets have the same issue.

2. Repeated names in the same sheet like Hardik Shah is available twice in Reaff Emails sheet in cells C5 and M5 as well.

regards,
Pavan S

 

[MaunishP]

Yes, Pavan again you are genius !! It worked !!! Awesome !!!