Thread: [Solved] Reference another workbook and return values from the same cell across multiple sheets/tabs
View Single Post
 
Old 11-07-2014, 03:05 PM
lwls lwls is offline Windows 8 Office 2013
Novice
  
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