Need to select data based on conditions in a separate sheet then return the values

Hi All,

I am new to the more advanced uses of Excel and a total novice at Macros etc. The problem that I have is that I have a userform that (amongst other things) adds overtime data for multiple people, for multiple project reports into a worksheet. The trouble is, is that I would like to be able to extract this data and format it in a certain way. I am struggling to firstly - understand what the best method is to select and format the data (is it a formula or macro) and then once that is understood how I structure the formula/macro.

I would appreciate a steer in the right direction please!

overtime_example.xlsx
I have attached the workbook.

Overtime is submitted after the week it was done. (i.e. Current week minus 1)
If Team Member name in "Overtime" column A, matches a name and the week number (28) from "ProjectUpdates"
If match found then copy acrosss the week commencing date ("ProjectUpdates column E) and copy across the overtime hours for mon/tues/wed etc into the corresponding columns in "Overtime"
Then move to the next name in the list etc etc.....

many thanks

Does the data on the "ProjectUpdates" worksheet come autopopulated for you? Is it always the same 3 team members who work together?

Hi,
yes the data is auto populated via a form that the project owner completes. Also, yes, the same people will always work as a team.