Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro on a data validation list
I have a Time sheet with a row G7:G:12 that contains Data Validation List.
In this list I have a value named Holiday, what I like to do is when you select this value "holiday" form the drop down list in cell G7 it would automatically add 9:00 am to cell D7,1.0 to cell E7 and 5:00 pm to cell F7. It should work the same for the rest of the other rows from G8:G12. I would actually would like just to paste a value of 7.00 to cell I7 where "Hours Worked" are but the formula would be deleted. I tried recording a macro but of course that was to specific to that recorded row and would not work with other rows. What I need is some guiding where to find a similar code that can be alter to fit my needs. Been looking in google but really don't know what keywords to search for. Thanks again for all your help, and hope I haven't been to much trouble this last month asking for help in the forum, you guys are great help. Kevin Brenner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - List - Setting Range from a macro | Excel Discussion (Misc queries) | |||
Data Validation List Macro | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions |