Copying data with skipping rows

[Guerrilla]

I have a list of part numbers I need to copy. In Sheet B I have Values from B3-B1027. I am trying to create a form to ensure each part has gone through a Safety checklist. To do this I am Copying B3-B1027 to Sheet A. But when I am copying to Sheet A I need to skip 55 lines.

Ex. A1='SheetB'!B3, A56='SheetB'!B4, and so on.

Any help would be greatly appreciated.

 

[oldbrewer]

let us say you have only 7 numbers in B3 to B9

temp=2
for j=1 to 331 step 55
temp=temp+1
cells(j,1)=sheetb!cells(temp,1)
next j
end sub

 

[oldbrewer]

should be (temp,2)

 

[Guerrilla]

Thank you very much. This was very helpful

 

[oldbrewer]

glad to expand your armoury..........