Hello, Sorry if this has been asked before but I've seemed to run into a bit of a wall with a spreadsheet I've been working on. Also I should note while I've had experience with Excel including VBA macros in the past, it's been awhile since I've used it so I apologize for my code possibly being a bit cumbersome.

I have a form where employee's can sign in and out and it logs the exact time on a worksheet for the member. I want to add a sheet where payroll can enter the dates they want and the employee name and it would show all of the times that the employee has signed in and out between those specific dates. Is there a way to do this? I know right now that they could just filter the dates on each employee log spreadsheet, but I'd like to make it more user friendly.

I have attached my spreadsheet if anyone would like to look at it.

Within the workbook are the worksheets:

Home
  • Home is just a button to launch the sign in form.

Employee
  • A list of employee names(Currently just "Test 1", "Test 2", etc...)

Log
  • This is where I'd like to have a drop down list of the employee's with a button where payroll can click it, it'll bring up a form where they could enter the two dates and a table would populate with all of the sign in and sign out entries of the requested employee within the specified dates.

Test 1/Test 2
  • Both of these are worksheets for the individual members where it logs their sign in and sign outs. Also has a column for the time worked for each session.


Is this something that I could logically do? Thanks in advance for any help.

Attachment: signin-db.xlsm