[SOLVED]Retrieve data from one excel file to another.

[JonasH73]

Hi!

I'm pretty green on formulas in Excel.

Uses Office 365.

I have an Excel file with a customer list, currently about 3300 lines.

I would need to be able to retrieve the contents of a cell in a specific row.

Let's say that the "B" column contains what I want and want to transfer to my other Excel file which is a Work Order.

If I put the Work Order in a sheet in the Customer List, I get everything to work exactly as I want with the formula.

=INDIRECT ("'" & W4 & "'!" & "B" & T7)

// W4 is the cell where the name of the sheet is written

// In T7 I write which line I want to pick from.

What I do is that I write in a Cell which line I want to get Tex "Name" from, say line "2376" and then I get "Peter".

But I can not get the connection together if I have "Work Order" in a separate file!

// Jonas

[#2 · Accepted solution]

@JonasH73 

You can do that but only if the other workbook is open in Excel too, otherwise INDIRECT will return #REF!

So you might as well keep the sheet in the same workbook.

But if you want it:

=INDIRECT ("'["  & W5 & "]" & W4 & "'!" & "B" & T7)

where cell W5 contains the filename of the other workbook.

[#3]

THANKS!
//Jonas