Not dynamic : Data ranges become redundant when new records are added, resulting in established formulae needing to be altered. Overlooking these errors can be embarrassing and downright expensive, especially if important decisions are being made based on the data.
You could make money doing something you love (or like [or maybe not so much but just really good at]). It's great to see a spreadsheet come together, and usually a lot better than what you originally envisioned. Especially when the dang thing works.
So you've got what it takes to develop spreadsheets that others would find useful. Now you're thinking about selling your spreadsheets to both help people and generate some additional income using your MS Excel or other spreadsheet development skills. Well, as you know, there are pros and cons to everything you do. Read on to find out what some of them are:
Today, there are a large number of options to choose from. The downside to upsizing your spreadsheet to a database system is that databases require fairly in-depth knowledge, especially with regard to extracting data in queries, form construction and reporting.
spreadsheet templates for tracking
examples of spreadsheet packages