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