data sorting

[Jearnizck]

Hi,

Anyone here can help me to sort/filter data entry base on category to another sheet.

I have attached sample template to easily understand what I mean.

data sorting.xlsx

thanks.

Let me know if can be done by vba macro or just excel formula.

[Jearnizck]

Hey guys,

Anyone can help how to apply the advanced filter using vb macro for this case?

I know how to use the advanced filter from wizard but need some automation.

Thanks.