wrightyrx7
08-29-2012, 03:40 AM
Hi all,
I have a spreadsheet which I am trying to make more automated as we have to do this calculation once a day.
Column A - Staff Numbers
Column B - Code
Column E - Miles
Each Staff Number can have multiple rows from 1 - 100
If like the below example a Staff Member has lots of miles. They have to be split into batches less than 999.
The default CODE all the rows contain when i run this report is CVX. But for each time the number of miles goes above 999 the codes has to be changed to MIL1, if after splitting these if there is still more than 999 any remaining will go onto MIL2 and so on. (We have never come across one that goes above MIL4 if this helps make the code simpler)
I hope i have explained this enough. Please see image below hopefully it will show what i mean.
SEE EXAMPLE BELOW.
http://i45.tinypic.com/15s6mih.jpg
Any help would be great
Thanks
Chris
I have a spreadsheet which I am trying to make more automated as we have to do this calculation once a day.
Column A - Staff Numbers
Column B - Code
Column E - Miles
Each Staff Number can have multiple rows from 1 - 100
If like the below example a Staff Member has lots of miles. They have to be split into batches less than 999.
The default CODE all the rows contain when i run this report is CVX. But for each time the number of miles goes above 999 the codes has to be changed to MIL1, if after splitting these if there is still more than 999 any remaining will go onto MIL2 and so on. (We have never come across one that goes above MIL4 if this helps make the code simpler)
I hope i have explained this enough. Please see image below hopefully it will show what i mean.
SEE EXAMPLE BELOW.
http://i45.tinypic.com/15s6mih.jpg
Any help would be great
Thanks
Chris