Automatic copy paste VBA required

[sam1105]

Hello Everyone,

Please find the attached sample sheets in which i need a VBA code to copy paste data as per below requirement

currently How i copy and paste right now is
1- first i copy and paste from location to contact person in a new sheet then
2 -copy and paste 16th mar 20 whole column data against the above (point 1), so that i can get project names against employee names, location and etc.
3 - then i again repeat point 1 and filter non blanks from 1st additional project names which is next to 16th march date column (Yellow highlighted) and i paste it then i remove filter from yellow column and repeat point 1 and filter non blank in additional project names (this time its red)
4 - then again i remove filter from everything and repeat from point 1 to point 4 for 17th March date
5 - i have do this for whole month, but i get data weekly.

Important point is wherever date is mentioned should be copy and pasted with blanks and additional projects names should be copy and pasted without blanks.

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[sam1105]

I think i have updated the excel version. please let me know for any further help

[sam1105]

Can any 1 of them help on this taks?

[Pepe Le Mokko]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only 3 hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[sam1105]

Thanks for your reply...i understand it..

[sam1105]

hello..request you to help on this thread..