# Copying info from regularly spaced cells

#### Taff

##### Board Regular
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

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Peter_SSs

##### MrExcel MVP, Moderator
If it is text values in those cells then try this in B3, copied down

Excel Formula:
``=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’)

##### Well-known Member
Hi
as I understand
Try
VBA Code:
``````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

##### Well-known Member
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

##### MrExcel MVP, Moderator
(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

##### Well-known Member
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.

Replies
1
Views
48
Replies
66
Views
2K
Replies
3
Views
81
Replies
9
Views
119
Replies
0
Views
64

1,130,125
Messages
5,640,268
Members
417,132
Latest member
Srw123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back