SAME INFO ON ALL PAGES AT ONCE

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

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.
 
what if is a template and they want to put info in but not want to have the
hassle of doing 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.
 
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 -
Click to expand...
 
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
 
Back
Top