Easiest way would be to copy the worksheet, then sort the new one by "option
column" and then delete the rows you don't want.

"DDawson" wrote in message
...
I have a table with the headings; job number, title, and option (A/E).
I want to pull in the jobs which are only option A into a new worksheet
table.

So my first table may have

Job No Title Option
1234 Site 01 A
2345 Site 02 E
3456 Site 03 E
4567 Site 04 A

My new table should only have:

Job No
1234
4567

Kind regards
Dylan