Data entry in multiple worksheet

B

Brava

I am using Excel 2003. When I enter data in a cell on the first worksheet
it is also entered in each matching cell in all the other sheets in that
book. Any ideas.
 
B

bob777

make cell A1 in sheet 2 equal to cell A1 in sheet 1 etc etc

in sheet 2 in cell A1 =sheet1!a1
 
U

ufo_pilot

There may be a formula in each of the 'reading' cells or a code to copy
cells over from one worksheet to another.
 
K

Kevin B

You can reference the other cells with a formula similar to the one below:

=Sheet1!A1
 
F

flummi

Maybe you incidentally selected all sheets.

Hans

Select sheets in a workbook

If you select more than one sheet, Microsoft Excel repeats the changes
you make to the active sheet on all other selected sheets. These
changes may replace data on other sheets.

To select Do this

A single sheet Click the sheet tab.


Two or more adjacent sheets Click the tab for the first sheet, and then
hold down SHIFT and click the tab for the last sheet.

Two or more nonadjacent sheets Click the tab for the first sheet, and
then hold down CTRL and click the tabs for the other sheets.

All sheets in a workbook Right-click a sheet tab, and then click Select
All Sheets on the shortcut menu.
 
Top