HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

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?

select the cell you want to copy

Edit Copy (or ctrl+C) select all sheets where you want the information and
paste.

remove caps from e-mail

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"STEVE" escreveu:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

Ok..that will only allow me to paste it manually, how can I do this with
fewest keystrokes to entire 40 sheet workbook?Thanks again

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

Steve, select the first sheet, hold down the shift key and click on the last
sheet. This will select all sheets in between. Enter the date in any cell
and it will be entered in all 40 sheets. HTH
--
Sincerely, Michael Colvin


"STEVE" wrote:

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

THANKS!! Now THAT"S what I'M talkin 'bout!!!

"Michael" wrote:

Steve, select the first sheet, hold down the shift key and click on the last
sheet. This will select all sheets in between. Enter the date in any cell
and it will be entered in all 40 sheets. HTH
--
Sincerely, Michael Colvin


"STEVE" wrote:

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

Glad I was able to help. Thanks for the feedback.
--
Sincerely, Michael Colvin


"STEVE" wrote:

THANKS!! Now THAT"S what I'M talkin 'bout!!!

"Michael" wrote:

Steve, select the first sheet, hold down the shift key and click on the last
sheet. This will select all sheets in between. Enter the date in any cell
and it will be entered in all 40 sheets. HTH
--
Sincerely, Michael Colvin


"STEVE" wrote:

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?

Right-click and "select all sheets" to group them.


Gord Dibben MS Excel MVP

On Mon, 2 Oct 2006 07:49:01 -0700, STEVE
wrote:

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group

"STEVE" wrote:

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?