I m facing a problem and I am bounded to work in excel: Hope u all will help me after reading the following situation.

Let me discuss it in detail:

I have two files: first one is in dbf form including three fields naming DDOCOD, ACCTT and AMOUNT. Following is the example of DBF File:

DDOCOD ACCTT AMOUNT
28100 51111 2500000
28100 51111 60000
28100 51211 25632
28111 56321 4552

Keep it in mind that the column of DDOCOD contains details about 27 DDOs starting from 28100 to 28126.

Second one is an excel file with 27 worksheets, each contain two columns with the name ACCOUNT and AMOUNT. Each sheet contain information about any one particular DDO. Now I want that I place formula in all sheets that they automatically pick the sum of amount of any particular ACCTT of any particular ddo and place it in its place.
Let in excel file there is first sheet with the name (mentioned in tag) 28100. with the first row having account 25111, second row 25112 and third row 25113. Accounts are constant in each sheet. I need that in sheet 28100, I place a formula in amount column in a way that it automatically calculate the Sum Amount of the particular account (i.e. 25111, 25112, 25113::..) from the dbf file having DDOCOD 28100. If the dbf contain that Account, then sum and place it infornt of the Account column and if not, then place zero in the cell.

Hope u people better understand it now.. and help me quickly:

If u still don't understand, then give me your mailing address and I will mail a sample to u of both files.

Hi,
4 wot i can understand : u want some part of ur dbf file (a sum of articles i mean)to go to ur excel sheet.
Import ur dbf in excel. Next have a pivot table with it. Name it. In each sheet have a vlookup to get ur sum accordin to ur reference . If i'm not on the way, send me a sample...!