pcor wrote:
That works very well thank you.
Now here is another..Is there a way to change the background color of the
sheets once they have been "Grouped" and returned to their original color
once they are "UNGROUPED"
Thanks

"RagDyer" wrote:

Before you start "inputting", click on the Sheet1 tab, hold down <Shift and
click on the Sheet3 tab.

This groups the sheets.
Anything done to one, will be done to *all* in the group.

When finished, don't forget to separate them.
Right click in a tab and choose "Ungroup".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pcor" wrote in message
...
I am inputting data in sheet 1 col A to G
I want that same info to "PRINT THRU" to Sheets 2 and 3. Can you tell me
how?
Thanks



If you just want to know if sheets are grouped or not notice that the
tabs turn white when sheets are grouped.

gls858