Hi,
I input hours worked on a daily basis in a sheet called 'Fire Register'.
I want to take the amount of hours worked daily and transfer to another sheet based on the employees clock number.
The employees clock number is 'Fire Register' column D. If that number corresponds with the number in 'Stafforce Sheet' column A, I need the following info transferring:- The employees name and surname which would be in columns B & C in 'Fire Register', these would be put in to columns B & C in the 'Stafforce Sheet'. Then I need the hours transferring which would be in columns G,I,K,M,O,Q & S of the 'Fire Register'. These would be transferred to 'Stafforce Sheet' columns D,E,F,G,H,I & J.
I am assuming this would be a VLOOKUP sort of equation which I am not to familiar with.
Hope this makes sense and someone can help.
this is a link to my workbook https://www.dropbox.com/s/d60ozbk1yy...2023.xlsx?dl=0
Bookmarks