Help for Excel Macro code (copy or move yesterday's tab to new one with today's date)

[pmchris]

Hi;

I want to create an Excel Macro code that copy or move worksheet with yesterday's date to a new worksheet within the same workbook and name it as today's date. For example, yesterday's tab name is Nov 17, and when new tab is created, its name should be Nov 18. so when I run the macro everyday, it always goes like this except weekend.

I appreciate if anyone can help.

Chris

[rcm]

It can be done. Have you tried recording this action? that will give you the template to work with all it is left to do is to name the tabs correctly by checking against the last days of the month and weekends.

[Alf]

Perhaps a macro like this then?

Please Login or Register  to view this content.

As I assume you don't run this macro on Saturday or Sunday the is no checking on weekday name. Also the Scandinavian date system is a bit different from yours in regard of the order months and date are placed so if you don't get the right date formate i.e. "now 18" you could try to change the sName setting to

Please Login or Register  to view this content.

.

Alf