That helped alot but now my next problem is that I have multiple worksheets
that I have to take the values from in each file. Is there anyway for the
macro to adjust to the multiple worksheets in a file?

"Ron de Bruin" wrote:

Look on my Tips page for a few examples
http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Pitch4PD" wrote in message ...
I am working on making a summary file that takes selected values from other
files and putting them in another file for a quick comparison. Currently I
have it setup where each cell is individually linked to the file and cell
location where it will take the values from. I am trying to figure out how I
can make it do it in a batch, where I tell it what file to look at and it
will take the specified values and put it in the summary file. Instead of me
manually putting in the link each time in the summary file (120 values each
time). The values are in the same locations in each of the files I am taking
it from so it shouldnt be this time consuming.

Any suggestions appreciated,
Thank you.