|
Floyd County, Iowa | Craig,
.
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
Attachments
----------------
 C&S Farms Sample fix.xlsx (488KB - 172 downloads)
| |
|
Help with excel formula
