Hi

You're very welcome.
Thanks for the feedback letting us know it worked.

--
Regards

Roger Govier


"sako 338" wrote in message
...


"Roger Govier" wrote:

Hi

Well lets try a different approach without IF or Choose.
Using any set of available empty cells - I used M1 to M5
In M1 enter "c:\K9 Stats\Cowie Stats\2007\
in M2 enter =TEXT(DATE(7,L4,1),"mmmm")
In M3 enter \Running Tally
in M4 enter =LEFT(M2,3)
in M5 enter 07.xls" That's a space before the 07.xls in the
cell)

Your resulting hyperlink formula would then be
=HYPERLINK(M1&M2&M3&M4&M5)

and with a 1 in cell L4 would give the following hyperlink
c:\K9 Stats\Cowie Stats\2007\January\Running Tally Jan 07.xls

and with a 12 in L4 the hyperlink would change to
c:\K9 Stats\Cowie Stats\2007\December\Running Tally Dec 07.xls

You could adapt the method further and have the Year 2007 and O7.xls
part of the file name altered automatically if required.

--
Regards

Roger Govier


Thanks a bunch

Thats was awesome,works a treat.

Thanks

sako 338