In Sheet1 ColA contains today's date and ColB contains morning. ColB of the next row on the same sheet contains evening.

Now what I want is that in another sheet the macro will copy and paste the data in today's date in the morning row and in the evening row. Can any body help me with the coding please?

Thanks
Nilan