Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding like items from different sheets
Sorry if this has been answered, I looked at 342 different questions, did not
find one like mine. Within a workbook, I have 6 sheets. I have an inventory sheet listing all product by item number and description, ex: "80036" in a1, "36 inch box" in b1, "80046" in a2, "46 inch box" in b2, etc.. A total of 1200 lines of different items and descriptions. Then I have 4 quote sheets. Some rows for each sheet use "VLOOKUP", so if the item number from the inventory sheet is typed in appropriate col., description from inventory sheet is returned in next col.. OK, next I have a sheet that is my picking ticket. On this sheet I want a total by row of each item listed on the 4 quote sheets, so it shows how many of the same item were listed on the 4 quote sheets. So if "80036" is on quote sheet one with a value of 4, and on quote sheet two with a value of 3, my picking tix would show that item number and description with a value of 7 in the appropriate col.. Not all items will always be listed on quote sheets. How do I set up the rows on picking tix to look for an item number on the four quote sheets, if not found, go to the next item number, once an item number is found, sum the total number listed for the found item number, then on the next row, do the same thing without duplicating what has already been found, until all 1200 items have been searched for? I think I am asking too much..........TIA for any and all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Adding numbers from specific cells in a number of sheets | Excel Worksheet Functions | |||
Pareto's Law and ABCD ranking of items | Excel Discussion (Misc queries) | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions |