Hi,

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.
Thanks

Meme

Have you tried using the advanced filter function? You
could use the advanced filter to return only the desired
records and then copy the results to sheet B.

The advanced filter code would be:

Range("B3:E9").AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Range( _
"H3:H5"), CopyToRange:=Range("J3:K3"),
Unique:=False

Hope this helps,
Raul


-----Original Message-----
Hi,

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.
Thanks

Meme
.

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

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

.

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