+ Reply to Thread
Results 1 to 6 of 6

Date move over

  1. #1
    Registered User
    Join Date
    06-25-2021
    Location
    Waterloo, Canada
    MS-Off Ver
    2016
    Posts
    3

    Date move over

    Hello
    I am trying to create a macro that will essentially reset a line for payroll tracking.
    So I have a Rate of Payroll List in C4 that states if the payroll is monthly, bi-weekly, or weekly. I have a Date of Payroll Cell in D4. And I have a Date of next payroll in G4.
    What I want the macro to do is:
    A) take the date of next payroll and paste it into Date of Payroll. Basically just move it over after I completed the current date. *I have done this*
    B) by way of if functions, I want the macro to read what the Rate of Payroll (C4) list is and create the next date in my Date of Next Payroll (G4) cell.
    I want this to help keep track of various client's needs and save time by having it reset at the click of a button.
    Any help is greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Date move over

    You will greatly facilitate the task of responders when you read and apply what is written in the yellow bar at the top of the thread.

    Artik

  3. #3
    Registered User
    Join Date
    06-25-2021
    Location
    Waterloo, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Date move over

    Here is the file for people to look at
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Date move over

    e.g.
    Please Login or Register  to view this content.
    Artik

  5. #5
    Registered User
    Join Date
    06-25-2021
    Location
    Waterloo, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Date move over

    Thank you so much!

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Date move over

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

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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: 1
    Last Post: 10-08-2019, 09:28 PM
  2. [SOLVED] search for a string in a filename that contains a date and move to subfolder for that date
    By k00ljeep in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2017, 06:20 PM
  3. Replies: 1
    Last Post: 09-15-2014, 12:56 PM
  4. move date to next Monday if date is on a Friday, Saturday or Sunday
    By ea223 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2014, 01:54 PM
  5. Replies: 7
    Last Post: 07-01-2014, 01:09 PM
  6. Running Date move contents of column b,c,d,e.. up to new date
    By KellyAustralia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2013, 01:54 AM
  7. [SOLVED] Macro to add date move 5 collums right add next working day date
    By davechamp1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 03:42 PM

Tags for this Thread

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