Hi all
What I am trying to do is that I'd like to reference a single cell in a table, from outside the table, using square-bracket sheet-formula notation. If this can be done with VBA or Macro I am fine with that. I can make it work with PC but something wrong with MAC. I think that vba will help.
This will do the job for Windows but not working for MAC. I press refresh and alll, can this be done with VBA?
=Invoice[@[PCS]:[PCS]]
SampleFile
Thank you !
What I am trying to do is that I'd like to reference a single cell in a table, from outside the table, using square-bracket sheet-formula notation. If this can be done with VBA or Macro I am fine with that. I can make it work with PC but something wrong with MAC. I think that vba will help.
This will do the job for Windows but not working for MAC. I press refresh and alll, can this be done with VBA?
=Invoice[@[PCS]:[PCS]]
SampleFile
Thank you !