|
Your best bet is to move to a database. MS Access is good if you are really only good at Windows type software.
There are a few free/share ware database applications, mySQL and Postgres are two off the top of my head. Oracle even offers there database software free...for testing and development only though... so read into that as much as you want. As long as you don't try to market it (or if your not a big company) you can get away with it. You might want to even think about MS SQL. It is really easy to use and has a lot of function to it. You just have to think about if it is more than what you really need to pay for. However though any database that you do use you can always import the information back into Excel. Too you can create sql scripts to import your data in (add vendors ect ect) and once you have the scripts created...you'll never have to copy and paste again.
If you have questions I'd be happy to help and point you in a better direction, I am a DBA so I know a few things :P
|