G
Guest
I have a workbook that has been developed for labour costing. It contains all
the fundamentals; the raw data, the background data (job numbers, job names,
operatives' names and rates) and a pivot table. What I need now is a
convenient way to input the details of the operatives’ hours.
Let me expand. On one job for one week there may be four operatives at any
particular time working on one job. Can you think of method whereby
operatives can be inputted without using the auto fill option? For instance
how do I get around this very simple example:
Operative 1 and operative 2 are working on the same job, say Job 100, for a
week simultaneously and still manage to incorporate this data into one pivot
table?
Through data validation, using a dynamic range as the source, users are
forced to input an operatives name but at the moment only one operative's
name corresponds to one particular date but of course this isn't realistic.
Also I have IF statements that are specific to Monday through till Friday and
then an If statement for Saturday and one for Sunday to allow for overtime.
Clearly Autofill isn't practical as the user (probably not me!) will have to
make sure that the formula is correct, if it's not the figures churned out
become wrong. Even if I was doing this it would be tedious in itself. Also I
would plan to protect the worksheets so formulas could not be altered.
I've heard a lot about Macros, is this a Macro situation?
the fundamentals; the raw data, the background data (job numbers, job names,
operatives' names and rates) and a pivot table. What I need now is a
convenient way to input the details of the operatives’ hours.
Let me expand. On one job for one week there may be four operatives at any
particular time working on one job. Can you think of method whereby
operatives can be inputted without using the auto fill option? For instance
how do I get around this very simple example:
Operative 1 and operative 2 are working on the same job, say Job 100, for a
week simultaneously and still manage to incorporate this data into one pivot
table?
Through data validation, using a dynamic range as the source, users are
forced to input an operatives name but at the moment only one operative's
name corresponds to one particular date but of course this isn't realistic.
Also I have IF statements that are specific to Monday through till Friday and
then an If statement for Saturday and one for Sunday to allow for overtime.
Clearly Autofill isn't practical as the user (probably not me!) will have to
make sure that the formula is correct, if it's not the figures churned out
become wrong. Even if I was doing this it would be tedious in itself. Also I
would plan to protect the worksheets so formulas could not be altered.
I've heard a lot about Macros, is this a Macro situation?