I am a VB/AX newbie. I can record macros but that is it. Please be gentle... lol. I am a bit frustrated and have wasted a good amount of time trying to figure this out.
I have a two page workbook called 'WorkshopChecklist.xlsm'
Sheet 1 = Checklist
Sheet 2 = Printout
On Sheet 1 there is a simple list of activities, a user would check the boxes for the activities they plan to perform. This check box results in a 'yes/no' result in Column 1 of Sheet 2. (this is complete and works)
There is a specific format to the print area on Sheet 2 that needs to maintained so simply printing the 'yes' rows will not work. (formats are done and set)
The following I cannot figure out...
I need to filter the data in sheet 2 for 'yes' results, then print sheet 2.
I would like the button on Sheet 1 as I would like to protect and hide sheet 2.
Thank you in advance for your help!
-Nash
Bookmarks