How to automatically use input values and copy results to a different worksheet?

Hi,

I’m quite new to creating macros, I basically only played with recorded macros.., and I’m lacking the skills to solve a problem I have. Hopefully someone can help with it.
See the attached example worksheet to support my explanation.

I have a lot of input combinations on sheet “Input values” that I need to enter in my formulas on sheet “Input & 1st results”.
On the sheet “2nd results” I do some additional processing on the results of each input combination. Afterwards I need to special copy the values of these results to the sheet “All results”. The results of every input combination should be pasted into the next empty column.

I recorded a simple macro which does this on a very basic level. I’m quite sure this can be done much more sophisticatedly by a macro using a loop, but I have no idea how to create such a macro.

It would be really great if anyone could help me out. Thank you very much in advance!!

Hi xladept,

Many thanks for your quick answer!

Your macro has the same results as mine, only your code looks a lot better!

Apparently I haven’t been clear enough about what I need exactly though, sorry about this. Let me clarify.

On the sheet “All results” I need the results of all the 50 possible input combinations, all pasted in separate columns.
Both with your as with mine macro this would mean a lot of copy/pasting and manually modifying the macro code.

So what I would like to have is a macro that uses some kind of iteration loop to detect how many input combinations there are (in this case 50). The macro should calculate the result values for all of these 50 combinations and copy these values to 50 different columns.

This is just an example sheet, in the Excel sheet I really need this for I have hundreds of possible input combinations..

It’s getting late in Europe, so I’m going to bed..
I hope I provided enough information this time and that you or someone else can help me out.
Many thanks again, much appreciated!!

The macro runs now great xladept, many thanks!!

The macro code is also simple enough to not get demotivated while figuring out how you actually do it

Thanks you very much again, you really helped me out!

Cheers