worksheet (3-D) reference formular.

[hong]

Hello,

I have
- 'Total' worksheet, summarize from 'store1','store2'.
- 'store1' worksheet, has detailed info. some are linked
to 'total'.

When I add 'store2' worksheet, and trying to add summaries
on 'Total' worksheet, <Fill> doesn't automatically grab
information from 'store2'.

In such case, instead of getting referece as ='store2'!K12,
can I use ='B2'!K12, and type in worksheet name on B2 cell?
When I try, it keep asking 'OPEN File' dialogue box.

 

[J.E. McGimpsey]

One way:

=INDIRECT(B2 & "!K12")