One way, select the sheet with the date, right click on the worksheet tab
and group sheets, select the cell with the date, F2, enter, ungroup the
sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"STEVE" wrote in message
...
HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST
AMOUNT
OF KEYSTROKES?