hunting!
Regards from
Tom :)
>
> From: Paul Stear
>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 Bria
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 pag
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 few
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 th
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 th
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
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 'file:///home/fred/Gener
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 the