Simple formula question
 

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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63550

Simple formula question
 

every 13th cell to
equal every 1 cell of

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

"Cook" wrote:


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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63550

Simple formula question
 

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.


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63550

Simple formula question
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cook" wrote in message
...

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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63550