Go to. . . after data entry
 

I have a template that I enter data into. There are two different tab
that I use within the template. I want excel to jump to the second ta
after I enter data into a specific cell on the first tab and visa versa
When it jumps to the other tab I want it to go to a cell with respec
to the cell from the tab which it came.

Example:

Sheet 1 Sheet 2
E11 go to D8
F11 go to E8
. .
. .
. .
X11 go to W8

Also. . .

Sheet 2 Sheet 1
D10 go to F9
E10 go to G9
. .
. .
. .
W10 go to Y9

Thanks

--
smun
-----------------------------------------------------------------------
smunn's Profile: http://www.excelforum.com/member.php...fo&userid=2985
View this thread: http://www.excelforum.com/showthread.php?threadid=55505