C
Cindy
I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this
& 3 how would i do this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
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.
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.
C
Cindy
what if is a template and they want to put info in but not want to have the
hassle of doing this
hassle of doing this
K
Kevin B
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.
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.
I
iliace
Describe exactly what you want to have happen.
what if is a template and they want to put info in but not want to have the
hassle of doing this
- Show quoted text -
G
Gord Dibben
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
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