Reference a workbook with only a partial name
Hi all, just a quick question,
I have multiple workbooks each labelled using the format:
€śInvoice number €“ clients name€ť
Is it possible from a master workbook to refer to a work book if I only know
the invoice number?
So if I enter invoice number 9484 into the master workbook it will look up a
cell reference from workbook €ś9484 €“ Company Name€ť ?
Please help!! Chris
|