Print thru using EXCEL 2007
 

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

Print thru using EXCEL 2007
 

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

Print thru using EXCEL 2007
 

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

Print thru using EXCEL 2007
 

I don't know how.
You might be able to do that with code.
Post to the programming group.

You do have 2 notifications of "grouping" though:

In the Title Bar, after the WB name, "GROUP" is displayed,
And the sheet tabs are all white.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"pcor" wrote in message
...
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

Print thru using EXCEL 2007
 

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