ripdaddy50
New Member
- Joined
- Nov 10, 2014
- Messages
- 2
I am trying to allocate expenses across multiple columns (with the push of a button using macros) and divide the total expense by the amount of trucks that the expense is allocated to. We have a fleet of 11 trucks and will have an expense item that needs to be separated between a certain number of trucks, but all trucks may not get an allocation for a certain account item. I have put an example of what the report would look like with the keys to success for the report being that our guys can one-click to allocate and the sheet is able to divide the $ amount by the number of times that the row is clicked.
We would like for the crew leads out in the field to be able to just click on column "T-1", "T-4" and "T-7" and quickly allocate his expenses for supplies across those three trucks. The $ amount would be divided by the number of trucks that the expense is allocated to automatically when he clicks on the cell to allocate to a particular truck.
Any help that you all could give would be greatly appreciated. Our report includes hundreds of expenses per week and I need to make it as easy on my guys out in the field as possible.
[TABLE="width: 500"]
<tbody>[TR]
[TD]$ Amount
[/TD]
[TD]Invoice #
[/TD]
[TD]Account
[/TD]
[TD]T - 1
[/TD]
[TD]T - 2
[/TD]
[TD]T - 3
[/TD]
[TD]T - 4
[/TD]
[TD]T - 5
[/TD]
[TD]T - 6
[/TD]
[TD]T - 7
[/TD]
[/TR]
[TR]
[TD]74.52
[/TD]
[TD]1
[/TD]
[TD]Fuel
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]77.22
[/TD]
[TD]2
[/TD]
[TD]Supplies
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81.92
[/TD]
[TD]3
[/TD]
[TD]Equip[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]69.50
[/TD]
[TD]4
[/TD]
[TD]Uniform
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]76.31
[/TD]
[TD]5
[/TD]
[TD]Postage
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope that this makes sense. Please let me know if you have any questions.
We would like for the crew leads out in the field to be able to just click on column "T-1", "T-4" and "T-7" and quickly allocate his expenses for supplies across those three trucks. The $ amount would be divided by the number of trucks that the expense is allocated to automatically when he clicks on the cell to allocate to a particular truck.
Any help that you all could give would be greatly appreciated. Our report includes hundreds of expenses per week and I need to make it as easy on my guys out in the field as possible.
[TABLE="width: 500"]
<tbody>[TR]
[TD]$ Amount
[/TD]
[TD]Invoice #
[/TD]
[TD]Account
[/TD]
[TD]T - 1
[/TD]
[TD]T - 2
[/TD]
[TD]T - 3
[/TD]
[TD]T - 4
[/TD]
[TD]T - 5
[/TD]
[TD]T - 6
[/TD]
[TD]T - 7
[/TD]
[/TR]
[TR]
[TD]74.52
[/TD]
[TD]1
[/TD]
[TD]Fuel
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]77.22
[/TD]
[TD]2
[/TD]
[TD]Supplies
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81.92
[/TD]
[TD]3
[/TD]
[TD]Equip[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]69.50
[/TD]
[TD]4
[/TD]
[TD]Uniform
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]76.31
[/TD]
[TD]5
[/TD]
[TD]Postage
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope that this makes sense. Please let me know if you have any questions.