Data entry in multiple worksheet
 

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.

Data entry in multiple worksheet
 

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

in sheet 2 in cell A1 =sheet1!a1


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=508897

Data entry in multiple worksheet
 

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

"Brava" wrote:

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.

Data entry in multiple worksheet
 

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

=Sheet1!A1

--
Kevin Backmann


"Brava" wrote:

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.

Data entry in multiple worksheet
 

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.

Data entry in multiple worksheet
 

Thanks for all advice Iseem to be getting it ok now I hope



"Brava" wrote in message
...
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.