So i am building a pricing sheet through excel and have about 1,000 rows of line items.
I need to allow the user to check the boxes they want to see and then display only those boxes via the use of a form control button (or whatever is better here).
The end result is to get 20-30 items from this master list to display for a price sheet printout for a specific vendor.
I am not familiar with VBA code, but have enough experience with other areas where I can execute and edit a code if given a starting point and simple instructions.
I have inserted checkboxes into the first column, and set the linked cells to display true false in the 2nd column. all i need is to write a macro to hide if false (checkbox unchecked) in column 2 and get it to process the macro in under 12 minutes.
Any help or suggestions here are greatly appreciated!! enter image description here
Aucun commentaire:
Enregistrer un commentaire