| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jump to cell based on cell results created by calendar control too
I have a calendar tool linked to cell A1. I have a table in B1:C255, where
column B lists the dates that can be chosen by the calendar and column C lists the cells I would like them to be directed. In A2 I have a vlookup to find the cell destination based on their calendar choice. So far, I can get excel to do the vlookup and find the cell I want them to go to, it's just a matter of getting the code to have excel automatically "jump" to the cell that results from that vlookup. Thanks for any help you can give :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Calendar control on cell enter? | Excel Worksheet Functions | |||
| Formatting one cell based on results of another cell | Excel Discussion (Misc queries) | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Threaded Mode
