Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Reference another workbook and return values from the same cell across multiple sheets/tabs Reference another workbook and return values from the same cell across multiple sheets/tabs
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-07-2014, 03:05 PM
lwls lwls is offline Reference another workbook and return values from the same cell across multiple sheets/tabs Windows 8 Reference another workbook and return values from the same cell across multiple sheets/tabs Office 2013
Novice
Reference another workbook and return values from the same cell across multiple sheets/tabs 		 
Join Date: Oct 2014
Posts: 4
lwls is on a distinguished road
Default Reference another workbook and return values from the same cell across multiple sheets/tabs
Hi Everyone

I'm trying to summerise daily sales figures in a new wkb(destination wkb), by referencing another wkb(source wkb) which contains sheets/tabs named in date order(such as 01.04.14, 02.04.14 etc). On each of the source sheets/tabs, the total daily figure is in cell F6. On the destination sheet, I've labelled the columns 1 , 2, 3.....to represent each day and the months on the rows. I intend not to open the source wkb when using the destination wkb.




I've tried referencing the source wkb ,however, it couldn't copy across the sheets/tabs. Any ideas as how I could fix this?
Attached Files
File Type: xlsx Destination WKB.xlsx (9.6 KB, 10 views)
File Type: xlsx Source WKB.xlsx (11.4 KB, 9 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference another workbook and return values from the same cell across multiple sheets/tabs 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
Reference another workbook and return values from the same cell across multiple sheets/tabs Reporting Values Between Sheets/Tabs jjbNana Excel 3 10-06-2011 10:28 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs 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 09:19 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft