You might be able to use a Worksheet_change event and put the code to get the
the correct location based on the entry location.

"sjk1026" wrote:


Okay, I'm trying to link one cell (business expense - lunch) to another
section on the spreadsheet which is where they explain where, when and
with whom they had lunch.

Once they enter the dollar amount for lunch is it possible for them to
automatically be taken to the other cell where they will HAVE to put in
the additional information?

Any help would be greatly appreciated.


--
sjk1026
------------------------------------------------------------------------
sjk1026's Profile: http://www.excelforum.com/member.php...o&userid=36630
View this thread: http://www.excelforum.com/showthread...hreadid=563766