You need to insert a row at the top and give it labelsuse
datafilterautofilterfilter as desired and then copy the visible cells.
Record a macro while you do this to get the idea of how to modify to suit
variable needs.

--
Don Guillett
SalesAid Software

"excelmac" wrote in message
...
HI,
i'm very new here. I hope someone can advise me on how to get it
done.

Basically for example, I have a excel worksheet 1 with all my inventory
list;stock code, pricing etc... How can I actually find a particular
stock code in column 3... and find all the rows with the paticular
stock code and copy to worksheet 2 or another excel files. I think I
need to write VBA or marcos right.. which I have no idea on how to do
it.

Below I have attach a sample excel file of my inventory list

I hope someone can advise me on this etc....

Thanks in advance.


Regards
Newbie

Attachment filename: needhelp.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=382451
---
Message posted from http://www.ExcelForum.com/