Linking one cell to another

[sjk1026]

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

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

Any help would be greatly appreciated

 

[Guest]

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.

 

[Guest]

The following code jumps to a different cell on the same worksheet when a
change is made to a particular cell. It needs to be pasted into the code
module for that worksheet.

'ExpInput is range name for expense input cell.
'ExpExplain is range name for expense explanation cell.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("ExpInput").Address Then
Range("ExpExplain").Activate
ActiveCell.Select
End If
End Sub

This take the user to the other cell. As for HAVING to enter additional
information, that's best achieved by communicating and enforcing a consistent
policy (expenses will not be approved until explanatory detail has been
provided).

Hope this helps,

Hutch

 

[sjk1026]

Thanks for your help.