I just posted to formuals side but I think it might be solved with VB
so I am going to post here also. I apologize for double posting bu
this is a critical issue at the moment.



Hi, I have two tables I am trying to get to multiply against eac
other.

The first has components on one axis and finished product across th
top. The body of the table is the # of components in each finishe
part.

The second has the same list of finished parts down the side and month
across the top. The body is the demand for each part, for each month.

What I need is a table with component and month as axis with the bod
to be finished part demand X component qty for that finished part.

I have attached simplified version showing two tables, and the expecte
answer.

I need some ideas on how to get the table to calculate the answer. (th
actual table is going to be 900rowsX180cols)

Note: I am comfortable with complex formulas and can also write VBA i
you can point me in the right direction

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64188
--
Message posted from http://www.ExcelForum.com