Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the suggestion!
I unhid all of the sheets, looked on another tab (which only has one of the data validation lists) and looked around the HTML/XML scripting, but can't find where I can add a value to the existing list of values (for example, we have H, V, S, B, P for holiday, vacation, sick, birthday, personal that automatically inserts 8 hours into the time sheet). I want to add W for Weather, which wasn't tough to add so that it displays in the list of choices, but it doesn't make 8 hours appear. Instead you get an error message that was created within the script. "Outlook, eh?" wrote: Hello, My predecessor made a Timesheet form. I have been able to add information by going through datavalidationinput message, but I am not sure how to access the data that actually impacts calculations. I can see the source (that begins with =, but I am not sure where it is located or how to edit it). Any help would be great! -B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop Down List - Source from another workbook | Excel Discussion (Misc queries) | |||
Place source to drop down list in another spreadsheet | Links and Linking in Excel | |||
Edit Drop Down List | Excel Worksheet Functions | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
edit a drop down list | Excel Discussion (Misc queries) |