Offset Function

  • Thread starter Thread starter Kcoakley
  • Start date Start date
K

Kcoakley

I am using the offset function on many of my sheets and have made them all
identical so that this runs smoothly/dynamically update information. I would
now like to pull information using this function from another workbook. When
I try to do this I receive a "VALUE#" error. How I can I pull in this
information using either this function or one that is similar in nature?
 
You can use index instead since offset does not work if the source book is
closed

--


Regards,


Peo Sjoblom
 
Back
Top