You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by ouch <ou...@yahoo.com.INVALID> on 2015/01/20 22:02:21 UTC
Formula to step through sheets in a file?
Is it possible to make a formula that steps through the sheets in it or another file without knowing each sheets name?
I know scripting can do it, but I was wondering if there was a way to define sheets by an number or something... So if I wanted to do a vlookup on say sheet number 3 and have the formula read the 3rd sheet in the file regardless of it's name.
I asked this question on forum.openoffice.org and no one could think of a formula that would do that. So I thought I would send the idea to you folks.
you can see the thread here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=74817
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org