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



wrote:

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.