How can I make a spreadsheet for keeping track of current livestock numbers? I need to be able to easily read various totals for individual paddocks. I would need a function where I can add or remove livestock from one paddock to another and these new totals would automatically adjust and be displayed elsewhere on the page. I have a very basic understanding of the formulas I need to do this but with nearly 30 paddocks room is limited on the spreadsheet and I don't want to be constantly scrolling off screen to find the area of the spreadsheet I need. I also need the ability to backtrack through these movement records for future reference.
Thanks for any advice.
