VBA Daily new worksheet

[anmorale]

excel vba, my workbook produce a new daily worksheet every day, witch it is ok, my question is, in VBA, how can refer to the new created sheet as a reference, tab name and sheet number changes everyday

 

[anmorale]

 

[Logit]

Modify your existing code so it names the new sheet as the current date?

 

[anmorale]

thank you for your answer, but the problem is that i would like to copy to a new sheet any work order that have a follow-up status but in my code i don't know how to name the sheet that already have today date, everyday i will make a new worksheet, i need something else but not "Sheet1 as a reference where from where to copy
i was thinking something like " sheets("sheetName"). Activate"

 

[anmorale]

thank you for your answer, but the problem is that i would like to copy to a new sheet any work order that have a follow-up status but in my code i don't know how to name the sheet that already have today date, everyday i will make a new worksheet, i need something else but not "Sheet1 as a reference where from where to copy
i was thinking something like " sheets("sheetName"). Activate"

 

[Logit]

Post your workbook to a download site then post the link here.

 

[kevin9999]

Is your sheet with the date always in the same relative position in your workbook? It looks from your image that you may have sheets to the left of the displayed sheet, but if that number changes - and you always have your new sheet situated immediately to the left of the "Master" sheet - you could perhaps use something like this:

Dim ws As Worksheet
Set ws = Sheets(Sheets.Count - 7)

then you could use the variable "ws" as your sheet reference, like this:

Set statusCol = ws.Range("E2:E14")

 

[anmorale]

thank you so much for your help. it is working very good now. good solution

 

[kevin9999]

thank you so much for your help. it is working very good now. good solution

Happy to help, and thanks for the feedback