Show us your code so far.

--
__________________________________
HTH

Bob

"RedFive" wrote in message
...
I have a spreadsheet that I am using as a template. My problem is that I
want to be able to change the source that the formulas pull the data from.
I
used the Macro recorder, but now I have to enter the source path for each
column, about 8 times. There has to be a better way, does anybody know?
I
thoght a Do Until loop might work, but not sure how to write it into the
recorded code. Thanks
--
RedFive