jump to cell in sheet2 when values in sheet1 is true

[amelia]

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.

 

[Gord Dibben]

Formulas return values.

They cannot cause any jumping from sheet to sheet.

That would have to be handled through event code.

See Chip Pearson's site for how to work with events.

http://www.cpearson.com/excel/Events.aspx


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

The only thing you can do is have a cell return the value from one cell or
another based on a condition in a formula.

=IF(C17=E17,Sheet2!A3,Sheet3!A3)

Consider for a moment what your question asked and what it would mean if it
were possible to do what you asked. Suppose C17=E17 then the cursor would
move to Sheet2 cell A3. Now you move the cursor to A4 of Sheet2. What is
happening to the formula on Sheet1 - it is still true that C17=E17 so the
cursor would move back to Sheet2 cell A3. In other words you would have
locked your cursor in Sheet2 or Sheet3 for ever.

What you might consider is a Worksheet_Change event macro. In that case it
would respond to changes in C17 and E17, not to the formula.

If this helps, please click the Yes button.

 

[amelia]

I've read through the website recommended by you and Gord..Ive a better
picture now. thanks!