replicate sheets from master

[sniper.007]

Hello Everyone,

I'm new to VB & Macros in Excel, & I would like your help.

I am trying to create a personal budget sheet to track my income & expenditure, so that it can be updated day to day.
I would like to create a master sheet, with particular formatting of headings etc.
I would then like to create sheets for each month of the tax year, that will update from the master, so that any changes on the master will flow through onto the other sheets.
I would like them to update from the master so that if a new expense is incurred, i can update the master with the type of expense, then simply insert the amount data for the relevant month.
Finally, I would like to have a summary/year-to-date sheet at the end that I can give to my accountant at tax time, with the hard work already done throughout the year.

Thankyou in advance for your help.

[davesexcel]

Welcome to the Forum.

Have you a specific question?

[royUK]

I wouldn't have monthly sheets, all data should be saved to one master sheet, with a column for dates. Then a PivotTable could be used, group the days by Months

Your workbook would need a better design to implement these suggestions