OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Hyperlink to a changing target (actual date)

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
user07
Newbie
Newbie


Joined: 25 Apr 2008
Posts: 1

PostPosted: Fri Apr 25, 2008 7:39 am    Post subject: Hyperlink to a changing target (actual date) Reply with quote

Hello Everybody

I would like to have on the 1st row a button to jump to the row with the actual date.

Details:
As kind of a menue i fix the first three rows.
On the following rows i have in colum 1 (A4:A370) the date of each day (1st jan to 31st dec).
In the colums B to F i have some informations for that day.
I now would like to jump from row 1 to that row with the actual date.

Is it possible to get a hyperlink with flexible target?
Is there someone to give me a hint?

Regardes
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Fri Apr 25, 2008 1:42 pm    Post subject: Reply with quote

The function HYPERLINK could be useful.

Try something like:
=HYPERLINK("#Sheet1!A" & TODAY()-DATE(2008;1;1);"Click here to go to today!")

You may have to adjust the positioning by adding 3 or 4 to the first argument.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group