+ Reply to Thread
Results 1 to 5 of 5

How to keep the original data? Thanks

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Ct
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to keep the original data? Thanks

    Hi there,

    I got a column of data from external source. Every 10 minutes the data were automatically updated, but the old data were replaced by the new data. I wanted to keep all data I collected. I tried macro and Filter Advanced function, they both worked, but I needed to do it manually. I want the data be automatically copied to another place when the sheet is refreshed. Thanks a lot!

    harry

  2. #2
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: How to keep the original data? Thanks

    Hi HH

    Use track changes function

    Thanks
    A

  3. #3
    Registered User
    Join Date
    07-18-2013
    Location
    Ct
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to keep the original data? Thanks

    Thanks for your reply. Track changes is an interesting function. But this is not what I asked for. Please see below.

    I have a column of data. For example,

    B1: 100
    B2: 200
    B3: 60
    B4: 5

    When I press the refresh button, data will update to:

    B1: 10
    B2: 20
    B3: 6
    B4: 500

    I want to save all these data into other cells automatically like:

    E1: 100 F1: 10
    E2: 200 F2: 20
    E3: 60 F3: 6
    E4: 5 F4:500

    How can I achieve this? many thanks!

  4. #4
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: How to keep the original data? Thanks

    Hi harry,

    in that case ,you need to get help from VBA division of the forum.

    pls wait till someone revert on this.

    Thanks,
    A

  5. #5
    Registered User
    Join Date
    07-18-2013
    Location
    Ct
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to keep the original data? Thanks

    yes, VBA works. But I need to use hot key repeatedly to transfer new data. Is there any way to change a hot-key into an automated setting :-)? Thanks.

+ 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. Replies: 2
    Last Post: 07-18-2012, 09:11 AM
  2. Replies: 0
    Last Post: 01-14-2012, 02:13 AM
  3. Sorting, finding dulicates, moving one data element up, deleting original data
    By rickwtx in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2011, 07:32 PM
  4. keeping original sheets as original
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2008, 05:33 AM
  5. Replies: 1
    Last Post: 08-15-2005, 06:05 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