Here is what I am trying to do, If I have a document named Test.xls on my G:\ Drive and on my masterlog, that is also on the G:\ Drive, I have the name of that document listed in A1(Test)
I would like to have a formula that would say IF(G:\folder**** = A1 then populate B2 from Test.xls in masterlog E1.
Trying something to this affect
=if(iserr(indirect("G:\HQHROPS\Workplace Relations\Labour Relations\Staff Relations Case Files\Test["&Text(A265,"yyyymmdd")&".xlsx]Data'!$D$15))),"",(""G:\HQHROPS\Workplace Relations\Labour Relations\Staff Relations Case Files\Test["&Text(A265,"yyyymmdd")&".xlsx]Data'!$D$15)
I do know the work book will have to be open for Indirect, but that would still work to save alot of copy and pasting back and forth. Once data is populated I can simply Copy and Paste Values to remove formulas.
I am not good with macros, been trying to use indirect funtion but not being succesfull.
Thank you
I would like to have a formula that would say IF(G:\folder**** = A1 then populate B2 from Test.xls in masterlog E1.
Trying something to this affect
=if(iserr(indirect("G:\HQHROPS\Workplace Relations\Labour Relations\Staff Relations Case Files\Test["&Text(A265,"yyyymmdd")&".xlsx]Data'!$D$15))),"",(""G:\HQHROPS\Workplace Relations\Labour Relations\Staff Relations Case Files\Test["&Text(A265,"yyyymmdd")&".xlsx]Data'!$D$15)
I do know the work book will have to be open for Indirect, but that would still work to save alot of copy and pasting back and forth. Once data is populated I can simply Copy and Paste Values to remove formulas.
I am not good with macros, been trying to use indirect funtion but not being succesfull.
Thank you
<!-- -->
Reply to Private Message Forward <!-- -->
