Excel Macro help to copy/paste results using input values from a list box

Hi,

I have never done any macros but need to create one now, I was wondering if anyone could help. I tried "recording Macro" but it did not give me the result I wanted. What I am trying to do is perform a macro that takes a value from a list, inputs it into my data/assumptions and then copy and pastes teh final values on the sheet, or another sheet, whichever is easier.

I have included an attachment of my spreadsheet to help explain.

So I want to pick a value from my list A, B, C...., then the examples goes through calculations and I would like to take the bottom two rows (row 17, 18) and paste the values in AA4-AK4. Then go to the next value in my list and past again under the previous values, in AA5-AK5.

Is this something a Macro can do? If so could anyone please help me? I am completely lost

Thank you so much in advance!!!