Harlan's FTP has "Some Assembly required"


You might use Ron's Code to pull data from diferent files onto a master
sheet in your book then Vlookup to select the right data from the Master sheet

http://www.rondebruin.nl/summary.htm

"Dave Peterson" wrote:

The function you want to use is =indirect().

The bad news is that =indirect() will return an error if that other workbook
isn't open.

Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip

SandyUK wrote:

Thanks for the reply

I have tried this approach and checked the syntax etc and no joy. Its
been a long term problem which i can't seem to find a solution for.

Regards

Adrian

--
SandyUK
------------------------------------------------------------------------
SandyUK's Profile: http://www.excelforum.com/member.php...o&userid=17487
View this thread: http://www.excelforum.com/showthread...hreadid=477505

--

Dave Peterson