Hello All
I have a list of data in col A (labelled mileage),as per attached workbook sheet1.I am using a select case macro as shown on sheet 2,to produce the required distance value in col B,eg, If A1 = 1M ,col B1 value = 8.I keep getting a compile error message.I am a complete novice at VBA,and would be gratful if anyone could make this macro work.I would also like to add furthur data to col A in future,would it be possible to add a loop to the macro,which will run until there is nothing in col A.
Many thanks for help given.
Bookmarks