Filter and copy data

[tharindudk]

Hi,

I have a excell sheet with some data.

I want to filter the daca and copy it to Sheet 2,

For example

In sheet 2 I have
A1 = Nike
B1 = Puma


In sheet 1 I have lots of Nike and Puma products.

I want to make a macro to fliter sheet 1 so that Column A in sheet 1 get filtered by contains Puma. than select all filtered result, copy it and paste transpose in Sheet 2 row B next to Puma.

I have more products, this is jsust to explain what i need to do.

Any help is appriciated.

[xladept]

Hi,

Here's a beginning:

Please Login or Register  to view this content.

[BS Singh]

How they are categorized ....in column A (Sheet 1) to identify which product is for which brand?

Attach a sample file..please...

Regards,
BS

[tharindudk]

Hi BS,

I have attached the template file.
So prety much form Sheet 1 (MAINT) I wanto filter all products with name Puma and copy the filtered data and paset it in Sheet2, row 2 next to Puma, so paste spacial, transform.

I have created a macro using record function

Please Login or Register  to view this content.

This is what I want to do but I want to automaticaly filter copy everything using a macro like this.
Thanks

[xladept]

Hi,

Try this:Thar.xlsm

[tharindudk]

Hi xladept

This is exactly what I want to do. However, In my original document, in Sheet 1 there are some other information in other columns D E F etc).
Does this affect when copying the filtered data? t doesnt work as good when I have values in columns other than A.

Thankyou for your help


PS: the problem is If I put "Pants - Nike" or the product after some leters, it doesnt get filtered. How do I fix this?

[xladept]

Hi Thar,

This seems to work:

Please Login or Register  to view this content.

[tharindudk]

Hi, unfortunately when I copy this, it is still the same

[xladept]

Hi Thar,

Thanks for the rep!

One more wildcard - try it now

Please Login or Register  to view this content.

[tharindudk]

Hi,

Thankyou for your help. It works fine now

[xladept]

You're welcome!