Call an excel document to another sheet [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet.
For Example
Book 1 got headings of the work nature with code in a separate cell.
Book 2 got a individual sheet containing all the details of that work.If i click a cell cellwith the code in book 1 i need to get the sheet from the book 2.
Is it possible.If so please explain...

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
have you tried MOREFUNC add on. You can download that one. Not too sure what you seek. Is two different sheet in same book or two different sheet in same book. If different book, are both book open at same time.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!