ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Goto or Find a Date in a Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/181614-goto-find-date-sheet.html)

Kev - Radio Man

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.

Gary''s Student

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.



All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com