Roy I can drag the contents of A1 thru a column say A1:A59 ok and the contents of all the other cells ie: A2:A59 change to the correct formula as required. Now I can repeat this for every single column up to EC59 as wanted. But it takes a lot of time what I want is some way to do this in one sweep From A1:EC59.Thanks