View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default jump to cell in sheet2 when values in sheet1 is true

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