Results 1 to 2 of 2

Query Data in hidden rows/columns with Query Box

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Query Data in hidden rows/columns with Query Box

    Hello all,

    New member to the forum, and first post out of necessity.

    First, let me start by saying that I am a complete neophyte when it comes to excel programming or advanced functions. I know how to put information into a worksheet, and some basic SUM functions, but thats about it.

    What I need is someones help in creating a workbook that, when opened, displays a box which allows a user to input a value which if found in any rows in Column A, returns a value from the corresponding row in Column B, and vice versa. I would like the data in both columns to be hidden and protected, and the user should only see the box.

    I really have no idea where to start, or even if I've worded my question properly, and if I'm out of line in any way, please let me know.

    Also, I would've run a search before asking, but I have no idea what to search for

    Kind Regards,

    VincetOmnia
    Last edited by VincetOmnia; 10-12-2009 at 11:08 PM. Reason: change thread title to something more appropriate

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1