+ Reply to Thread
Results 1 to 1 of 1

Advancing Dates for Timesheets macro

  1. #1
    Registered User
    Join Date
    10-17-2014
    Location
    MN
    MS-Off Ver
    2010, 2013
    Posts
    29

    Advancing Dates for Timesheets macro

    Hi All!
    I had a macro for Employee Timesheet. Originally, we had our pay period begin on a Thursday. We have since changed our pay periods to begin on a Wednesday, and now my original macro is broken somehow.
    I'd like to change the macro so the dates update to then next pay period . For some reason the macro won't move the dates to the next pay period. It clears entries in cells, but it won't move the Dates ahead + 14 days.
    Attached:
    1. "Timesheet - Old Version - Filled" - this version is the original, before the pay period switch. The macro runs fine on this version
    2. "IVAN New Version - Filled" - this is our new pay period, the macro clears entries in cells, but it doesn't change the date ahead to the next pay period.
    3. "Timesheet Macro" - This is the current macro I'm using that's having issues. This works on the Old Version, but not the New version.

    I'm wondering if I need to change something within the macro, but I can't seem to figure it out and it's driving me crazy lol.

    Thanks SOOO much in advance!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-04-2017, 12:53 PM
  2. Make a Macro finish a full sheet calculate before advancing
    By metsci in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2017, 11:30 PM
  3. PLEASE HELP! Identify Dates of Missing Timesheets for Employees
    By PWM in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-09-2017, 04:08 AM
  4. [SOLVED] Excel Macro Advancing before Solver is finished
    By jdpcbs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-28-2014, 09:57 AM
  5. Preparing Company Timesheets with macro
    By ashleynsloan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2013, 06:07 PM
  6. Macro advancing to new month
    By pril in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2008, 04:04 PM
  7. Working with Dates for timesheets
    By jlyons360 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2005, 05:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1