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
|