Compare Two Columns In Two Different Sheets Then Copy Paste

Hello,

I am looking for a help in VBA. I am always copy past manually around 250-300 records on daily basis.

The request is, I need to look column CE values from worksheets (Main Sheet) to column A in worksheets (List) and copy to the min sheet if the value match.

For example:
From Main sheet if the value 3126 found in worksheet list then copy the value in same row to the Main Sheet and also copy the column c date into Main Sheet.

But while pasting the date it should 1 year previous date as the date in worksheet List is end date and I have to put start date.

Sample workbook is attached for your reference.

Thanks Mike for your response,

I mean to say while copy the data from worksheets List can we change the date 1 year back.

Let say if record 3126 found in the column and copy the date from column B as it is but for column C if should return 25-12-2017.

If can be possible it is Ok or just need to copy the data.

Thanks mike it is working but I forget to mentioned a validation.

The validation is on worksheets Main Sheets if the cell value on column CM is "CCHI Expired" and CE cell value is matching on worksheets List column A then only it will copy the value. Can it be possible.

And 1 more thing the date is converting to 1 year previous but the day is not correct.

When you copy it will be 25-12-2017 but your script is keeping the day same and changing the year.

Thanks for your response.

it is working but it is overwriting all the records. but I need to change the dates only for the cell value which is CCHI Expired in column CM.