Copy paste code required

Hello Everyone,

Please find the attached sample sheets in which i require 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.

Any help would be appreciated..

Hi sam1105

Here is a very basic entry level code...

Please Login or Register  to view this content.

Hi,

Thank you for your time and your code works perfect..

Just want to add one more thing which i missed in my previous post.. can i get a column of dates in the end. Attached example sheet. (Solution test sheet highlighted in yellow)

Attached example sheet

Where.....?

Done...post edited and attached

Please Login or Register  to view this content.

It works like a charm!..Absolutely brilliant work. Thank you for your time and help.

Thanks a ton :-)

Glad I could contribute...Tx for rep

A little more speed can never hurt

Please Login or Register  to view this content.

Thanks Vraag en antwoord , as you rightly said this works faster and deliver results quickly.. thank you both ( Sintek and Vraag en antwoord)

Hi Vraag,

I just noticed that code which you have provided copy and paste with blanks, not as i mentioned or as sintek provided. i have few criterias while copy paste which i have mentioned in 01st post where sintek code works properly.