If Cell Sht 1 = X, Copy Paste Other Sheet Same Cell Location

.
Can someone guide me to a resource demonstrating how to copy a cell value from Sht 1 and paste that value in Sht 2 in the same cell location ?

In other words, if any cell.value on Sht 1, Range H4:P100 <= 60 Days from Today's date, copy the Sht 1 cell value and paste it into the same cell location in Sht 2.


Thank you !

.
jeff

Thank you for your response. Unfortunately, the macro is not working. No errors / no copy or paste.

???

.
Dates are entered manually with Conditional Formatting for background color.

I changed the DATE format to US English. Your file examples was in Armenian. It works with Armenian but the DATE format is wrong.

.
Weird. For some reason when I downloaded your file, it was set to Armenian.

Gotta love Excel !

Well, I thank you for giving me assistance. I'll mess around with it and see if I can get it working here. I apologize that it isn't.

.
Jeff:

Go figure. It is now working.

The only thing I did was change the IF statement from the <= 60 to tracking the Interior.Color of the cell. With the
color tracking it worked for a short bit, then quit.

I changed the IF statement back to the 60 day formula and viola ! It is working (at least now it is). I'll wait to see what occurs
tomorrow. *laugh*

For some reason, my copy of Excel has gremlins. Using ver 2007 MS Office Professional. Ever since I've had it, it has done
really weird stuff that no one has heard of before.

Maybe I need to perform an exorcism on it ?

Thanks for your help. I'll mark this solved.

.
Brilliant !! Thank you.

Cheers.