Inventory Reorder question

[zendog1960]

In worksheet named "Inventory Data" I have column A with the heading "Item Code" in A1. In G1 my column heading is "No Order". The value in the "No Order" column is either an "a" or blank.

On sheet "Reorder Form" Column A is again "Item Code" and there several other columns.

Question:

How can I create a list in Column A of the 'Reorder Form' where only the 'Item codes' from the 'Inventory Data' sheet with blank values in Column 'No Order'? I have done this before but it was years ago and I forgot.

I would prefer to do this via VBA but if there is a better way I am open to suggestions.

I would post some data but my Excel Jeanie is popping up errors. any an all help would greatly be appreciated!

Zen

 

[RSXchin]

you could use filters.