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
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