Jan 27 2022 04:50 AM
In cell K10 I have a drop list with files name (source is column C) is it possible to get the data from the selected file in the drop list? The target cell is always for example L10. So if I pick a different file name from the drop list I get the value of c ell L10 of the new selected file? if it is possible with a formula because i just start learning VBA and i believe it might be a bit too complex at this stage to use VBA for me
thank you for your time
Jan 27 2022 09:17 AM
Instead of
='[filename]sheetname'!$L$10
you may use
=INDIRECT( "'[" & K10 & "]sheetname'!$L$10
Jan 31 2022 05:20 AM
thank you for your reply,
I used the indirect formula in the column TARGET (G5) to have a full path with file name, file extension, work sheet and specific cell i need the value from, but it doesn't give me any result.
it works in the cell G16 where i have the same formula you can see in F16 which i typed manually.
any idea why is not working ? and how to fix it?
the idea is to have later on the column A as a drop list and use it to index and match with column g so i can have the value in G16 to change accordingly. thank you for your time
Jan 31 2022 05:27 AM
SolutionJan 31 2022 05:27 AM
SolutionI guess here
it shall be ... &"recepe card'!L10" , not .. &"recepe card'!&(L10)