macro or vba code for copying and pasting data from one worksheet to another

hi there,

need some help guys on getting a macro or vba code for copying data from one worksheet to another. on the attached file, i have mentioned on dark grey filled with bold text the constant parameters i need to copy or transfer every day on the dBase sheet next to it. can you please help me setting up a code that will work for this situation? i find it really hard to construct a vba code that will pull up the date, description, vessel type, etc. etc and paste it on the next sheet.i would like to have it on a single button that after clicking it auto populates the data i need on the other sheet on the corresponding headings. also, i want to protect the data into it to make sure that nobody can mess around with it . would appreciate any assistance. thank you very much for helping out.

Sure, this can be done.

Do you also need the rows in green and orange/magenta to be copied as well? Like rows 19, 24, 35, 36?

hey guys,

thanks for the reply.

arlu1201 no, i don't need to copy the cell formatting. only the values is where i am interested at.

royUK basically i want the code to look for the date field on the daily report sheet then copy the values on the columns of description, vessel type, tow, FOB, Bunkered, FW, POB, Current Location, Destination, Daily Breakdown Hours.

please help.thanks....

What should the date field be compared to?