| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple formula question | Excel Discussion (Misc queries) | |||
| Simple formula question | Excel Discussion (Misc queries) | |||
| Formula question -simple for those who know | New Users to Excel | |||
| Simple Formula Question | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
![Cook[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
