Macro to copy dated items on one sheet to formatted calendar on second sheet

Hello,

Workbook I am making is attached.

I could use some direction or assistance in adding code that will take the data on the "FLIGHTLIST" worksheet and copy it to the corresponding locations on "CALENDAR" sheet.

I only need to copy columns B, C, D, and E from "FLIGHTLIST" to the four columns under the appropriate date on "CALENDAR." I do not need to carry over the table header/

Any help would be greatly appreciated!

Are u want this?

Please Login or Register  to view this content.

Wow, that is ALMOST exactly what I am looking for, thanks!
Is there a way to do it so it populates on the Calendar sheet and preserves the Flightlist sheet?
Just wondering.

Never Mind =) I saw what you did.

This is EXCELLENT! Thank you VERY MUCH!

As your #3 request, please try this: