Macro that creates new tip tracking sheet bi-weekly

[llittle]

I appreciate any assistance in advance.

I am an admin in the service industry and would like to update the format of our current tip tracking sheet that servers use to log the cash tips they recieve.

Row 1 contains 14 days, a single pay period, that spans Wednesday through Wednesday x2.
Column A contains the names of the servers and bussers
As a result, each of the following cells (columns B through O)by person contain the total $ for that day in tips recieved
Column P contains each persons totals using a simple SUM formula

Once the numbers have been entered for the last day of the pay period in column O, I want a new sheet created for the following pay period, named by date range and containing the updated dates in row 1 and duplicating the names in column A

Again, any assistance with this would be SO very appreciated!

Lindsey

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[llittle]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is the attached workbook with a BEFORE sheet containing the data, and an AFTER sheet showing the blank template with updated date range.

[alansidman]

In your master sheet, to make this work, in cell C1 change the hard coded date to =B1 and copy accross to O1. This will allow auto updates.

Please Login or Register  to view this content.

[llittle]

In your master sheet, to make this work, in cell C1 change the hard coded date to =B1 and copy accross to O1. This will allow auto updates.

Please Login or Register  to view this content.

Thank you for being so prompt with your solution! The only issue I am running into now is that the dates in row 1 are all the same (I followed your instructions and changed the data in cell C1 to =B1) after I run the macro, and the date range for each new worksheet only increases one day at a time. I probably misunderstood your directions. Here is the workbook with the adjustments and code you provided:

[alansidman]

Once you change the value in C1 to =B1 + 1, drag the formula across all the cells to P1. Do this in the first sheet only. The macro will take care of it in all subsequent sheets. My apologies for giving you the wrong formula for C1.

[llittle]

Thank you so much, ti works wonderfully!!!

[alansidman]

Thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.