Compare the last value from two different columns

[sofas]

Hello, I have two Excel sheets. In each sheet there is a column for the date. I want to compare the last date in column ("C") sheet1. If it is less than or equal to the last date in sheet2 column ("C"), nothing will happen. If it is greater, it is copied to sheet1 under Last date in column ("C") and copy it 5 times in a row

 

[awoohaw]

this will compare the last cells of each column. But, you will need VBA to insert the data into new information:
=LOOKUP(DATE(2099,12,31),Sheet1!C:C) =LOOKUP(DATE(2099,12,31),Sheet2!C:C)

 

[sofas]

this will compare the last cells of each column. But, you will need VBA to insert the data into new information:
=LOOKUP(DATE(2099,12,31),Sheet1!C:C) =LOOKUP(DATE(2099,12,31),Sheet2!C:C)

Thank you, but I want it to be in vba code with the date copied several times

 

[sofas]

This is an example of what is required. When checking that the last date in sheet 1 is greater than the last date in sheet 2, the last date in the column is copied to sheet 2_ 5 times, but in case it is equal or less, nothing is done

 

[sofas]

Hi, is there any idea that can help me?