syedjaveed
New Member
- Joined
- Feb 28, 2013
- Messages
- 37
Hi Team,
Please help me with a coding.
I Generally have 7 Queues (Log in, Meeting, Break, East Queue, West Queue, Others,Log out) in a range B5 as a drop down list
And Just below that i have a start time and end time cells in B6 and B7.
I want such a macro where if i select any dropdown from B5 the start time shud appear and when i change the dropdown then a specific range us given where the Start time and End time should get capture and simultaneously the again the new start time should come when i change the Drop down.
please see the below format. And Suggest if it is possible to do so.
Thanks n Regards
Javeed
Please help me with a coding.
I Generally have 7 Queues (Log in, Meeting, Break, East Queue, West Queue, Others,Log out) in a range B5 as a drop down list
And Just below that i have a start time and end time cells in B6 and B7.
I want such a macro where if i select any dropdown from B5 the start time shud appear and when i change the dropdown then a specific range us given where the Start time and End time should get capture and simultaneously the again the new start time should come when i change the Drop down.
please see the below format. And Suggest if it is possible to do so.
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | Name | NBK | Person # | ||||||
3 | |||||||||
4 | |||||||||
5 | Code | Break | |||||||
6 | Start Time | ||||||||
7 | End Time | ||||||||
8 | |||||||||
9 | |||||||||
10 | Name | NBK | Person # | Code | Start Time | End Time | Comments | ||
11 | |||||||||
12 | |||||||||
13 | |||||||||
14 | |||||||||
15 | |||||||||
16 | |||||||||
17 | |||||||||
18 | |||||||||
19 | |||||||||
20 | |||||||||
21 | |||||||||
22 | |||||||||
Sheet1 |
Thanks n Regards
Javeed