On Tuesday 06 February 2007, + Andy Fell wrote: > [ MODERATED ] ******************** > 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?
As you are not subscribed you may not have seen that: On Wednesday 07 February 2007, Ray Hurst wrote: > 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. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
