I am trying to set up a database in a single workbook with several
worksheets. I want to be able to see in a cell on the first sheet a number
that is the result of a formula using three other numbers on another sheet.
That's simple, but is there a way of then seeing those other numbers in a
drop down or in the same cell without having to go to their worksheet?

For instance, can I use a spinner to change an address in a cell to show
different sets of data?

I think the subject line says it more clearly.

Mike H


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 25/10/2004