I am a grain grower, and am looking for a way for Excel to track the grain that comes off the paddock and taken either to on-farm storage, or off-farm. We currently have a master list of every truckload of grain that is carted. This list could have hundreds or more entries. Trucks could be collecting the grain straight from the paddock, or from the on-farm storage. It could then be taken either to another on-farm storage, or off-farm. So a source could be a destination and vice-a-versa, and new storage locations are added all the time. We can also have more than one variety of grain stored in the one location. What we need is a summary of the tonnage stored in each location, which can easily be done by calculating the total tonnage at ‘destination’ and subtracting the total tonnage at ‘source’ using SUMIF formulas, but this will not tell us the breakdown of different varieties in the one storage location. We need the summary of grain stored by location and variety to be dynamic (like a pivot table) as the master list of grain carted is updated constantly, and the summary needs to update automatically.
Is there a way to do this?
I’ve included a simplified master list and an example of what we need the summary of stored grain to look like.
Thanks for your help
Bookmarks