+ Reply to Thread
Results 1 to 5 of 5

Collect changed data only

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Collect changed data only

    As shown in the example I would like to know how to write VBA that will let me past daily information to my master sheet and then add it to the Daily Collection Sheet while saving the previous days additions, continuing down the columns.
    Attached Files Attached Files

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Collect changed data only

    How about just copypasting data onto the bottom of the Master Sheet, and after you make that an Autotable, you just feed that into a Pivot Table? See attached.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Collect changed data only

    This would work but there are about 500 line items in the real master file and this has to be done daily so I am hoping that VBA can save the manual part of the daily routine.
    Thank you for the suggestion.

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Collect changed data only

    An autotable will automatically expand to include new data appended to the bottom of it, and if the PivotTable is defined from the autotable instead of a range, then all you gotta do is click the "update" button on the PT and it will be good.

    I mean, if you're in a position where you're trying to automate a daily task, I'd be looking at this copypasta business first (external data connection maybe? IDK what the structure of the data you're pulling from is), and then once you've got the import automated, only then look at how you're generating a report.

  5. #5
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Collect changed data only

    Thank you, I think I will use your suggestions and see how it works.

+ 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. Collect employee data from workbook and write data in another sheet
    By eddijensen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2018, 05:52 PM
  2. VBA to collect data
    By Macca_GB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2015, 01:12 PM
  3. Replies: 3
    Last Post: 11-09-2014, 11:45 AM
  4. Replies: 2
    Last Post: 12-17-2013, 08:21 AM
  5. [SOLVED] Excel 2010 Identifying data changed in cells and Identifying the changed rows
    By SandyLake in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 01:12 AM
  6. help with collect data
    By 400396 in forum Excel General
    Replies: 2
    Last Post: 07-28-2012, 11:22 AM
  7. Collect data from other tab
    By saslotteroy in forum Excel General
    Replies: 3
    Last Post: 10-16-2011, 04:25 PM

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