Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Formatting a worksheet for data entry | Excel Worksheet Functions | |||
getting multiple data to populate another worksheet | Excel Worksheet Functions |