worksheet (3-D) reference formular.

  • Thread starter Thread starter hong
  • Start date Start date
H

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.
 
Back
Top