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
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