I'm working on a spreadsheet that will generate a reorder form when cells
indicate when inventory is low

Hi JWP,

Look at using the AdvancedFilter feature.

To extract filtered data to another sheet, invoke the filter from the
destination sheet.

If you are not familiar with this feature, see Debra Dalgleish;s tutorial
at:

http://www.contextures.com/xladvfilter01.html

If you want to use VBA, turn on the macro recorder while performing the
filter operation manually. The resultant code can then be edited to render
it usable for the general situation.

If you need help with such editing, post back.


---
Regards,
Norman



"jwpmann" wrote in message
...
I'm working on a spreadsheet that will generate a reorder form when cells
indicate when inventory is low