Duplicating Text To Another Spreadsheet

[The Inquirer]

I created a form in Word, cut and pasted it into Excel on three different
spreadsheets.
How can I format the spreadsheet to copy text to the other two spreadsheets
without having
to enter text three different times?

Please advise and thank you in advance

 

[Gord Dibben]

Check out Excel help on "select multiple sheets"


Gord Dibben MS Excel MVP

 

[The Inquirer]

Unfortunately, I found no information when I typed in "Select Multiple
Sheets"
What I mean is, for instance, when I enter data or text into one
spreadsheet,
I want it to copy over to the other spreadsheets. How can I accomplish
that?

Thanks in advance.

 

[Gord Dibben]

From help on "select multiple sheets"

Select one or multiple worksheets

If you want to enter or edit data on several worksheets at the same time, you
can group worksheets by selecting multiple sheets. You can also format or print
a selection of sheets at the same time.

Two or more adjacent sheets Click the tab for the first sheet. Then hold down
SHIFT while you click the tab for the last sheet that you want to select.
Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down
CTRL while you click the tabs of the other sheets that you want to select.
All sheets in a workbook Right-click a sheet tab, and then click Select All
Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands
relevant to a particular item. To display a shortcut menu, right-click an item
or press SHIFT+F10.).

Tip When multiple worksheets are selected, [Group] appears in the title bar at
the top of the worksheet. To cancel a selection of multiple worksheets in a
workbook, click any unselected worksheet. If no unselected sheet is visible,
right-click the tab of a selected sheet, and then click Ungroup Sheets on the
shortcut menu.

Notes

Data that you enter or edit in the active sheet (active sheet: The sheet that
you're working on in a workbook. The name on the tab of the active sheet is
bold.) is reflected in all selected sheets. These changes may replace data on
the active sheet and, perhaps inadvertently, on other selected sheets.
If sheet tabs have been color-coded, the name of the sheet tab will be
underlined in a user-specified color when selected. If the sheet tab is
displayed with a background color, the sheet has not been selected.


Gord