I am hoping someone can help me with a problem I have.
I have 2 worksheets and I need a formula/VLookup to pull data automatically once the feed sheet is pasted in.
The 'Payroll' spreadsheet need to pull any exceptions from the 'Hours' sheet. (The hours exception codes are located in cells AF11 - AF20)
So for example Tom Smith has 3 separate periods of holiday hours within the 'Hours' sheet (totalling 8 hours) and I would like this to be pulled into the corresponding cells within the 'Payroll' sheet.
I hope I have explained this correctly and any assistance would be greatly appreciated.