Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet.
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...
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.