Incrementing cell reference
 

I have created a spreadsheet that has four rows of data which are analysing a
set of information from a pivot table usign teh get pivot command. The
information being bought back is delivered by a cell on the far left (every
four lines), which refers to a value in another sheet.

I have repeated these four rows down the page to allow a series of data to
be analysed, I would expect the first four lines data to be ='1 Base'!A2 then
the next cell (four rows later) to display ='1 Base'!A3.

However Excel is instead incrementing it to ='1 Base'!A7. I have tried
changing the value manually and then filling down, in the hope that it will
pick up the pattern, but this does not work.

Any suggestions? There will be too many rows to manually correct.
--
Paul Mugleston
Data Officer from the UK

Incrementing cell reference
 

You can use INDIRECT or OFFSET to do this, both described in Excel
Help.

Hope this helps.

Pete

On Jan 10, 3:54*pm, Paul Mugleston
wrote:
I have created a spreadsheet that has four rows of data which are analysing a
set of information from a pivot table usign teh get pivot command. *The
information being bought back is delivered by a cell on the far left (every
four lines), which refers to a value in another sheet.

I have repeated these four rows down the page to allow a series of data to
be analysed, I would expect the first four lines data to be ='1 Base'!A2 then
the next cell (four rows later) to display ='1 Base'!A3. *

However Excel is instead incrementing it to ='1 Base'!A7. *I have tried
changing the value manually and then filling down, in the hope that it will
pick up the pattern, but this does not work.

Any suggestions? *There will be too many rows to manually correct.
--
Paul Mugleston
Data Officer from the UK