On Wed, 2 Nov 2005 13:28:01 -0800, j2thea
wrote:
I've made a main sheet that pulls data from the other sheets. If I hide the
other sheets with the data, my data isnt pulled from the other sheets. Is
there a way, wihtout vb, to make the other sheets hidden but still usable?
How does it 'pull the data' from the other sheets?
That rather suggests that you're running a macro since I can see no
reason why a formula which refers to cells on a hidden sheet wouldn't
work.
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________