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, 04:31 PM

whatsup

Windows 7 64bit Reference another workbook and return values from the same cell across multiple sheets/tabs

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

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

« 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 03:28 PM.