Closed Thread
Results 1 to 5 of 5

New daily sheet with column copy

  1. #1
    Registered User
    Join Date
    07-22-2018
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    19

    Question New daily sheet with column copy

    I need a code what actually creates daily a new sheet with the todays date as a name and from a reference sheet copies the values from the A and B column into the sheet created by the today's date. I would like to assign a button as well to run it manually or set the code to do automatically if the current time is over the set time and ignore if if before the set time or already created.


    Please Login or Register  to view this content.
    Last edited by sarxes; 07-26-2018 at 11:11 AM. Reason: Helping with the code given.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: Auto daily sheet with with data report and today's date

    Hi sarxes and welcome.

    A few clarification questions for you:
    1) When you say "auto changing sheet" how does this update? Does it update when you chose (i.e. you click a button) or is it a live link to a data source that updates at a specified time/frequency?
    2) When it updates does all data get overwritten? Is it just added to at the bottom of the list?
    3) How do you want this code to launch? When you click a button or at a specified time?
    4) Could you attach some sample data in a workbook and show us your expected output?
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB

  3. #3
    Registered User
    Join Date
    07-22-2018
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    19

    Re: Auto daily sheet with with data report and today's date

    Replied to your answer
    Last edited by sarxes; 07-24-2018 at 11:52 AM.

  4. #4
    Registered User
    Join Date
    07-22-2018
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    19

    Re: Auto daily sheet with with data report and today's date

    Quote Originally Posted by BadlySpelledBuoy View Post
    Hi sarxes and welcome.

    A few clarification questions for you:
    1) When you say "auto changing sheet" how does this update? Does it update when you chose (i.e. you click a button) or is it a live link to a data source that updates at a specified time/frequency?
    2) When it updates does all data get overwritten? Is it just added to at the bottom of the list?
    3) How do you want this code to launch? When you click a button or at a specified time?
    4) Could you attach some sample data in a workbook and show us your expected output?
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB
    Never mind the auto changing, it's just my idea, it's only updates by the TODAY 's function.

    I don't need my data to be owerwritten, just to make a copy from the DataInput sheet from the A and B column and pastes the values it into a new sheet what has the today's date name. I don't know if it 's possi,ble to save every day at 16:00 would be the best automatically.
    I want to have those new sheets to be created like the example on the pictures

    help1.JPG
    help2.JPG

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,245

    Re: New daily sheet with column copy

    OP has posted in CS forum, so I am closing this 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Daily Report with today's date
    By zahidislam14 in forum Excel General
    Replies: 4
    Last Post: 06-06-2018, 01:21 PM
  2. Replies: 2
    Last Post: 10-18-2017, 02:12 PM
  3. Replies: 0
    Last Post: 10-14-2015, 12:53 PM
  4. Replies: 4
    Last Post: 02-01-2014, 10:37 PM
  5. How to collect daily report from spread sheet and accumulate for monthly report
    By yshguru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2013, 05:17 PM
  6. Replies: 2
    Last Post: 11-19-2010, 07:49 AM
  7. Auto update daily report problem
    By SteveG in forum Excel General
    Replies: 4
    Last Post: 02-09-2006, 04:30 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