using selected data from a pivot table to populate new list

R

Roger on Excel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top