create list from non-blank quantity

[gailana]

I have a workbook with a worksheetA quantity, part name, retail and
cost. It's quite lengthy and contains all the parts I might ever
order from all vendors. I want to create another worksheetB that can
look at A to see if the quantity is >0, then populate B with all the
info EXCEPT the retail cost.

But, I don't want the list on B to be populated with non-blank
values. The idea is to use worksheet B as an order list from my
vendor, which would be a much shorter list and would not have all the
blanks on it.

I would be so appreciative of any help! Thanks in advance.

 

[Pete_UK]

You could apply an autofilter to the quantity column of worksheetA -
select Custom | Is Greater Than | 0 (zero). Then highlight all the
visible data and headings in worksheetA and copy/paste them to
worksheetB.

Hope this helps.

Pete

 

[gailana]

Thanks for the help Pete. Now if I could just figure out how to make
filtering work. The help screens explain the concept, but they don't
explain how to accomplish the task. Nothing happens when I try to
make it work, so as usual am scrambling to find tutorials on the web.

Thanks again!

Gail

 

[Pete_UK]

Highlight the column which contains the quantity values by clicking on
the Identifier at the top of the column, then click Data | Filter |
Autofilter (check). You will now see a small arrow in the top cell of
this column - click on it and you will get a pull-down list which will
show:

All
Top 10
Custom
Then a list of values in your column, and sometimes:
Errors, like #N/A, #VALUE
Blanks
Non Blanks

I advised you in my earlier posting to select Custom, which will bring
up a dialogue box which allows you to specify more things than just
the drop-down list.

Hope this helps.

Pete