VBA or MACRO - PLease PLEASE HELP ME

Hello everyone

I am new to this forum so apologies if i am posting this at a wrong place. Really struggling on something in Excel.

I have got a spreadsheet in excel, for simplicity please see data below

A B C D E F
P Code P Name Descrption PW SL DG
1 ABCD DEFG XYZS Yes No Yes
2 LMNO PQRS EFGH No Yes No

What i want is, in the next worksheet, a button for column "PW", "SL" and "DG" (column D, E and F). I want my user to click on a button for instance "PW" and brings the data like below
P Code P Name Descrption 1 ABCD DEFG XYZS

It bring the above data because it has got "Yes" underneath "PW" which means it satisifies condition

Is there any way to achieve this please. ?

Thanks Harry

Hi there, welcome to the board!

I'd take a look at using Advanced Filter. If you want to to do this on a button, record your macro first, then assign it to a button. We can always help you clean it up if you post it. Remember with Advanced Filter you can copy to another sheet, but you want to start from the destination sheet when you start the process.

Attach a sample workbook with some dummy data