Good evening!
I have a script which downloads stock quotes from Yahoo!, and in doing so creates multiple sheets (not the same number ever), all named for the stockticker. What I would like to do is average each individual cell in column H, across the sheets, so for example average Cell H2 on sheets MSFT, YHOO and SUN. Is this possible in script?
H2 is the first cell with data, but the end cell is always different.
Thanks for your help in advance!
Marc
I have a script which downloads stock quotes from Yahoo!, and in doing so creates multiple sheets (not the same number ever), all named for the stockticker. What I would like to do is average each individual cell in column H, across the sheets, so for example average Cell H2 on sheets MSFT, YHOO and SUN. Is this possible in script?
H2 is the first cell with data, but the end cell is always different.
Thanks for your help in advance!
Marc