+ Reply to Thread
Results 1 to 3 of 3

Create summary file from daily worksheet that will be cleared daily

  1. #1
    Registered User
    Join Date
    12-01-2017
    Location
    New Jersey
    MS-Off Ver
    2016
    Posts
    63

    Create summary file from daily worksheet that will be cleared daily

    Sheet1 contains the results of worksheets on a daily basis. Sheet 1 cell A1 contains today' date and cells A7:I7 contain the daily results. This sheet will be cleared and rerun daily. My goal is to use a macro to capture this daily summary data and insert it by date into a summary sheet. The summary sheet should start with row 2 to allow for headers with the first date in A2 to start with the additional data in columns B:J row 2. Each day and only once per day the results will be copied from sheet 1 and inserted into the summary sheet. Each subsequent day will be placed under the previous day. If the date already exists in Column A, end macro. If the date does not exist in Column A copy date from Sheet1 cell A1 and values from Sheet1 cells A7:I7 and paste into the Summary Sheet. dates will not always be the next day since this will probably not be done during weekends. Results will be cleared from sheet1 and will be rerun the next workday with hew results to paste to the summary sheet. The summary sheet will allow me to see the trend by workday recorded in the summary sheet

  2. #2
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Create summary file from daily worksheet that will be cleared daily

    Hi spyac,

    The following code should do what you want. The code assumes the summary sheet is named Summary and includes a header, and the sheet with the data is Sheet1.

    In a standard module:
    Please Login or Register  to view this content.
    HTH,
    Maud

  3. #3
    Registered User
    Join Date
    12-01-2017
    Location
    New Jersey
    MS-Off Ver
    2016
    Posts
    63

    Re: Create summary file from daily worksheet that will be cleared daily

    Hi Maud
    Your code worked perfectly Thank You for the help

+ 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. Transfer Daily Data from Daily Staffing Workbooks into a Running Annual Summary Workbook
    By nurseydiamond in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-07-2015, 07:05 PM
  2. Create daily transactions using daily prices table
    By ajob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2014, 05:05 AM
  3. Daily Allowance Calculation From Previous Daily Spending Against A Daily Budget
    By WillYoung351 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2014, 05:00 PM
  4. [SOLVED] How to create a daily sales tracker file when figures are altered every day?
    By sajithnair in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 02:52 PM
  5. macro to automatically create formulas for daily summary
    By jarssonn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2010, 09:01 PM
  6. [SOLVED] Q: how to create summary daily lists from another, and reverse
    By pak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2006, 03:30 PM
  7. [SOLVED] Q: how to create summary daily lists from another, and reverse
    By pak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2006, 03: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