I want to enhance an existing spreadsheet to allow some automation. Imagine can achieve these by getting some macros written:
1. a monthly rollover of key closing balances to opening balances in next months spreadsheet
2. automatically at month end transfer summary of the months data onto a table of key data so that it is available for later months. e.g. In Feb spreadsheet show Jan data as history. In Mar sheet show Jan and Feb data as history. (Summarised)
3. after the finalisation of the months spreadsheet create 4 seperate spreadsheets that show 4 individual companies data. Anticipate may have to make data 'values only' as otherwise spreadsheet formulas may not work.