Thanks Paul- the macro you wrote worked a dream....I must say the code was more complicated than envisaged, especially for a macro novice like me.

I am now looking for a macro to calculate the median of each column, then subtract the median from each data point within the column and present the new data points in a third spreadsheet....can you give me any pointers?

Again - your assistance is much appreciated