Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please - User Database
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
MS JET database engine error: workgroup information file is missing or opened exclusively by another user | Excel Discussion (Misc queries) | |||
Required multiple user name and password logins for database query | Excel Discussion (Misc queries) |