|
NEOh | What you could do is consistently for each field, use the same template with figures you are interested in comparing. Go to a clean page in the same file, and pull figures from each field record using a simple formula "+'sheet1'.d27" and so on. Sheet 1 could be replaced with Field 10 if that is how you identify your spreadsheet tabs. If you standardize where the sought after information shows on each Field sheet (at the top?), the Summary sheet can be used time after time without need to change it. Just erase data input areas in the field sheets and save them under a new crop year. Leave the formula areas alone they will clear themselves. There, that's as clear as NE Ohio mud.
Art | |
|