Dear Excel Wizards,
I am using Excel to create Proposals/Sales Orders/Service Orders/etc.
I input all necessary information on the INFO Sheet, and it will auto populate and calculate all other sheets which are templates with their appropriate formulas. All is working well, and I have allotted 10 Lines to input different Line Items to display. I have created an overcomplicated VBA to auto-hide rows in my template sheets dependent upon if there is a QTY shown in my Line Items.
THE PROBLEM
The workbook works fantastically and other departments are requesting the same sheet. This is a problem as I would need to create this VBA for hundreds of new template sheets and have no desire to re-input the code for all sheets.
THE CODE
CONCLUSIONPlease Login or Register to view this content.
Please review and let me know if there is a simpler way to go about hiding the rows for each sheet and new sheets to be added.
Note: I am rather new and self taught to Excel Macros and suspect I have approached this completely backwards.
Any help is much appreciated!
Bookmarks