Hi all,
I have created this dropdown list in excel that has 8 names in it. I want it to look up some data but i also want each name to eb updatable manually, Is this possible in excel with VBA? Im stuck!
Departments.xlsx
Hi all,
I have created this dropdown list in excel that has 8 names in it. I want it to look up some data but i also want each name to eb updatable manually, Is this possible in excel with VBA? Im stuck!
Departments.xlsx
What do you exactly mean by "but i also want each name to eb updatable manually"
Could you clarify?
Cheers!
Deep Dave
Like when I select a name from the drop down list..I want to be able to put data in the table manually for that specific selection and also have some pulled with fomulas into the selection. take a look at the attachement i included
I guess you will need to tell me where the Drop Down List is. When I open the file, the file is having issues and is repaired, and as a result, the Data Validation is being removed..
Else, attach a new file with a working DV & Expected Result.
I dont know if I can re attache the file. There is no data yet but I want to have each of the departments enter their own data after selecting their department name from DV list. Or may be I'll have to create another page or form for data entry? The data is basically just the times
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks