lundi 8 janvier 2018

VBA Macro for HIDE ROWS in EXCEL by CONDITION

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