(Solved) – multiplying multiple rows by single column in vba [closed]

(solved)-–-multiplying-multiple-rows-by-single-column-in-vba-[closed]

I have a workbook – let’s call this workbook A.
Workbook A is structured as follows:

enter image description here

Each column is age (40 to 100).
Each row is a specific simulation of certain rates for each age. There are a 1000 simulations.

I have another workbook – let’s call this workbook B.
In workbook B I have an array of data structured as a column.

I need to transpose the data in workbook A to have this structure – where now each column refers to a specific simulation.

enter image description here

Then I need to multiply each column in workbook A by the column in workbook B and output the results in another workbook C.

Any suggestions on how I can do this? (I am beginner level VBA)

Leave a Reply

Your email address will not be published. Required fields are marked *