Copy Sheet to New Sheet depending on day of the week

[BDavidD]

Have a network data sheet that has loads of projects and dates. I update this sheet daily on my local machine, but I can't track changes.
I would like to copy this entire sheet to dedicated Monday-Friday sheets in the same workbook depending on what TODAY is. (If today is Monday, copy the sheet to the MONDAY tab, etc)
The following Monday, the whole copy / paste thing starts over.
In the end, I'll create an additional sheet that will show changes for the week.

 

[StephenCrump]

Welcome to the Forum!

Perhaps something like:

Worksheets("Network Data").Cells.Copy

With Worksheets(Format(Date, "dddd")).Range("A1")
    .PasteSpecial Paste:=xlPasteValues
    .PasteSpecial Paste:=xlPasteFormats
End With

 

[BDavidD]

Welcome to the Forum!

Perhaps something like:

Worksheets("Network Data").Cells.Copy

With Worksheets(Format(Date, "dddd")).Range("A1")
    .PasteSpecial Paste:=xlPasteValues
    .PasteSpecial Paste:=xlPasteFormats
End With

Thank you. I've been a lurker way too long.
What I really want to do is have 5 tabs already... Monday, Tuesday, Wednesday, Thursday, Friday.
When I press the button, I want the network data to overwrite whatever tab corresponds to the current day of the week.
I suppose that I could simply put 5 buttons on the page though.

 

[StephenCrump]

Did you try the code?

What I really want to do is have 5 tabs already... Monday, Tuesday, Wednesday, Thursday, Friday.

That's what I assumed.

When I press the button, I want the network data to overwrite whatever tab corresponds to the current day of the week.
I suppose that I could simply put 5 buttons on the page though.

That's what the code does - only one button required.

 

[BDavidD]

Did you try the code?



That's what I assumed.



That's what the code does - only one button required.

I can't apologize enough @StephenCrump. Your code looked too simple to work.
I won't ever doubt you again. It works perfectly. I'm adding it to my personal macro space.

 

[StephenCrump]

Your code looked too simple to work.

Ha ha, no problem at all. I'm glad we could help.