+ Reply to Thread
Results 1 to 3 of 3

Post a row below last once a day on schedule

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    SWEDEN
    MS-Off Ver
    2016
    Posts
    123

    Post a row below last once a day on schedule

    So I've got this wb where 5 times a day, it refreshing a single cell with data from another workbook - I got that done with VBA.

    The problem is I need to Archive the number once a day to a row, so that day becomes archived and is usefull later on.

    https://www.excelforum.com/attachmen...1&d=1607594490
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-20-2020
    Location
    Québec, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    19

    Re: Post a row below last once a day on schedule

    I just tried it changing the date on my computer and it works fine. You just need to run SetOnTime first to activate it.

    Please Login or Register  to view this content.
    If you ever need to cancel the task you need the scheduled time and the name of the macro

    Please Login or Register  to view this content.
    Last edited by nightseeker; 12-10-2020 at 08:17 AM.

  3. #3
    Registered User
    Join Date
    11-20-2020
    Location
    Québec, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    19

    Re: Post a row below last once a day on schedule

    Quote Originally Posted by HereComesTheBoom View Post
    So I've got this wb where 5 times a day, it refreshing a single cell with data from another workbook - I got that done with VBA.

    The problem is I need to Archive the number once a day to a row, so that day becomes archived and is usefull later on.

    https://www.excelforum.com/attachmen...1&d=1607594490
    Did you have time to check this out? I tested it when I wrote up the code and it worked fine.

+ 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. Creating individual schedule from master schedule
    By Baneet.Bhandari in forum Excel General
    Replies: 3
    Last Post: 07-28-2020, 12:16 AM
  2. Replies: 0
    Last Post: 12-05-2018, 07:24 AM
  3. Noob here- best approach to extract personal schedule based on an employee schedule sheet,
    By fortnight_skyrim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2018, 01:02 AM
  4. Tiered Interest Schedule and Loan Amortization Schedule
    By wh1968mbz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2015, 07:43 AM
  5. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  6. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  7. [SOLVED] Create patient schedule based on master therapist schedule
    By PapaBear in forum Excel General
    Replies: 8
    Last Post: 10-12-2005, 12:05 AM

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