Hi
Please find a solution attached. I notice that you are using Office for Mac so I am hoping this solution will work as it is based on Office for Windows.
Here's how it works:
1. With your worksheet open double-click in Column C each row you want to include in your printed list. This will put a "Y" in each cell you double-click in.
2. Then enter Ctrl+q. This will filter your list based on your selections and you can print your filtered list.
The code for the double-click is sitting behind the worksheet. To view this code simply right-click on the tab for Sheet 1 and select view source.
Then there is a macro attached to this workbook that does the filtering for you based on your selections. It will run for up to 1000 rows. If you need more rows then just open the macro and change "1000" to a number that suits your requirements.
When you want to do a separate list then simply turn off the filter manually and follow the instructions above.
Good luck.
Tony(OTPM)
|