How to get Excell to jump to Date?
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
|