MS Excel Data Quality Checking

I am working with a very large spreadsheet that is updated monthly. The spreadsheet consists of multiple tabs with many formulas summarizing project data in several different ways.  Each month the report is updated with the new raw data and new columns wiht formulas need to be added for the new month.  Each month there can occasionally be errors in not updating some of the several formulas and I am looking for an efficient and reliable way of data checking the spreadsheet. Also several people use this spreadsheet throughout the company to also add information into the document. any ideas?
rexley11Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
rexley,

With seeing a sample of what you are trying to do, it is very difficult to say.  In any event, a complete solution for this will likely far exceed the scope of a typical EE question, but perhaps we could narrow in on a particular aspect of your problem.

Patrick
0
DaveCommented:
Take a look at my free mapping utility, Mappit! at http://www.experts-exchange.com/A_2613.html

It is designed to pick up inconsistencies in spreadsheets, ie
  • changes in formulae accross rows/columns
  • hard coded numbers amongst formulae
  • linked cells etc
Cheers
Dave
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rexley11Author Commented:
The answer to the question was as helpful as it could be with the information I had given.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Project Management

From novice to tech pro — start learning today.