You can use an Advanced Filter to extract data from a table. There are
instructions in Excel's Help, and he

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

GrantM wrote:
I need to paste a selection of data from a larger table on another worksheet,
subject to preset requirements.

I know how to select the required data field, but I don't know if there is a
way to paste this data onto a new worksheet in its sub-table form?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html