Thread: [Solved] Reference another workbook and return values from the same cell across multiple sheets/tabs
View Single Post
 
Old 11-07-2014, 06:58 PM
lwls lwls is offline Windows 8 Office 2013
Novice
  
Join Date: Oct 2014
Posts: 4
lwls is on a distinguished road
Default
Hi Whatsup

Thanks for the reply. If I keep the source book open, how do I make the formula in B2 lookup all the sheet/tabs in the source wkb and return the values to the destination wkb as described above.
Reply With Quote