Excel Cells with external sheets

Hello Experts Exchange
I have a spreadsheet that has formulas that point to different spreadsheets, for example a cell has the following formula.

='\\ntserver2\Losses\09\AC4\UKL\[UKLBlue593.xls]Lost Time'!C32

Is it possible that I have this formula built by have the file location in a cell?

So for example.
Cell A1 has this in it;
'\\ntserver2\Losses\09\AC4\UKL\[UKLBlue593.xls]Lost Time'!

Then cell A2 uses cell A1 to make it formula, so it will have;
=A1 & C32

Then it will get the information from cell c32 from the spreadsheet detailed in A1?

Regards

SQLSearcher
SQLSearcherAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Almost - you can use INDIRECT, but the C32 will need to be in quotation marks:

=INDIRECT(A1 & "C32")

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
I was also thinking INDIRECT but unfortunately INDIRECT does not work when the source file is closed.

There is an addition to INDIRECT available from a MOREFUNC add-in.

This gives INDIRECT.EXT which does work when the source file is closed.

Thanks
Rob H
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.