Updating a timesheet from a lookup

[JW2989]

Hello, I am trying to create a timesheet, where users can enter their time (in hours) against a list of projects they are assigned to.

I have a table that contains Resources and holds the Projects, and then they are matched in a Resource Allocation table with a Start and End dates for the duration they are on the project.

I am trying to build a new sheet that users enter their time for a week.

1) They select their Name, and then the Week they wish to enter time for from 2 dropdowns. Once the name is selected it will pull through their projects they are allocated to in the Resource Allocation table.
2) They enter their total hours for the week in the table with the black border below.

Question 1) How do the users do a double search, one for the names, and one for the date from the Resource Table to load into a form similar to the one with the black border? It would need to search the relevant date column in the Resource Allocation table

Question 2 ) - How do I save those new values back in the table? Would I need a reference for the WeekID along with the Req_ID to find a specific cell to reference?

Any help is much appreciated

Timesheet.xlsx
	C	D	E	F	G	H	I	J	K
8	Project Allocations
9	Req_ID	Name	Project	07/02/22	08/02/2022	09/02/22	10/02/22	11/02/22
10	1	Jack	Wifi	0	0	0	0	0
11	2	Billy	Sales	0	0	0	0	0
12	3	Jack	Sales	0	0	0	0	0
13	4	Joe	Wifi	0	0	0	0	0
14	5	Joe	SAP	0	0	0	0	0
15
16
17
18		TimeSheet (dropdown to select name and weekto enter time)
19		SelectName	Jack
20		SelectWeek	07/02/2022
21
22		(Depending on dropdowns - it will display the projects and week that time needs to be entered
23		Projects	07/02/2022	08/02/2022	09/02/2022	10/02/2022	11/02/2022
24		Wifi	0	0	0	0	0
25		Sales	0	0	0	0	0
26
27
28
29
Sheet3

Cells with Data Validation
Cell	Allow	Criteria
E19	List	=$S$12#
E20	List	=$F$9:$H$9

.

 

[JW2989]

Answeredusing FILTER and Xlookup

 

[Fluff]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[JW2989]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

I used a separate timesheet for each user that is then Queried back into the main overall timesheet. I linked them together which enabled me to make edits and then send the data back. My method above was far too complicated and would have required pages of VBA