automatically copying data to history...

Hey everyone,

I have been working on a project recently and im at a loss of how I should do this. I will try and describe what I am trying to do: I have 2 columns which list part number and the price for that (both of which have been gathered from a number of other excel documents and programs). Once a year, all the information gets updated (a simple copy and paste process), and then the year is canged (which you will be able to see on the front page).

Now to keep a record of the history, one would normally have to copy and paste the old data and Special Paste it into the clolumns next to the current (as seen on page 2), what i am trying to do is make it so that when the date gets changed/or the data gets updated, it automatically copies the info from that year and adds it to the end of the history table (which would be page page 3, but i had to remove it so the file would fit, but page 3 is essentially just a copy of the 2003-2006 data in a differnt page)...in other words, when the data gets changed to the 2008 data, the current 2007 data will be copied, and special pasted (dont want to use the formulas, just the numbers in the table) into the history.

I have been informed that I may have to use VB, which I have never used befor in my life, but if it can be done without, that is just fine by me.

I hope that this wasnt to confusing for eveyone to understand, and I will be attaching a sample so you can see how it works. (It may get rid of the values under 2007 std, just assume that they are filled with $ amounts)

Thanks in advance to everyone, and sorry for such a long post.

-Ben-

oh, and if anyone needs any more information or have any questions, dont hesitate to ask, I know my post was really confusing.

Anyone?
Any help would be really really apreciated.