Update bi-weekly timecard

[BurtZ]

Hello, I've been given the payroll task at my small company. Our time sheets are in excel, which I need to manually update each biweekly period. I am looking for help on writing a macro that will update the dates on my excel time sheet. Here is a sample, sorry it didn't copy over nicely. Thanks in advance!

Pay Period

From:

1/8/2017

To:

1/21/2017

SUN.

Date:

1/8

MON.

Date:

1/9

TUE.

Date:

1/10

WED.

Date:

1/11

THUR.

Date:

1/12

FRI.

Date:

1/13

SAT.

Date:

1/14

SUN.

Date:

1/15

MON.

Date:

1/16

TUE.

Date:

1/17

WED.

Date:

1/18

THUR.

Date:

1/19

FRI.

Date:

1/20

SAT.

Date:

1/21

<colgroup><col><col span="2"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>

 

[j_unsuitable]

Hey

a few questions:
do you want to change the cells in your previous sheet or create a new sheet with the new dates?
do you only have to do the changes once for some template sheet or will you have to loop through several sheets/workbooks and change them all?
can you upload a sample file to some filesharing site and link to it here? It would help a lot knowing the actual cells the dates are in, the formatting etc..

Julian

 

[BurtZ]

Hey Julian,

I have one workbook with ~50 sheets, one per employee. I want to change the dates on all sheets and then on the next period, change the dates again. So, it would have to loop through each sheet...I think?? I will try to save this and re-post later. Thanks for your response.

 

[j_unsuitable]

Are there any sheets in the workbook the changes dont need to be made to?

When you post the file online, make sure its a dummy with no critical data like names, but with the exact same formatting as the original.
Use something like Free File Hosting - Online Storage; Upload Mp3, Videos, Music. Backup Files