P
Paul Mugleston
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.
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.