Excel 2007 copying formula with pattern

**dub_01** · 08-23-2011, 04:14 AM

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.

The formulas that I'm having issues with are in Sheet2, and are as follows:

Cell B1 ='Sheet1'!E1
Cell B2 ='Sheet1'!E16
Cell B3 ='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!

**Andrew-R** · 08-23-2011, 04:54 AM

In cell B1 put the formula:

Please Login or Register  to view this content.

And copy that down.

**dub_01** · 08-23-2011, 10:09 AM

Excellent, thanks alot!

**nscott57** · 09-25-2013, 02:06 PM

Originally Posted by Andrew-R

In cell B1 put the formula:

Please Login or Register  to view this content.

And copy that down.

I'm trying to do the same thing, but my information is on the same sheet. What how do I go about this?

I want information from C22, C34, C46 to be put in E1, E2, E3.

Thanks