Reference another workbook and return values from the same cell across multiple sheets/tabs

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Reference another workbook and return values from the same cell across multiple sheets/tabs

FAQ

Thread Tools

Display Modes

11-07-2014, 06:58 PM

lwls

Reference another workbook and return values from the same cell across multiple sheets/tabs

Windows 8

Office 2013

Novice

Join Date: Oct 2014

Posts: 4

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Reporting Values Between Sheets/Tabs	jjbNana	Excel	3	10-06-2011 10:28 PM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 PM.