A
Armatidge
Is there any way i can make the function
=VLOOKUP(O9,'C:\Documents and Settings\robic9\My Documents\Gregory -
DRE24\Work Packs\[Gregory DRE24 Service Order
Summary.xls]Sheet1'!$A$8:$E$182,4)
look like this
=VLOOKUP(O9,'\Work Packs\[Service Order Summary.xls]Sheet1'!$A$8:$E$182,4)
and still work. I want to have the one summarry sheet in the root of one
directory and all spreadsheets with the lookup function to keep the lookup to
the root kind of like a web page where you have the root and you never have
to input the whole directory structure
=VLOOKUP(O9,'C:\Documents and Settings\robic9\My Documents\Gregory -
DRE24\Work Packs\[Gregory DRE24 Service Order
Summary.xls]Sheet1'!$A$8:$E$182,4)
look like this
=VLOOKUP(O9,'\Work Packs\[Service Order Summary.xls]Sheet1'!$A$8:$E$182,4)
and still work. I want to have the one summarry sheet in the root of one
directory and all spreadsheets with the lookup function to keep the lookup to
the root kind of like a web page where you have the root and you never have
to input the whole directory structure