Return cell data from every Nth Row of a different sheet

**rch7279** · 07-22-2011, 10:10 AM

I need a formula to pull data from invoices in 1 worksheet into a summary in another worksheet.

For example on my summary sheet: I need Sheet1!H3 as the first value, and then to be able to copy the formula down as to have each the next value be Sheet1!H48 and so on always adding 45 to the H column after H3.

This will make my live so much easier. Any help is appreciated.

**sweep** · 07-22-2011, 10:15 AM

Hi,

This in row 1 and copied down will give the desired result

Note that if you intend the formula to be anywhere but row 1, you will have to adjust the formula to suit.

=INDEX(Sheet1!H:H,3+(ROW()-1)*45)