I'm hoping this is possible (if it is, not sure how easy it is!), and
I'm really hoping that someone can help!

I have some workbooks that contain information regarding clients
details, status, yearly spend, etc - general information. Each workbook
is saved as the particular client's customer code/number - eg. ABC
Company Pty will be ABC.xls, whereas XYZ Corporation would be XYZ.xls

What I want to do is this - have a separate "summary" workbook that
summarises different bits of information in each of the client
workbooks. For example, lists the client's current spend level.

I know I can put in a formula in the workbook referring to
"=[ABC.xls]Sheet1!$B$1" to return the value in B1 on ABC.xls.

What I need is for the system to read the client code on the summary
workbook and return the value on the workbook that refers to that
client code.

That is, if I enter "ABC" into Cell A2 of the summary workbook, have
the system return the value from "[????.xls]Sheet1!$B$1" where "????"
is the value in Cell A2... does this make sense to anyone but me?

Hopefully so - if I've confused the issue let me know and I'll try to
explain again... otherwise, can anyone help? :)

Cheers,

Rob.
(aka "Tired and Frustrated")


--
Rob Moyle
------------------------------------------------------------------------
Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432
View this thread: http://www.excelforum.com/showthread...hreadid=521670