I see where some users have asked about a single check box to hide/unhide multiple rows. I have played a bit with this but I need something a little different.
I have a spreadsheet where on one tab (Bid Request Prices) it has all the data and formulas to set pricing for 102 different products. This information feeds another tab (2016 Bid Pricing). I would like to add a check box for each item on the Bid Request Prices tab that would hide/unhide the corresponding line on the 2016 Bid Pricing tab so that when we print or create a .pdf only the check items are on the list.
I am a newb to a lot of this so if this is something simple that I should know I apologize now. Learning on the fly here. Thanks!
Will I have to create a macro for each individual check box or is there a more dynamic code for this? In either case if you could help me with this I would appreciate your help!
Bookmarks