I maintain an Excel database (the Excel version included in the Office 2000 suite) which includes a column of weights (Imperial, ie stones and pounds). The range of weights is from 7st 7lb to 12st.
9st 12lb is entered in a single cell as 9.12, 7st 9lb as 7.09, etc.
I would like the macro to be able to convert a run of up to 36 cells in a column from the data as entered to the values representing the difference between the values and that of the value in the top cell of the run. Thus if the values of six cells in a column were:
I would like to be able to select the cells and apply the macro to produce the following values: