You're welcome! And if you turn on the macro recorder while filtering,
you'll get most of the code you need to run the filter automatically.

Raul wrote:
Thanks, this helps me out too.

Raul

-----Original Message-----
You can use an Advanced Filter to extract the fields to

another

worksheet. Set up a criteria range, with headings that

match the

headings in your table, e.g.:

user
Smith
Ami

There are instructions here for filtering to another

worksheet:



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

Meme wrote:

I have a table in sheet A with fields
like "plan","user","date","amt". Now I need copy this
table to sheet B with only 2 fields, they'
re "user","date". Plus I want to only copy the records
with user name "Smith" and "Ami". Can anyone tell me

how

should I program this in my VB code ? Appreciate any
help.


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