My goal is to create a report generator type formated table on a new sheet for the user, by automatically getting data from other screens, and then let the user filter and sort the results ... then print, save to file .... and finally clear the screen. All this with two Buttons, "Create Table" and "Clear Screen".
The previous screens that I need to use all tie together in a relational database format with the necessary common values etc. I am asking what you think the best way is to approach this design? Should it be cell driven or VBA driven? Or both? I have an existing screet that I call my Admin/Dashboard/Reports sheet ... I want to add a Button there to send the user to the sheet I have just described that I need to create. Has this wheel already been invented? Any ideas will be appreciated. Thanks.
The previous screens that I need to use all tie together in a relational database format with the necessary common values etc. I am asking what you think the best way is to approach this design? Should it be cell driven or VBA driven? Or both? I have an existing screet that I call my Admin/Dashboard/Reports sheet ... I want to add a Button there to send the user to the sheet I have just described that I need to create. Has this wheel already been invented? Any ideas will be appreciated. Thanks.