| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goto or Find a Date in a Sheet
Hi, I have a large sheet with dates going back to 2000 through to (at this
stage) 2012 in column A, the rest of the data across is personal details for that day. I want to be able to make a button bring up a box that I can enter a date, and then when I click go or enter it will go to the date entered. I did try the F3 find command, but this did not do what I wanted. Can this be done? Any ideas? Thanks Kev. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Goto or Find a Date in a Sheet
Use CNTRL-f
be careful of the formats. -- Gary''s Student - gsnu200776 "Kev - Radio Man" wrote: Hi, I have a large sheet with dates going back to 2000 through to (at this stage) 2012 in column A, the rest of the data across is personal details for that day. I want to be able to make a button bring up a box that I can enter a date, and then when I click go or enter it will go to the date entered. I did try the F3 find command, but this did not do what I wanted. Can this be done? Any ideas? Thanks Kev. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Julian date - find next highest date/number | Excel Worksheet Functions | |||
| find the last Fred and goto cell | Excel Worksheet Functions | |||
| Macro to find matching date and copy values to another sheet | Excel Discussion (Misc queries) | |||
| How to automatically goto to today's date | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
Linear Mode
