Duplicate Existing Worksheet and Name Tab

[Papi]

I am trying to to take a formatted worksheet called Blank which sits on the far left side and copy it to the far right side (next to the last working sheet) and change cell D1 to reflect seven days more than the last sheet i.e. Jul 25 would now becom Aug 1 etc.

Each tab is named the month and day using "mmm d" which is sitting as a formula in Cell H1 named Tab_Name =CONCATENATE(TEXT(D1,"mmm")," ",TEXT(D1,"d")) so would like to have the tab named using that format.

Any help would be greatly appreciated.

 

[Papi]

Hello Peter,

You are 100% correct on both counts. Your code works great! Thank you so much for all time and especially your patience Peter.

 

[VoG]

Thank goodness for that. I was beginning to think I had finally lost the plot

 

[Papi]

NOPE...You are in fine form Peter! Thanks again.