One mo

=hyperlink("File:////" & $b$1 & "\" & a2)

(spaces added just to make it easier to read.)

Gina_Marano wrote:

Hey Guys.

I want to paste a formula but I only want one of the cells to be
dynamic.

example (I am building a list of URLS)

A B
1 RootDir c:
2 file1.txt =HYPERLINK(CONCATENATE(B1,"\",A2))
3 file2.txt =HYPERLINK(CONCATENATE(B1,"\",A3))
4 file3.txt

I want the formual to alway refer to B1 and I want to iterate
A2...A(N). I am trying to cheat here because I have a lot of these to
do and don't want to keep having to edit the formula.

Any thoughts?

Gina_M

--

Dave Peterson