Any Excel Experts here?

Grim/Don

Grim/Don

Joined
Feb 1, 2003
Messages
1,221
I've got a spreadsheet for work that's a large scheduling calendar for the whole year. In cell A1, I've got a hyperlink called "today" and that makes the curser jump to the cell that has today's date in it. Only thing is, I have to update the pointer everyday to the current date...:grumpy:

I'm trying to set up a dynamic hyperlink that compares tha cells in column A to today's date and updates itself...

This is what I have so far, but it's erroring out on me:

=HYPERLINK("[Midwest CY07.xls]'Install Master' ADDRESS((MATCH(TODAY(),A1:A33,1))","today")

[Midwest CY07 is the File name, Install Master is the sheet name]

Any ideas?
 
heh

Nevermind, I actually got it figured out myself! :thumbup: It's something I'd been looking at for over a year now and just got back into.

In case anyone's curious, here's how I worked it out:

Set up most of the Hyperlink in cell b1

="[Midwest CY07.xls]'Install Master'!" &"a"& VALUE(MATCH(TODAY(),A1:A5000,1))

Then in the actual cell (a1) that shows the hyperlink I reference that cell:

=HYPERLINK(B1,"today")

That way, b1 does all the actual calculation and a1 just references it.

::don goes to do the happy dance now:: :D
 
Cool. I have a very difficult time with Excel. Luckily there's a young blond a few cubes down from me who is an Excel Goddess. She can make anything work. Most of my more complex spreadsheets were written by her. Well, she was an accountant before coming here.

They never offered, (or perhaps I never looked for) Excel classes in college. Maybe I should have looked harder.

Daniel
 
You're from KC too? I work over by the Flying J by 435. Next time I have an Excel question, I'll come knock on your door! :D

You don't need any classes for Excel. The best way to learn it it to get in and use it. The classes will only bore you and expose you stuff you'll never use. Self taught is the way to go with Excel/Word.
 
I agree with Grim/Don; Use and experiment. I am self-taught and am pretty good with excel.
 
You must log in or register to reply here.
Back
Top