I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this

Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann


"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this

what if is a template and they want to put info in but not want to have the
hassle of doing this


"Kevin B" wrote:

Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann


"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this

After creating the default text do the following:

Click FILE in the menu and select SAVE AS

In the dialog box change the SAVE AS TYPE to Template.

Excel will add the xlt extension to the filename and change the save
directory to the local TEMPLATES folder.

You will have to distribute this to your user group or copy it to network
drive that everyone has access to.

To use the template click FILE in the menu and select NEW. If you're using
Excel 2000 the templates dialog box will display, if you're using 2003 the
taskpane on the right of the screen asks you to select where the template is
located. Select ON MY COMPUTER and then select the template from the list
(if it's local) or browse and locate the file from the public directory on
the network.


--
Kevin Backmann


"Cindy" wrote:

what if is a template and they want to put info in but not want to have the
hassle of doing this


"Kevin B" wrote:

Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann


"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this

Describe exactly what you want to have happen.

On Dec 4, 11:47 am, Cindy wrote:
what if is a template and they want to put info in but not want to have the
hassle of doing this



"Kevin B" wrote:
Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann

"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this- Hide quoted text -

- Show quoted text -

Sheets 2 and 3 can have formulas that link to sheet1

Select both Sheet2 and Sheet3

In A1 of Sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1) which will also be
entered into A1 of Sheet3

This can be drag/copied around.

When done, ungroup Sheet2 and Sheet3

For more on linking cells, see linking cells in help.


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 07:50:01 -0800, Cindy
wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this