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.

Solved: Add Search Button In Excel 2007

Discussion in 'Business Applications' started by MRKHAN, Apr 30, 2015.

Thread Status:
Not open for further replies.
  1. MRKHAN

    MRKHAN Thread Starter

    Joined:
    Apr 30, 2015
    Messages:
    3
    Hello Everyone,

    I'm new to this forum. I'm trying to add search button in my excel sheet to find the data from database.
    Eg. There are 10 stores and am looking for a particular product I just need to enter the Unique Code and click on Search and it will provide the Store Name which has it along with Quantity. If more than one store has the same product then all stores names should appear with quantity.

    I have attached sample file. Thanks in advance!
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi, welcome to the forum.
    Have you tried recording a macro? You can then edit it if needs more functionality and the either add it to the QAT bar or assign the macro to button you can place on that particular sheet.

    BTW you could also use AutoFilter
     
  3. MRKHAN

    MRKHAN Thread Starter

    Joined:
    Apr 30, 2015
    Messages:
    3
    Thanks. I found out the way.
     
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...
Similar Threads - Solved Search Button
  1. atrue502
    Replies:
    3
    Views:
    755
Thread Status:
Not open for further replies.

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

  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