We help IT Professionals succeed at work.

Merging data

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?
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.