View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Autofill hyperlinks

If you're going to change months, then you could use something like this--and
this relies on the row that the formula is placed. So you may have to change
that adjustment to what you want.

I put this in Row 1:
=HYPERLINK("g:\public\DP\"&TEXT(DATE(2009,12,7)+RO W()-1,"mmm d")&".pdf",
TEXT(DATE(2009,12,7)+ROW()-1,"mmm d"))

so date(2009,12,7)+row()-1 starts on the date that I want (Dec 7).

If your first formula should return Dec 7 and is entered in row 22, you could
use:

=HYPERLINK("g:\public\DP\"&TEXT(DATE(2009,12,7)+RO W()-22,"mmm d")&".pdf",
TEXT(DATE(2009,12,7)+ROW()-22,"mmm d"))





NannyKay wrote:

Can you tell me how to autofill a hyperlink formula so that both the file
path and the friendly name change incrementally? I'm using the hyperlink
function, and need to copy it down so that the file name changes (dec 8.pdf,
dec 9.pdf...) and the friendly name also changes (Dec 8, Dec 9...)

The formula I am using is: =HYPERLINK("g:\public\DP\dec 7.pdf","Dec 7")

Thank you!


--

Dave Peterson