Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one cell to another
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one cell to another
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one cell to another
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" 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking one cell to another
Thanks for your help. :) -- sjk1026 ------------------------------------------------------------------------ sjk1026's Profile: http://www.excelforum.com/member.php...o&userid=36630 View this thread: http://www.excelforum.com/showthread...hreadid=563766 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
linking to a cell within a text cell or comment | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) |