Limiting history backed up to 4 years.

Hello everyone, I have been working on this project for quite a bit, and I thought I was done, however I would like to make a bit of a revision, so if anyone could help that would be wonderful.

Currently, when the macro is run, it copies and special pastes the history to the side |2000|2001|2002|2003|... and so on and so on. This after a while, will cause the workbook to grow to a considerable size therefor, If possible, i would like to limit it to 4 years. The easiest way would probably be to put it in the form |2003|2002|2001|2000| and when the year gets updated simply drop of the last year |2004|2003|2002|2001|.

Hopefully this makes sense. The current code can be seen below

Please Login or Register  to view this content.

I have also included a zipped file of what one of the sheets would look like to give you a visual reference (obviously this is missing the other 30 pages as well as the macro, so if anyone would like me to attach a more complete version, I would be happy to.

Hopefully someone could help me out.
Any help is really appreciated.

Thanks
-Ben-

Hmmm, for some reason it is not limiting the years to only 4. It just keeps adding on. So its almost there.

Thanks a bunch.

-Ben-