Urgent Help...

Alvinkiang · June 21st, 2006, 10:28 PM

Hi, i am new to Excel Coding, i was always with Vb05. anyway, i was wondering if my Problem can be solved in which way. Here it goes.
i have 2 files A ,B... A have 2 colums which one is for name the other for cost.

1st question. is it possible to PreCode File B this way E.g

COlA COlB
Andy 20
Andy 30
Fred 40

if i key in andy in excel file B it search row by row for all the andy which is located in file A and Sum up the Costs in Col B.

Do i need a Interface? or is not Neccessary?
can anyone help me with this Excel Stuff???
i appreciated if i can have a Example.. Thanks

jrogers · June 26th, 2006, 02:45 PM

use the sumif function.. ie if in worksheet B you have

COlA COlB
Andy 20
Andy 30
Fred 40

then in worksheet A cell(1,1) you enter the name of the person, in cell (1,2) enter the formula

Code:

=SUMIF('C:\temp\[Book2.xls]Sheet1'!$A$2:$A$4,A1,'C:\temp\[Book2.xls]Sheet1'!$B$2:$B$4)

you can change the file path.
first arguement is equivilent to COlA
second arguement is the location of the search name
third arguement is the range to be summed

hope this helps