Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
What you should do is name the list, InsertNameDefine..., 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|