How do I conditionally build worksheet from existing worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to build an inventory worksheet that contains only the items whose
amount on hand is less than a specified number. I know the answer is in the
Help somewhere but I haven't had any success in finding it.
 
Look in the menu at Data=>Filter =>AutoFilter

Use a custom filter on the quantity column and set up your criteria.
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
matching data on worksheet 1
Formatting issue 0
View Conditional Formats on worksheet? 4
comparing from two worksheets 4
Flops' new build 5
VBA / Macro Help Please 2
Changing multiple worksheet references in formulae 2

Back
Top