Simple formula question

[Cook]

Starting at B2 of the "job log in" tab I would like every 13th cell to
equal every 1 cell of the B column of the "PM" tab.

So...

Job log in B2 = PM B2
Job log in B15 = PM B3
Job loh in B18 = PM B4 and so on.

Is there a formula I can put in PM B2 that I can drag down to say row
2500?

 

[dlotz]

every 13th cell to

equal every 1 cell of

I dont understand what are wating please repharse this part of your quesiton

 

[Cook]

Job log in B2 = PM B2
Job log in B15 = PM B3
Job log in B18 = PM B4 and so on.

I'm not real sure how else to explain it... sorry

 

[Don Guillett]

This macro should do it

Sub foreachstep13()
j = 2
For i = 2 To 2500 Step 13
Cells(i, "b") = Sheets("sheet10").Cells(j, "b")
j = j + 1
Next i
End Sub