Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking a table in Excel 2013 to data from another spreadsheet
I am trying to redesign some reports along the lines as to what I had at a previous workplace. Can anyone help me work out how it was done.
The reports spreadsheet has a sheet called 'Outstanding Call Details' this contains a table. Each cell in that table has a reference in it that relates to another spreadsheet as follows ='S:\Folder level 1\Folder Level 2\Folder Level 3\[worksheet name.xlsx]Page 1'!E6 Some of the final rows in the table do show a series of 0's I have been looking at external links and importing data but cannot see how this has been done or if there is a better way to do it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2013 Merge Data | Excel Programming | |||
Linking Excel data to Word table | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from the last row of spreadsheet | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
linking data from sharepoint to excel spreadsheet? | Excel Worksheet Functions |