VBA / CODE to COPY TO NEW SHEETS when i make them.

**xwarlock10x** · 07-02-2013, 09:59 PM

first off i would like to thank this site for helping me out with so much..
this is what i have.. i have a workbook that has about 100 sheets in it. each sheet represents each Friday and Saturday of the month.
what i do is, i have a "blank sign in sheet" that has all my formulas and Vlookups and such. I copy this "blank sign in sheet" and paste it to a new sheet. then i name the new sheet to what ever that weekends date is .. IE. JULY 5TH AND JULY 6TH
on all the prior weekend sheets i have some code on them.. but when i copy the "blank sign in sheet" and paste it.. it doesn't paste the code with it.
this is the code i have..

Please Login or Register  to view this content.

what i want is this code to be on the "blank sign in" sheet and when i copy it and then paste it to the new sheet.. i want the code to go with it.. is there a way to do this.. ??
thanks in advance
Jason

**aydeegee** · 07-05-2013, 04:42 PM

Hi Jason

To create a new sheet, have you tried right: click on sheet tab / move or copy / tick create a copy.

This will take your code to the new sheet.

Regards
Alastair