| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
can I change the values in two worksheets at the same time
I have two different worksheets, some of the values on worksheet 1 is the
same as that on worksheet 2. Is there a way that I can use a formula so that when I change values in worksheet 1 it is automatically changed on the other sheet? I have to mention that I am very new to using excel and formulas. Any help would be much appreciated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I change the values in two worksheets at the same time
Hi,
Put this in any cell on any sheet and if a1 on Sheet 1 is changed then this wil update the cell on that sheet =Sheet1!A1 Mike "jpduck" wrote: I have two different worksheets, some of the values on worksheet 1 is the same as that on worksheet 2. Is there a way that I can use a formula so that when I change values in worksheet 1 it is automatically changed on the other sheet? I have to mention that I am very new to using excel and formulas. Any help would be much appreciated. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I change the values in two worksheets at the same time
Easiest method is to link the cells from Sheet1 to Sheet2 Select the cells in Sheet1 and Copy. Go to Sheet2 and select a cell and EditPaste SpecialPaste LinkOKEsc. Change values on Sheet1 and Sheet2 will also change. Gord Dibben MS Excel MVP On Mon, 13 Oct 2008 04:48:01 -0700, jpduck wrote: I have two different worksheets, some of the values on worksheet 1 is the same as that on worksheet 2. Is there a way that I can use a formula so that when I change values in worksheet 1 it is automatically changed on the other sheet? I have to mention that I am very new to using excel and formulas. Any help would be much appreciated. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I change the values in two worksheets at the same time
a quick thanks to both of you for your help with my problem. Very much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| How can you draw a shape when the values change each time?? | New Users to Excel | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
| Can you paste values on multiple worksheets at one time? | Excel Worksheet Functions | |||
Hybrid Mode
