Making hyperlinks relative (vs. absolute)

[Thausta]

Hello again!
I'm creating a calendar spreadsheet that will function as follows: I click on one date, and it automatically jumps me forward 4 business days.
THAT part, I'm not having any trouble with. What I AM having a problem with is, copying and pasting the hyperlinks. I created a September calendar, and I want to cut and paste it to make October, etc. but the resultant hyperlinks in October jump me back to September!
I know that by adding $ to a cell reference, you can create absolute references. So is there a way to take these hyperlinks and make them RELATIVE references, so that when I cut and paste a new month, the links will work properly?
Hopefully this is a sufficient explanation...
Thanks.
Rob

 

[PaddyD]

"is there a way to..."

probably, but it would help to have a better understanding of your data. Post back with a specific eg of what's happening, what results you want etc, or consider posting a snapshot of your data (with the html maker add in - see the linnk below this post).

Paddy

 

[Thausta]

[No message]

 

[Thausta]

Paddy, hmmm... a bit leery of downloading anything, after a recent virus, so I'll try to explain.
As I set it up, each calendar day is a box composed of several cells: significantly, one for the numerical day of the month, one for the link, and one for notes. what I want to do is, while on the job, click on the hyperlink for todays date, which will jump me automatically four business days ahead so I can make a note that the job is due that day, and any memos I need to make about it.
So far so good... It works as long as I manually type in every single link. After completing two "week" rows, I tried to cut and paste. I can't. The links in the pasted row jump me back to the previous week.
There are no "$" markers on the link to make them absolute references, but they're funcioning like absolute references anyway. I can't type in the whole year, link by link for each and every day of the year! So is there a way to cut and paste these blasted rows without the links maintaining absolute references to the original cells designated in the row I copied from?
Ihope you "get" what I'm saying.
Thanks & have a good w/e.
rob

 

[PaddyD]

Rob,

1) Fear not with the html maker addin - no viruses there
2) Had far too good a weekend to think about this - this is mostly by way of a bump to get this back to the top...

Paddy