using selected data within a dropdown list 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 just 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.

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

Similar Threads

using selected data from a pivot table to populate new list 0
Storing data from pivot tables with adjacent entered data 0
Space at end of multi page list to accommodate new entries 1
Find function for a listbox table in a userform 1
Comments - populate using vlookup 2
synonyms - need help with vlookup 6
retrieving data from a table on a website 2
listbox -shows table of information - option to select and edit ro 2

Top