Call an excel document to another sheet

Closed
TKM - Dec 24, 2011 at 06:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2011 at 02:40 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 27, 2011 at 02:40 PM
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.
0