Making hyperlinks relative (vs. absolute)

Thausta

New Member
Joined
Sep 7, 2002
Messages
21
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"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

New Member
Joined
Sep 7, 2002
Messages
21
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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
 

Forum statistics

Threads
1,144,431
Messages
5,724,303
Members
422,543
Latest member
TimB_13

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top