Hi there, iv been asked at work to come up with this time sheet but
haven’t really thouched on the coding side of excel before,

What I have is two sheets, one called Table and the other called Times.
Table is meant to hold all the data of what times the job was started
and stopped at on each of the days, there is also a check box next to
the days to be checked if the job has run over the lunch break to then
subtract the 30mins break.

I need a user form with a combo box at the top which the users is able
to select the job number from the first column ‘A’ then below two combo
boxes for each day with a list of times from Sheet ‘times’ inside.

When the user form is fill in and the enter button is pressed. I need
it to find the right row, on the ‘Table’ sheet from what was chosen
from the top combo box at the top of the form, and then fill in the
rest of the sheet with the other times selected from the other boxes.

Thanks Clare Foxly


+-------------------------------------------------------------------+
|Filename: time sheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3474 |
+-------------------------------------------------------------------+

--
clarefoxly
------------------------------------------------------------------------
clarefoxly's Profile: http://www.excelforum.com/member.php...o&userid=24183
View this thread: http://www.excelforum.com/showthread...hreadid=378036

If you have no coding experience then
I'd try to stick to

data validation
(for your dropdowns and user input)
conditional formatting
(to signal incomplete data)

else just tell your boss
to hire a coder or send you to a VBA course.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


clarefoxly wrote :


Hi there, iv been asked at work to come up with this time sheet but
haven’t really thouched on the coding side of excel before,

What I have is two sheets, one called Table and the other called
Times. Table is meant to hold all the data of what times the job was
started and stopped at on each of the days, there is also a check box
next to the days to be checked if the job has run over the lunch
break to then subtract the 30mins break.

I need a user form with a combo box at the top which the users is able
to select the job number from the first column ‘A’ then below two
combo boxes for each day with a list of times from Sheet ‘times’
inside.

When the user form is fill in and the enter button is pressed. I need
it to find the right row, on the ‘Table’ sheet from what was chosen
from the top combo box at the top of the form, and then fill in the
rest of the sheet with the other times selected from the other boxes.

Thanks Clare Foxly


+-------------------------------------------------------------------+
Filename: time sheet.zip |
Download: http://www.excelforum.com/attachment.php?postid=3474 |
+-------------------------------------------------------------------+

ok thanks, but this is only a one off and was wondring if anyone else
has any advise to give?

Thanks Clare


--
clarefoxly
------------------------------------------------------------------------
clarefoxly's Profile: http://www.excelforum.com/member.php...o&userid=24183
View this thread: http://www.excelforum.com/showthread...hreadid=378036