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-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org