using selected data from a pivot table to populate new list
I have a pivot table list of chemicals compiled from various sheets of data.
I would like to select certain chemicals from the list so that they pupulate a new list that is linked to another part of the sheet. The abbreviated list is to be linked to a specially formatted page that can be used to print data on each of the selected chemicals. ideally I would like to have a check box next to each chemical in the parent pivot table so that when checked, the selected chemical appears in the abbreviated list. I would like the default position to be that with all the check boxes ticked so I can deselect just those chemicals i am not interested in printing Can anybody help? |
All times are GMT +1. The time now is 02:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com