Excel spreadsheet alterations

This project involves enhancing an Excel workbook used to track finances for a football club. The existing workbook contains multiple spreadsheet tabs, one for each team, with a running monthly total displayed at the top of each sheet. However, the number of rows available for inputting individual bank transaction details is limited. The goal of this project is to modify the workbook's structure to allow efficient entry and tracking of all expected financial transactions through next year. Some potential solutions include inserting additional rows on each tab, converting to a more flexible layout, or developing VBA macros to dynamically generate rows as needed. The ideal candidate will have strong Excel skills including functions like SUMIFS and experience working with multiple related sheets. They should propose an optimized design that maintains existing functionality while future-proofing against data volume growth. clarity and documentation of any changes made will be appreciated. The final deliverable is an updated Excel file with an improved system for comprehensive recording of bank activity for each team over the next 12 months.