Copy Blank Count

[mohansingh]

Hi Experts ,


Am stuck with the code/vba code and need your help desperately.


I have a code to copy the count under PRCAT in each sheet named with dates like "14-June-15","15-June-15", etc.. to ABC sheet under each date . Am able to copy all the category count but am not able to copy the blank count for each sheet under "Un analyzed" in B202 in ABC sheet under each date. Blank will be marked as Blue in sheet like"14-June-15","15-June-15" . These functionality will be done by " Copy Count" button in the Main sheet. The code provided works when there is one sheet like "14-June-15" but doesn't work if there is more than one sheet like "14-June-15","15-June-15", etc..


Also if there are blank count at the end of PRCAT then they are not copied . But they should be copied also.




Code provided below and sheet attached.


https://www.dropbox.com/s/8uvlahazknvtei4/ABC June 14 - June 20.xlsm?dl=0


Thanks & Regards,


MS

 

[mohansingh]

Hi ,

Can anyone help me here please ?

 

[mohansingh]

Hi,

Can any experts help me here. Waiting for long time on this. I am aware this is the best forum with best experts in excel. Some one please please please help me.

Regards,
MS
Thanks in Advance