AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Help with excel formula
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Mark@Northern Iowa
Posted 2/17/2021 15:59 (#8839975 - in reply to #8837406)
Subject: C&S Farms Sample fix



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
----------------
Attachments C&S Farms Sample fix.xlsx (488KB - 32 downloads)
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete all cookies set by this site)