Thank you again Brian, yesterday I tried all-sorts to try and get this
working, looking at your solution I was nearly there. -- So much to learn.
What is the best source for this sort of information?
I would like to learn more and make my spreadsheets more efficient.
I must admit that the help
hunting!
Regards from
Tom :)
From: Paul Stear p...@appjaws.plus.com
To: users@global.libreoffice.org
Sent: Tuesday, 13 November 2012, 16:06
Subject: Re: [libreoffice-users] Auto changes on a new spreadsheet set for
next year
Thank you again Brian
Hi Brian,
Thank you so much, your solution works a treat.
My spreadsheet consists of 15 pages each year, so my next question is:-
would it be possible to put the new year on page 1 named cover in cell A2
and then change the A1-1 to reference this on for each instance on every
page?
Hope this is
At 14:42 12/11/2012 +, Paul Stear wrote:
On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote:
At 11:45 08/11/2012 +, Paul Stear wrote:
I have the same spreadsheet set I use each year. The new
spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet. For the past
Brian,
Thank you so much, I have been away so have not tried your solution yet but it
does look good.
I will test this in the morning, this could save me hours of work
Thank again
Paul
On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote:
At 11:45 08/11/2012 +, Paul Stear wrote:
I have the
I have the same spreadsheet set I use each year.
The new spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet.
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
The 2012 spreadsheet is referenced to 'file:///home/fred/Generation
Readings-2011.ods'#$Jan.A68
For
On 11/08/2012 06:45 AM, Paul Stear wrote:
I have the same spreadsheet set I use each year.
The new spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet.
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
The 2012 spreadsheet is referenced to
At 11:45 08/11/2012 +, Paul Stear wrote:
I have the same spreadsheet set I use each year. The new
spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet. For the past few years I have manually changed the
Readings-2012 in every instance (well over 100).
I would like