How do I create a pick list from a master list in EXCEL

  • Thread starter Thread starter ReginaC
  • Start date Start date
R

ReginaC

Looking for a way to create a pick list from a master
inventory list. I want to be able to print only the items
that have been notated without having to select as I go.
Is there a report or filter that will allow me to do this?

Any help would be greatly appreciated.
 
You can create a column and notate each record with the
same identifier (say the letter "P") and then apply an
Autofilter (Data > Filter > AutoFilter). Click on the drop-
down arrow for that column and select "P".

HTH
Jason
Atlanta, GA
 

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

Copying List box values/selection to a database of sorts 2
Dependent list in excel to create validation 1
Pick List Problem 7
Other sheets to pick data from master sheet 1
pick multiple items in data validation 2
Problem with Pick List associated cell 2
Vlookup with a pick list for tables 1
Picking a name from a list 2

Back
Top