Copying info from regularly spaced cells

[Taff]

I have info in cells a3, a19, a35, a51 etc, ie every 16th cell.

I want to copy that info into b3, b4, b5, b6 etc, therefore info running consecutively with no lines in between

Is there a quick way of doing this, eg b3=a3, b4=a3+16

there is other info in the cells/rows inbetween therefore cannot filter/delete

still a novice at this type of formula.....

Cheers

 

[Peter_SSs]

If it is text values in those cells then try this in B3, copied down

=INDEX(A$3:A$1000,ROWS(B$3:B3)*16-15)&""

If it is numerical values to be extracted & they need to remain numerical then either we need some way to determine where the last value is or how many values to be extracted.

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[mohadin]

Hi
as I understand
Try

Sub test()
    Dim i
    For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row Step 16
        Cells(i, 2).Resize(16) = Cells(i, 1)
    Next
End Sub

 

[cooper645]

Another method: (This assumes all 15 cells between are blank)

Copy column A to B,
Select entire B column,
Press F5,
Select "Special',
Select 'Blanks',
Press 'Ctrl' + '-'
Select 'Shift cells up'
select 'ok'

 

[Peter_SSs]

(This assumes all 15 cells between are blank)

I think you may have missed the following.

there is other info in the cells/rows inbetween therefore cannot filter/delete

 

[cooper645]

I think you may have missed the following.

Thanks for pointing that out. I missed it completely ?

never know, it may help someone else who stumbles by this post in the future.