Drop down list changes, worksheets and multi-user

I am using Excel 2003 but have been a user of 2000 for a long time. I 've
worked through the creating of a drop down list and understand that but
cannot find advice on the following from Help, so could one of you kind
people out there explain to me:
How do I make changes to a drop down list (ie amend, add items). Indeed,
can I?
Can I use the list for all worksheets within a workbook (hence the need to
amend & add to the list?
I am cleansing a database which is why I am using the drop down list. I
shall then copy the workbook to disk to be loaded onto a completely different
pc (not connected in anyway to mine). Will the list be available if the
person that I am doing this for has another version of Excel?
Sorry to be dim.

What you should do is name the list, Insert>Name>Define..., and if you use a
dynamic formula, you can update it at will

=OFFSET($M$1,,,COUNTA($M:$M))

By using a name in the list, you can use it from any worksheet. And it
should work okay with other versions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ferdy" <[email protected]> wrote in message
news:[email protected]...
> I am using Excel 2003 but have been a user of 2000 for a long time. I 've
> worked through the creating of a drop down list and understand that but
> cannot find advice on the following from Help, so could one of you kind
> people out there explain to me:
> How do I make changes to a drop down list (ie amend, add items). Indeed,
> can I?
> Can I use the list for all worksheets within a workbook (hence the need to
> amend & add to the list?
> I am cleansing a database which is why I am using the drop down list. I
> shall then copy the workbook to disk to be loaded onto a completely
different
> pc (not connected in anyway to mine). Will the list be available if the
> person that I am doing this for has another version of Excel?
> Sorry to be dim.