+ Reply to Thread
Results 1 to 3 of 3

Copy data from daily sheet to weekly sheet

  1. #1
    Registered User
    Join Date
    09-17-2017
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2016
    Posts
    2

    Copy data from daily sheet to weekly sheet

    Hi,

    Pretty simple one for you guys probably.

    I have a daily data entry sheet (example attached)

    What I want to do is when I start a new day by clicking on the command button, it grabs the data in the yellow hightlighted cells (not usually highlighted, just done for example) and copys them to the weekly sheet placing them under the appropriate day for each day dated with green highlight.

    Cheers in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: Copy data from daily sheet to weekly sheet

    I usually use a find code, but it just wouldn't find the correct range, so I am using a loop to find the date.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-17-2017
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Copy data from daily sheet to weekly sheet

    Hey davesexcel,

    Great code mate. Works a treat.
    I've been busting a gut over this for days. Knew it had to be a loop of some sort, just couldn't quite reason the logic out myself.

    Thank heaps.

+ 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. [SOLVED] I need daily figures from 5 sheets adding together and automatically populate weekly sheet
    By Philm1971 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-22-2015, 07:07 AM
  2. how do i make a daily sheet weekly too?
    By supersue in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2015, 07:39 AM
  3. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  4. VBA CODE to Copy Paster data from one sheet to other sheet on a daily basis
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-26-2013, 12:06 PM
  5. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  6. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM
  7. Copy Daily data to Monthly data sheet
    By jbeardslee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2012, 08:39 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