I have a workbook used to track project budgets. There is a separate worksheet with a data ledger for each project and a 'Master Ledger' worksheet that contains a summary of all the data on the individual project sheets. The master ledger is deleted and rebuilt using the data on the project sheets with VBA when a command button is pressed.
I now need to be able to build the project sheets using only the Master Ledger data. Workflow would be something like: 1) build master ledger from project sheets, 2) edit the data on master ledger, and 3) delete data on project sheets and then rebuild them using only the data from the master ledger.
All project sheets contain "(Data)" at the end of the sheet name to help identify them as project sheets. All ledgers start on row 9 including the master ledger. The master ledger contains a column with the originating sheet name. I've attached a small sample workbook to show you the basic layout of my tool.
I appreciate any help you can offer and will pay $25 by PayPal for a solution. If more info is needed, please let me know. Thank you!