Excel 2007 copying formula with pattern (Office, formulas, how to, work)

[dub_01]

Hi Guys,

I've asked around the office, googled and still can't find out how to go about this.

I have 2 worksheets, Sheet1 where information is entered and Sheet2 which extracts the key info and summarises and presents in comparable format.

In Sheet2 my formulas are therefore as follows:

='Sheet1'!E1
='Sheet1'!E16
='Sheet1'!E31
etc.

I need to continue this pattern downwards for 50-100 rows. Clicking and dragging simply increses the increment by 1 instead of 15 like I would need. Is there any way of simplifying this, as I don't really want to do this manually if possible?!!

Thanks in advance!

[oddstray]

You might get an answer if you post your question here: Excel Worksheet Functions - Excel Help Forum

[Spookmeister]

Enter ''Sheet1'!E into a cell(assume A1). Move cursor to bottom right hand corner of that cell and drag down to as many cells as you want the formulae. Enter 1, 16, 31 into the next column, each value in a different cell going down(assume B1, B2, B3). Highlight the three cells, move cursor to bottom right hand corner of the lowest cell, double click and you'll have the 15 increment you want for your cells.
In the next column, enter =A1&B1 (assume cell C1), move cursor to bottom right hand corner of the cell, double click and you'll have the joined formulae all the way.
Highlight your formula column, copy it, right click into cell D1, select the PASTE SPECIAL option, select VALUES only and you have the formula you want, repeated, as many times as you need.

Please note there are two (2) ' ' before SHEET and only one (1) ', after the number 1