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