L
Legacy 33122
Guest
I have a situation in which I have operatives every week carrying out certain duties which are all applicable to certain codes. I then want to pay them from the sum of the codes they have completed for the week.
I have not got my head around how to set this up. I could use data validation boxes in each cell for the respective names and codes. Then add in the frequency per line and then at the end of the week total up the values and that would what I propose to pay them. This is a somewhat longwinded approach though?
Is there another way to do this task. I know a little about userforms? If I was to use a userform would the information entered into it be able to update a list and then be compiled into a pivot table for the paying of the opeatives?
Any advice or idea's would be greatly appreciated.
I have not got my head around how to set this up. I could use data validation boxes in each cell for the respective names and codes. Then add in the frequency per line and then at the end of the week total up the values and that would what I propose to pay them. This is a somewhat longwinded approach though?
Is there another way to do this task. I know a little about userforms? If I was to use a userform would the information entered into it be able to update a list and then be compiled into a pivot table for the paying of the opeatives?
Any advice or idea's would be greatly appreciated.