I am attempting to revamp complex and archaic Excel spreadsheets used for quarterly reporting. Individual departments supply some input which "rolls up" to the Strategic Planning Department for more manipulation.

To promote efficiency and reduce the chance of input errors, I want to create input forms and have the data "transferred" to an Excel sheet or Access database. Further machinations are required (currently in Excel and summarized)

I can import and extract data using Access and know nothing about Performance Point other than cursory information on YouTube.

Suggestions, Please,

Zippy