Posted 2/17/2021 15:59 (#8839975 - in reply to #8837406) Subject: C&S Farms Sample fix
Floyd County, Iowa
Here are the changes I made that I thought would help your spreadsheet.
- Yellow cells are protected or auto calculated, DO NOT type in a color cell
- Data must be entered into their respective bin
- Sheet1, I did not fully understand what was all going on in this sheet, but i fixed what I could.
- Sheet1, changed name to Master
- Master, pulls data from each bin sheet
- Added Data Drops tab for information that is reused often
- Every Bin tab sheet is now exactly the same
- Every Bin tab sheet is calculated down to row 500
- Every Bin tab sheet has totals at the top that stay at the top when you scroll down
- Every Bin tab sheet has dropdowns for:
- - - Broker, Mill, Bin, LL, Driver, Freight, and Paid
- Every Bin tab sheet has dropdowns to row 500
- Every load that you had in your example are in the bin tabs that they belong to.
Have a good day