Results 1 to 3 of 3

Thread: VBA or MACRO - PLease PLEASE HELP ME

  1. #1

    VBA or MACRO - PLease PLEASE HELP ME



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    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.
    Regards,
    Zack Barresse

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Attach a sample workbook with some dummy data
    Hope that helps

    Roy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •