| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
jump to cell in sheet2 when values in sheet1 is true
Hi,
I am using Excel 07. Is it possible to do the following? If C17=E17 in Sheet1, it will then jump to cell A3 in Sheet2. However if C17 is not equal to E17 ,it will then jump to cell A3 in Sheet3. Is it also possible to stay in Sheet2/Sheet3 once the following condition in Sheet1 is true/false? Because so far I've tried the different ways of jumping sheets but all seem to only transfer the value from Sheet2 to Sheet1, and it will stay in Sheet1. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click one cell sheet1, display all related recs on sheet2 | Excel Worksheet Functions | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| formula-add 2 numbers of cell a1 and a2 of sheet1 ans-b9in sheet2 | Excel Worksheet Functions | |||
| can i type sheet1 A5 and make it show Sheet2 A6 cell | Excel Discussion (Misc queries) | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Threaded Mode
