Code string for button
Hi,
I have a command button called €śCompare€ť and I would like it to do the
following when pressed;
1) Compare the date in cell h2 on sheet1 to today's date, if the date is
older than todays date, copy data in cells h7:h12 to j7-j12 on sheet2.
2) I would then like the date in cell h2 on sheet1 to change to todays date.
Thanks for any help with this,
Newbeetle
--
This post was created using recycled electrons!
|