Oh... wait - I've got it now fab - works a treat - God knows how!
You are a Genius

"Mike H" wrote:

Hi,

Put the formula anywhere except column X of sheet 2 and it will return the
contents of Sheet 2 - X5.

Drag down for Sheet 2 - X11 etc.

Mike

"Rogerxwilliams" wrote:

not understanding this and cant get it to work

"Mike H" wrote:

Hi,

Try this

=INDEX(Sheet2!X:X,(ROW(A1)-1)*6+5)

drag down as required

"Rogerxwilliams" wrote:

I am copying data from one Excel sheet to another. In the source sheet the
data I want to copy does not reside in sequential lines. Instead it occurs on
every 6th line i.e. X5, X11, X17 etc... I want to populate a column in the
destination sheet solely with data from every 6th line - so I have used "="
and then clicked the source cell on the other sheet three times to get a
"sequence" started. I then select all three cells on the destination sheet
and drag this down to try to create a full column following the same
sequence... this is where something strange happens... the source cell
numbers "reset" depending on the address of the starting cell - I am faced
with a hugely laborious task copying over hundreds of numbers - any ideas???