Creating 5 year Monthly Budget - need sequential dates formula/function/vba

Hi there,

I am new to Excel 2013/2016. I am creating a household financials and want to build 5 years of monthly budgets. I would like to have a formula, function or vba to copy the data of "1 Jan 2018" in cell B3 on Sheet '1 Jan 2018' to the second sheet named '1 Feb 2018' placing the next month "1 Feb 2018" in Cell B3.

I found a vba that was able to copy across sequentially the worksheet names adding one month per sheet 1 Jan 2018 + 1 Month x 60 sheets using cells on a hidden sheet. It worked great but I cant figure out how to do this for a cell.

Thanks so much for the help, if anyone can provide it!

Cheers

Why you want 60 tabs with same data ?

Kind regards
Leo

5 year monthly budget sheets (5*12=60) Cell B3 is the Day-Month-Year, workbook will have many more sheets financial statements etc. Trying to build a template. I just cant figure out how to produce the dd/mm/yy in a sequence across 60 sheets.

Originally Posted by bakerman2

Post the code you are using to create the sheets.

This is the code I used to "Name" the Sheets the dd/mm/yy. Plan is to create a 5 year (5*12=60) budget template with multiple more sheets; such as, acc pay, acc recieve, inc/exp, financial, amortizations, net worth. etc.

Sub RenameSheets()
Dim c As Range
Dim J As Integer

J = 0
For Each c In Range("C2:C61")
J = J + 1
If Sheets(J).Name = "Control" Then J = J + 1
Sheets(J).Name = c.Text
Next c
End Sub

Where "Control" Sheet will be hidden. In the Control sheet, I have a simple data set with A1 Date / B1 Month / C1 Result using =EDATE(A2,B2).

Result C2 = 1-Jan-2018
Result C3 = 1-Feb-2018
etc.

Once again. Im looking for help with a formula, function, or vba to date each sheet sequentially in one specific cell across all 60 budget worksheets. i.e. 1-Jan-2018 + 1 Month = 1-Feb-2018 all the way to 1-Dec-2022 (and then the template would allow me and users (family) to go beyond..

Every thing I have tried and a friend has tried hasnt worked.

Thank you so much!