Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook that has about 30 sheets. Each line has a date in it (in
Column B). The same date never (at least shouldn't) repeat itself. I am interested in 2 different things (and that an additional add-on): #1: When Excel opens, to get it to automatically, jump to Todays Date. #2: To enable some kind of Search, that I can enter a date and it will give me the corresponding line. #3: It would be nice if I can make a Front Page, that is shown when the Excel file opens. Ideally, I would like it to fill in the information from Today's Date, and then below it, to allow me to have the option to search out a date (and then maybe also to search based on other (text-based information -that would also not repeate itself) information in the Workbook. I'm not a total n00b, but I would like some direction. Also, is there anyway to create this, and then distribute it, that people will not have to deal with Security pop-up issues? Thanks for any help, Yoni |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto date in excell 2010 | Excel Discussion (Misc queries) | |||
how do I automatically jump to the present date in a roster? | Excel Worksheet Functions | |||
Macro to jump to today's date | Excel Discussion (Misc queries) | |||
How to jump date? | Excel Discussion (Misc queries) | |||
Excell macro Date help | Excel Programming |