I am trying to work out a macro that will do the following
Column A will be pasted into Cell $F$2, one value at a time.
Column B will be pasted into Cell $F$3, one value at a time.
Cells F2 and F3 are then input into some formulas to create a value in $R$4. This part is done with formulas not part of the macro.
Then this value $r$4 needs to be pasted into Column C. I hope I have explained this well enough for you to understand. So I think I need Loops within loops so it will take one calculation at a time and place into column C before it goes to the next set of numbers in Column A and B.
Do you have a ny suggestions?
All the data is on one work sheet.