Developing GUI for excel spreadsheet

[adfo]

My colleague has created a matrix for construction site in excel spread sheet. The matrix will be updated on daily basis during the inspection activities. The matrix contains lots of information that will be difficult to follow. I was asked to create a user interface that allows data entry of new records, edit existing records and generating customized reports.

As you see in the attached template layout, the majority of the GUI will mostly consist of text fields with some use of check boxes and drop down menus. It should not be that complex with respect to the overall approach. Due to the large amount of inputs (just scroll across), I envision split the data into segments and use the multipage control in the user form. Each segment of data will be placed individual tab in the user form (included). The suggested segments of input data are shown at the top of the table.

There are no queries to databases or complex calculations. It’s just data entry form to update the spreadsheet and generate customized reports such as recommendations for a selected area, of areas that need immediate actions, etc.

Do you think this can be accomplished using Excel or using VBA and reports can be generated using pivot tables? Or should this be better done with MS Access?

 

[vbajock]

I'd go the Excel route, I don't see where any advantage can be gained using Access, since all of that functionality is available via Excel VBA. You might want to look at this:

http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx