Thank you Nick,

I appreciate you taking time to answer. It has helped me to decide what to
do.

Leonard

"Nick Hodge" <nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS> wrote in message
news:u04LwoKqGHA.220@TK2MSFTNGP05.phx.gbl...
> Leonard
>
> There is no true relational model as such in Excel. You do have the
VLOOKUP
> and HLOOKUP functions and similar. So for example you could have a
Customer
> Detail sheet and then on another sheet an invoice where an account number
> could be entered and pull through from the customer detail sheet.
>
> You can have combo boxes, etc in Excel, both from the forms or controls
> (ActiveX) toolboxes and even ones under data>data validation...
>
> Difficult to know if your project will suit...almost anything is possible
in
> Excel but some things are obviously better suited to other apps.
>
> One other thing to bear in mind...Excel is not a good 'sharer' so if it is
> multi user, consider some other way.
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Leonard Priestley" <priestly@ihug.co.nz> wrote in message
> news:e9c5rp$qmr$1@lust.ihug.co.nz...
> > My database programming experience to this point has been with Access.
I
> > have been asked to handle a project which I would normally tackle using
> > Access. However, existing data is already in Excel, and the person
> > requesting the work is keen to retain Excel. Can someone tell me:
> > Is it possible to create related tables in Excel so that one table can
be
> > used as a lookup for another? Also, is there any possibility of adding
> > something like a combo box or other drop-down list on an Excel sheet?
> >
> > Leonard Priestley
> >
> >
>
>