Thankyou Thankyou
Well done Phil
Len

Hi Phil here is what I am doing to do as I have to do it a lot, the ones you can see are every 3 rows but I imagine its the same if I wanted to do every 2 rows.
209917 ...

Hi Phil ,,,,its stil not working. this is what I get ,,,I have =a22 which is fred bloggs,,,,=a24 which is joe bloggs, so I select them and drag down like you say but I get a column like this,,
Fred...

Very very sorry Phil,,,,,, what I have is a number of cells in a column that in each of them it says =e24, = e26, e28, and so on, what I am trying to do is select the cells and using ctrl shift...

Very sorry but I don't know what you mean.
Len

Hi ,,I want to copy =e7,=e9,=e11,, you know what I mean, select a cell, press Ctrl and select down a part of a column, but each cell says =e7,=e8,=e9,=e10,,,what I want is =e7,=e9,=e11,=e13,,can...