Hello There, I am using excel 2000 to import some data from dbase. The data has two fields: 1. Item Description and 2. Quantity ordered on that particular day. I want to add all the items added for the whole week The list of items ordered varies everyday but most of them are same, now I want to know if there is a way in excel to arrange items with the same description on one same row, so that I can add them to show the total for week. Example: Worksheet1 Item Desc.-Qty Ordered ItemA------------2 ItemB------------3 ItemC------------5 Worksheet2 Item Desc.-Qty Ordered ItemA------------4 ItemB------------3 ItemF------------4 When I merge (or move/ copy which ever is possible) these two sheets I want the following result on one sheet: Item .Qt Day1---Qt Day2 ItemA---2--------4 ItemB---3--------3 ItemC---5-------- ItemF-- ----------4 Then I can add each row to give me the final total. Thank You Desi

Just type in seperate fields the values you want is the answer to the last part of your question but as far as the second part goes I think it's pretty involved. Luckily you don't require that much data to be retrieved. In Excel - Data > Get External Data > New Database Query, when I reached this point I was asked for MS Office 2000 disk 1 for this fuction to be installed(did not require re-boot). You are then given options as to what type of database to connect to or create your own query. I did not venture any further than this without creating a DB and SS to work on. I found help at Excel help typing excel and database. M

a pivot table, based on several sheets will do the job.