Thread: [Solved] Reference another workbook and return values from the same cell across multiple sheets/tabs
View Single Post
 
Old 11-07-2014, 04:31 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
Hi

without opening the source-wkb, you only can do it using formulas the like you use already in B2. The formula has to contain the exact and complete path, sheet and celladdress, you can't even use the function INDIRECT().
That's the only way if the source has to remain close.

Cheers
Reply With Quote