Create new sheets based on a date list on another sheet within the same workbook

[WillySean]

Hello Great people,

I am new to Excel VBA Macros and would like to know how to Create new sheets based on a date list on another sheet within the same workbook. I want the sheets to be named after the dates. Kindly assist with the code, like a format.

the date list is found in two worksheets named "PURCHASES" and "SALES", in range "G4: lastcell" on both worksheets. I want the newly generated sheets to be named sequentially and if any date is entered in the cells, they should be updated automatically on the worksheet names.



i need the code guide please.

 

[ravishankar]

Sub willy()
Dim a As Long
  For a = 4 To sheets(SALES").Cells(Rows.Count, "G").End(xlUp).Row
  Sheets.Add.Name = Cells(a, 7)
  Next a
  MsgBox "complete"
End Sub

this will create sheets but does not update as you update cells
ravi shankar

 

[WillySean]

Sub willy()
Dim a As Long
  For a = 4 To sheets(SALES").Cells(Rows.Count, "G").End(xlUp).Row
  Sheets.Add.Name = Cells(a, 7)
  Next a
  MsgBox "complete"
End Sub

this will create sheets but does not update as you update cells
ravi shankar

Thank you very much Ravi,

would you mind I send the excel document to you, so you can help look it up?

I want it to really add new sheets automatically the moment I add enter values into a new cell.
I also want it the sheets names to automatically change, the moment I alter the values in a cell that is linked to the sheet name.

 

[Fluff]

If you wish to share your workbook please upload it to a share site & post a link to it in this thread.

Please see rule#4

 

[WillySean]

If you wish to share your workbook please upload it to a share site & post a link to it in this thread.

Please see rule#4

I apologize for my unruly action.

Here is the link to the file https://ufile.io/avj43

 

[ravishankar]

[h=1]https://ufile.io/avj43
This site can’t be reached[/h][FONT=&quot]uploadfiles.io’s server IP address could not be found.[/FONT]

 

[WillySean]

https://ufile.io/avj43
This site can’t be reached

uploadfiles.io’s server IP address could not be found.

I really do not know what is going on. it's working fine on my end.

 

[Fluff]

That link works fine for me.