Merging data

Posted on 2007-10-03
Last Modified: 2010-04-30
I have a data spreadsheet I put together on a daily basis that tracks stock ranks each day. Each day I copy and paste stock ranks from a website I subscribe to. Each stock is issued a grade each day by this website. The webbsite allows me to save the stocks I'm tracking on the website itself in a Portfolio folder. However, but will only let me see the previous 5 days worth of grades that were given. I would like to see the grades given for longer than that so this is why I copy and paste the grades each day onto the spreadsheet. SInce only five days are provided, I need to find a way to combine the old data I have on the spreadsheet with the new data I'm pasting in because right nowit involves alot of copying and pasting and deleting of rows.

What's the best way to merge the data without   deleting what I have previous data?
Question by:kamunya
    1 Comment
    LVL 14

    Accepted Solution

    In that you are running a cumulative table for the stock ranks, I believe that this could be done much easier into Access.  You will then have the ability to an almost unlimited number of days.
    I need more information to assist.  
    If you want to keep your current spreadsheet, you can create code to go the last entry and add the next set of data.  This can also be done via a macro.  Tools, Macro, Record a new macro.  To locate the first empty row do End & down, the down again.  This will be where you paste your new data.  You will probably need to very that there are no duplicate entries within your sheet.  This should not be a problem.  

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now