link to workbook by cell refrence
 

hiyais their a way to create a formula theat will look at a cell in another
workbook where the file the form is stored in may alter

what want to do is have a cell with a value in , and the formula then link
to a sheet thats stored in said folder

I.e =c:\call b4\workbookname\page\cell

then file names within each folder are consistant its jut the FOLDER name
link am looking to locate via cell lookup

thanks

link to workbook by cell refrence
 

The function you need is INDIRECT.
--
David Biddulph

"Rich" (no spam) wrote in message
...
hiyais their a way to create a formula theat will look at a cell in
another
workbook where the file the form is stored in may alter

what want to do is have a cell with a value in , and the formula then link
to a sheet thats stored in said folder

I.e =c:\call b4\workbookname\page\cell

then file names within each folder are consistant its jut the FOLDER name
link am looking to locate via cell lookup

thanks