| View previous topic :: View next topic |
| Author |
Message |
kiteroa
Newbie
Joined: 06 Jun 2008
Posts: 1
Location: Surrey
|
 Posted: Sat Jun 07, 2008 9:55 pm Post subject: Test for existence of sheet? |
 |
|
Is there a way to test in a formula whether or not a sheet with a given name exists?
I'll be adding separate sheets for receipts and for payments each month; I want to show year-to-date totals month by month on a first sheet - without having to adjust the formulas there! |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Jun 08, 2008 6:44 am Post subject: |
|
|
=ISREF(INDIRECT("Sheet2.A1"))
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
