![]() |
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 |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com