Print thru using EXCEL 2007

[pcor]

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

 

[RagDyer]

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".

 

[pcor]

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]

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 !
-----------------------------------------------------------------------------------------------

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

 

[gls858]

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

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

gls858