Get Data from other speardsheet

[antis]

Hi guys,

How do you get data from other spread sheet?
What is the function?

For example,
on my 1st Spreadsheet (call it A.xls)
I have value in say column A will have code number and the second row will have some number. I will looks like this:

Code
1111 1112
Qty Qty
1.1 (Formula) (Formula)
1.2

Then in ther spreadsheet (B.xls) will have qty in column A, code in column B and Number in column C. It looks like:

Qty Code Number
1 1.1 1111
1 1.1 1111
1 1.2 1111
2 1.2 1112
1 1.2 1112

Then I want to get the formula in A.xls to fill the cell so that

1.1 & 1111 will have Qty of 2,
1.1 & 1112 will gave Qty of 1 and so on.

Can anyone help me pls. What should I do?

Thank you so much for any help.

 

[antis]

does anyone can help me please?
how to lookup data from other excel spreadsheet?

 

[MDuff]

Well you can use a normal formula and use the other workbook as a refercnce or just = and the other sheet referance

Hope this helps

 

[PegasusJF]

Are you talking workbooks or worksheets?

The latter is Sheets("SheetName").Property

You set a range to that Sheets Data.

So that would be

Set anotherSheet = Sheets("SheetName).Range.("wherever) or ~~~.Range.("wherever").Currentregion

The former....

Well, I'd have to look that up.

 

[antis]

I am talking about the different worksheet. NOT workbook.
As my example before. file A.xls will look data from file b.xls
The location of those 2 files will be the same.

So Pegasus, should I use your formula?

 

[antis]

Doest work. I dont understand what r u talking about.
Sorry.
Can u give me some example formula using my example above please.

Thank you

 

[PegasusJF]

Working from different files, well, that sounds like different workbooks to me.

But regardless, it's beyond my experience.

I'm sorry, I can't help.

 

[antis]

Yes different files but still excel file.

Anyway thanks for your help.
Hopefully there is someone in this forum can help me.

cheers.