Dynamic row selection based on condition

HI everyone,

I just got started with VBA and I have a challenging macro to program. I would appreciate if you could help me or give me a hint how to do the following.

I have a table that looks like this:

prices quantities Company
1 5 ABC Company
3 45 ABC Company
4 6 ABC Company
6 3 CDF Company
34 2 GHI Company
43 4 GHI Company

I would like to copy all rows (A1:C3) for ABC company in one worksheet, all rows for CDF in another worksheet and all rows for GHI company in a third worksheet. Here is the catch. Every week this table is updated and the names and frequence of the company change. For example in week two there is only one row for ABC company, no CDF company and 5 rows for GHI company. Is there any chance to code that in VBA?

I started and I created the following:

Please Login or Register  to view this content.

However this setup far from complete and it would ignore the last row of every company.

Any ideas?

Thanks a lot!

Hello Hornet222,

This macro will either create a new sheet with the company's name or append that company's data to the existing sheet. The macro assumes the company's name is in column "C" and the first row on the main sheet contains the headers.

Please Login or Register  to view this content.