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!!!

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

Hi kamila7
This code in in the attached...see if it does as you require

Please Login or Register  to view this content.

Hi kamila7
I think this is doable

I was hoping it would go down through the values of the listbox without me having to tap each value in the listbox.

Let me play with it a bit.

Hi kamila7
Replace the previous code with this and see if it does as you require

Please Login or Register  to view this content.

Hi kamila7
You're welcome...glad I could be of help. If that satisfies your need, I'd appreciate it if you'll please mark your thread as "Solved".

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solved
- Click Save