Hi Don,


Sheet 1 Cell A10 is orinigally a blank cell. if there is any data entered
onto this cell, I want Excel automatically exit from Sheet 1 and display
Sheet 2 with the cursor sitting at Cell E8.

Thanks,

Igbert


"Don Guillett" wrote:

Why don't you give us more info as to your total need so a proper solution
may be offered.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"igbert" wrote in message
...
I have Sheet 1 to Sheet 10 within a workbook.

If Sheet 1 Cell A10 is non blank, I want Excel to go to Sheet 2 Cell E8.

Does anyone have any idea?