Thread: Data connection range

Hi, I was wondering whether it's possible to connect one file to just a range of cells in another.

Essentially I have 2 files: A.xlsx and file B.xlsx.

A.xslx contains 1 sheet with some calculations and 3 tables. One of the three tables is a costs table that I need to put into B.xlsx, so that B.xlsx will update if I change or add additional data to my costs table in A.xlsx.

However, in B.xlsx, I would like to have the costs data from A.xlsx as part of another table like so: (I have ensured the column number and headers match)

---------------------
Table headers
---------------------
B.xlsx data
...
...
A.xlsx costs table
...
...
B.xlsx data
...
...
---------------------
Totals row
---------------------

(Because these data are part of a report, I must present them in one big table.)

My problem is that when I import the data from A.xlsx, I only have the option to import the whole file when I only need my costs table. Every time I delete the extra imported data it comes back again when I refresh the remaining data, since the connection in B.xslx is with the whole of A.xlsx.

Can I just connect a range of A.xlsx with B.xlsx? Or even better just a particular table in A.xlsx?

Thanks very much

Hi

It is possible to use a macro to insert appropriate lines / or shift cells down as appropriate and then insert the necessary link. Will the data be matching in both sheets, i.e. will both tables be identical ?

If you have an example sheet from each workbook, without data, it would be easier to prepare something for you.

Regards

Jeff