Copy & paste input data to sheet, copy result back out

Hello,

I am making a simulation which has an input single value and an output set of 3 results.

This single input value (cell C4) affects various cells & calcs in a large table. The output sums and totals of this table are within cells K3, L3, M3.

This table is working fine - i have no problems with it. I have logged data in another sheet which in one log consists of around 44,000 lines of data. One column (H) contains figures which i would like to one-by-one enter into C4 on my table tab, and then copy/paste as values out the 3 results back against the data log.

Ive recorded a macro of me doing this 3 times:

Please Login or Register  to view this content.

I suppose i need to work out how to increment the cell references on the data log tab.

I've only made one Macro before and this forum provided invaluable help! Im hoping once again it can help me as i dont know really where to start. Looking around online, there are methods which appear to do such a thing a different way but they all confuse me.

OK - some Macro Magic there! Im not quite seeing how it works; but it does!

I pasted it in to a new macro on its own and to my amazement it started doing just the thing it should.

Going to try and research the terms used and reverse engineer it. For now, many thanks for your assistance.

Hello, this can do the job

Please Login or Register  to view this content.

Kind regards
Leo