How far do you want to go?

This construct will take you from Dec 7 to Dec 31 when entered in A1 and
dragged down to A25

=HYPERLINK("g:\public\DP\dec "&ROW(7:7)&".pdf","Dec "&ROW(7:7)&"")

Would you have more that fall into the next month or months?


Gord Dibben MS Excel MVP

On Fri, 4 Dec 2009 08:25:01 -0800, 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!