How to copy Array and paste based on day of the month

[Pipen319]

Hi, I am trying to create a Daily Coverage. I have Two Sheets one with all my Templates and the other is where I need the copy and paste the specific template based on the day of the week. It will be Ideal if I can create a Button and assign a Macro in which based on the day of the week(Monday....Sunday) it will look on the other Sheet("TEMPLATES") and when the day matches it could copy the array of that day and paste in the first Sheet("Daily")

Thank you very much!! and Happy New Year!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to copy Array and paste based on day of the Week
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Pipen319]

How to copy Array and paste based on day of the Week [SOLVED]

Hi, I am trying to create a Daily Coverage. I have Two Sheets one with all my Templates and the other is where I need the copy and paste the specific template based on the day of the week. It will be Ideal if I can create a Button and assign a Macro in which based on the day of the...

www.excelforum.com