Drop down list changes, worksheets and multi-user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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