We need to manipulate a column of numbers
In Sheet 1
Column A - mark (can have any number of entries. Entries have a value from 0
to 100)
25 36 49 20 18 etc
Column B - old (2-5 entries)
0 45 60 90
Column C - new (2-5 entries)
0 45 55 85

The macro that I need to implement is:
IF (mark old[i-1]) and (mark <= old[i]) THEN
mark := (mark-old[i-1])*(new[i]-new[i-1])
/(old[i]-old[i-1]) + new[i-1]

for i in the range 2 to number of breakpoints. Thus old[i] is scaled to
new[i] for each i, with linear interpolation for in between marks.

I can do this in C++ or C#, but have no idea of VBA.

I would appreciate some help.

thank you

Mark