i am attacking an excel sheet and i am looking for a vba solution.
On database sheet i have products and in each product different items are used.
On orders sheet i have the product name and quantity in column A and B respectively.
i am looking for a vba solution that can give me an output like shown in column J to S.
Column L has the total quantity which multiply the oder quanity with the quantity shown in database