Help Please - User Database
There's a sample file here that uses Data Validation to provide a
dropdown list, or type a new item and it will be added to the list: http://www.contextures.com/excelfiles.html Under the heading 'Data Validation', look for 'Update Validation List' Simple_Simon wrote: Can Anybody please Help? I am developing a moderate spreadsheet for use at my work which will be for other people to use, now on my welcome screen i would like the people who use this file to enter thier names (into a list/combo box) so that it automatically updates the rest of the worksheets within the workbook. I have also created a worksheet within the workbook and called it UserDatabase, what i would like to do is for the list/combo box to update the userdatabase sheet if a new person enters thier name and also be able to have the option from a list, to select your name if you have used the file before and entered your name previously. I will have about 30 worksheets within the workbook and require the name in use to be linked to all of them. Best Rgds Simon Scott -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com