email and copy data to another sheet in matching row

Hi,
I have been helped by many experts and Gurus to arrive at this code. Mainly thanks to JB Sir. I have further modified it.
Now I need further help please.
Present code works fine for sending email, saving it as PDF etc..

My main concern is copying some of the cells and pasting them to another sheet as text, but with a twist. Please see red text below where I need help..

Please Login or Register  to view this content.

I want sheet1 range C68:I68 copied as text to sheet2 , however in sheet1 B68 is today's date and sheet2 range A:A is having all dates starting from 01 Jan to 31 Dec.
So I want to modify the code in such a manner that C68:I68 is copied from sheet1 and pasted to range B:I against corresponding date in sheet2 .
It means it will:
First copy C68:I68
Then look for matching date of B68 of sheet1, in column A of sheet2
Then paste B68:I68 into sheet2 range B:H, against the matching row which has the same date as B68.

Hope I have been able to explain it correctly.

Many thanks
Regards

Thanks Wenqq3,
I will try and get back
Regards

Hi,
So far so good.
It is copying alright but pasting it to right place seems difficult. It simply will not do it.

Please Login or Register  to view this content.

We are close.... but little away from getting it right.

What do you say?
Thanks
regards

I do not know the other parts of the code, but for the red part, these should do.

Please Login or Register  to view this content.

Hi,
Apology for a late reply. I was trying various combinations, however the above suggested codes and my combination did not work as intended.
I have now adapted a another approach, and its more simple than the one before.
Email part is good, so I am not changing it.
Only copying part is now changed , where I need your help.
This extension of code will be after email part...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks Great . It works fine by itself....
Now how do I combine with email code??

That is after the last line of email code ' Display 'or use .Send
Really great work. Thanks
Regards

It works like a magic now.
I have learnt the mistakes that I was making..... Silly though
My words will short to thank you.
Many thanks
Regards

Hi wenqq3 & AB33,
Once again thanks for your support and great help.
I have clicked * for you to thank you
Regards