Advice please

Occasional Visitor

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.

1 Reply

If you have a sample data,you can upload it... You can use PivotTable to achieve your outcome