Good Morning
I have some knowledge on excel and but what I do know is a little out of date.
So I have been asked to build a Spread sheet for rostering purposes and what we are currently using seems so out of date even to me.
we have jobs which need covering ever day plus peoples rest days each job has a separate turn number and start and finish time.
What I would like to be able to do is type the job number in a cell lets say a1
then it fills in B1 C1 D1 with a start time, finish time and total hours worked.
I Have created a sheet with these all in a list but I do not know how to transfer the information onto another sheet. any help in this would be very gratefully recieved
I have some knowledge on excel and but what I do know is a little out of date.
So I have been asked to build a Spread sheet for rostering purposes and what we are currently using seems so out of date even to me.
we have jobs which need covering ever day plus peoples rest days each job has a separate turn number and start and finish time.
What I would like to be able to do is type the job number in a cell lets say a1
then it fills in B1 C1 D1 with a start time, finish time and total hours worked.
I Have created a sheet with these all in a list but I do not know how to transfer the information onto another sheet. any help in this would be very gratefully recieved