VBA: Generate listing based on another worksheet in the same workb
Hi,
I'm trying to automate some processes in Excel. Scenario as followed: I
have a list of equipment in Sheet1. I would like to create a button in
Sheet2 that, when clicked, would list me all the equipment for type = "ws"
and "pc" for example. Sheet2 would only list selected column "desc, type and
name" and sort by "name". List in Sheet1 will grow.
Sheet1:
A B C D
1 desc type name $
2 dell pc pc1 10
3 hp ws ws2 40
4 sun ws ws1 15
5 hp printer prt1 8
Sheet2:
A B C
1 desc type name
2 dell pc pc1
3 sun ws ws1
4 hp ws ws2
Anyone can help me? Any pointer?
Thank you,
choo
|