Posted on 2007-10-03
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?