Andy Fell wrote:
I know this is a very small and hopefully simple query but I am a new user to
ooo and can not find what I want in help.
I am trying to write a very simple spreadsheet fot accounts and want to rename
sheets for monts of the year, this I can do, how do I display info from a
previous month into a following month? I have tried using the excel command (eg
jan!a1) without sucess. Can anybody help?
Andy Fell
17 Gorse Farm Road
Nuneaton
CV11 6TH
[EMAIL PROTECTED]
Hi Andy,
It looks like the syntax should be 'jan.a1'.
An easier way to do it without knowing the syntax is as follows:
Say you have the following:
page name is Jan and cell A1 contains 5.
You want the page named Feb and cell A1 to contain the same data.
Type in page Feb cell A1 an '=' sign
Select page Jan, then select cell A1.
This will update cell A1 on page Feb with the correct cell address and
you should see a 5.
Ray
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
