Trying to fill a column with formulas while incrementing cell references

[manumuskin]

Greetings good people, my first post. I am trying to increment the cell references used in the simplest of formulae (i.e. "=B1"). My goal is to pick every 12th row in a column for transfer to another Sheet. I wish to paste info into sheet 1 and select portions of it to sheet 2. the info is 2 columns and 12 rows in extent. see example ... I want to pull out (e.g.) the account #'s from a set of copy and pastes as shown here. I will paste this array of data in the A & B columns so that I need to select cells B1, B13, B25, B47, ... . Doing a pull down fill does not work nor do the fill options so far. How do I get these cell references to fill while incrementing by 12? I have tried to fill columns with "=", "B", & "1", "13", "25",... filling the columns and performing a Concatenate to assemble them in another column but I wind up with text not formulas. Can I convert text to a formula? Since I will do this with several of the data items it would would reduce my cut and paste effort by 80% as opposed to copying each data item individually from the source. Any help would be greatly appreciated.

Account 336-4271-0-0000
Address 641 N MARSHALL ST
Municipality CITY OF LANCASTER
Deed Area 0.06
Total Assessment $67,400
Sale Price $103,000
Sale Date 20070131
Deed Reference 5592275
SUBPLAN
Preserved Farm
Tax Exempt 3

[daffodil11]

Way to represent Lancaster!

You'll want to use the INDIRECT() function to write an algebraic statement that increments by 12.

INDIRECT works by changing the value within its parens to a reference. So =INDIRECT("A" & 100 - 99) is the same as =A1. Then you throw in some INT, MOD, and ROW/COLUMN.

Another option is to use an INDEX(..SMALL( array formula to just dynamically pull all cells adjacent to the word Account.

If you can attach a small sample of your work I can build a formula for it.

[Pepe Le Mokko]

Hi and welcome

you could also filter out all rows not containing the word " account" in you new sheet

[Glenn Kennedy]

...like this:

=indirect("B"&(ROWS($1:1)-1)*12 +1)

[ChemistB]

Another option

=INDEX(Sheet1!$B$1:$B10000, ((ROWS($A$1:$A1)-1)*12+1)

[daffodil11]

Here's an example of INDEX(..SMALL(