![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: May 2002
Posts: 8
|
Hi everyone
I would like a series to continue which refers to cells but goes up by 12 cells each time(by a year). I am referencing these cells B2, B14 in a column and would like just to put the value in every 12 cells in a row and drag this formula to get 50 years worth. If anyone knows why excel want let the pattern continue by referring to cells going up by 12 could you let me know Thanks Jeff |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Sunny, spring-like Hull
Posts: 3,339
|
The following might work OK for you, if your first cell is in row 1 of your sheet use the following formula and drag down to autofill: -
=INDIRECT("B" & 2+(ROW()-1)*12) Adjust the amount subtracted above to reflect the starting row of where you enter your formula (ie if you start in row 15, use a -15 rather than -1 in the above formula). |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|