ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   link to workbook by cell refrence (https://www.excelbanter.com/excel-discussion-misc-queries/187516-link-workbook-cell-refrence.html)

Rich[_2_]

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

David Biddulph[_2_]

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