1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

how to hide/unhide rows based on the cell data

Discussion in 'Business Applications' started by joselica, Nov 4, 2017.

Thread Status:
Not open for further replies.
Advertisement
  1. joselica

    joselica Thread Starter

    Joined:
    Nov 4, 2017
    Messages:
    2
    Hello to evrebody,
    I have look into the answers and the solutions about "hide/unhide rows based on the cell data" but i am not abble to understand how its work and apply to my sheet.
    On theattached sheet i explain what im looking for.
    Pleaseo play it and hope to help me and give a solution please.
    Thanks in advance.
    Jose
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,552
    First Name:
    Hans
    To hide and show rows you will have to use a macro.
    No funcionará sin macro VBA
     
  3. joselica

    joselica Thread Starter

    Joined:
    Nov 4, 2017
    Messages:
    2
    Buenas tardes Hans,
    Gracias por tu tiempo.
    Ya me han dado la solución. Adjunto el documento con la solución que recibi con otra ayuda por si acaso alguien lo necesita.
    Sabia que debia de usar VBA pero no veia los pasos.
    Ahora me encuentro con un otro problema que vuelve loco....tengo un VLOOKUP que no me devuelve el precio del ultimo nombre de la lista desplegable...¿se te ocure algo?
    Saludos,
     

    Attached Files:

  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,552
    First Name:
    Hans
    Le echaré un vistazo y te aviso
     
  5. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,552
    First Name:
    Hans
    Fue simple, elk problema con VLOOKUP es que la lista de datos tiene que estar en orden alfabético
     

    Attached Files:

  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1198948

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice