Ok davesexcel, I have attached a very simple sample of what needs to happen. I thought it was simple enough not to have to attach.

In this instance, column E will have my raw data. I need to put each number into the input cell (B2) , highlighted in yellow. I then need to copy the answer this gives from the output cell (C12) into column F alongside the original input value. Obviously i have just made up some small function in this instance for illustration purposes but the real thing is much more detailed and no I cannot use functions in my macro to do it. I just need the macro to go through my raw data one at a time and copy and paste the values and then move down to the next row. I have done the first few as an example.

In my real spreadsheet I will have a list anywhere from 200 odd points to possibly thousands and thus I also need the macro to determine when the raw data finishes and not continue on. Hope this makes sense. I have got as far as recording the cut and paste parts for my macro but I dont know how to make this work in a loop like I have explained.

VBA_ListCalculatorFunction.xlsx

Any help is appreciated!

Cheers,

Spicey