+ Reply to Thread
Results 1 to 3 of 3

Help with Find across multiple sheets

  1. #1
    Registered User
    Join Date
    02-20-2011
    Location
    Varna
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help with Find across multiple sheets

    Hello to all,
    I've workbook with list of clients, containing multiple sheets. I want to find and print a list of clients, based on some conditions - in my case column ""Product"" & ""Type"".
    In the attached example:
    in sheet ""Search"", Green and Blue cells are the Criteria, in the table below i want to display the results - in this case all the clients with product ""trousers"" and type ""man"".
    Looked through VLOOKUP formula, but i think it can't result me all the cells for the client including firm, addres, person and so on.
    Should i use macro in this case?
    And the second question, if i don't have to use macro, how can i cleanup the workbook, because now there's left some code and even i haven't macros in the book, it asks me when i open it, to enable or disable macros...
    I appreciate any help,
    thank in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-30-2009
    Location
    Redmond, WA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Help with Find across multiple sheets

    VLOOKUP is limited in how you can use it, and for returning multiple cells the INDEX function will probably work much better for you. Learn about INDEX by watching this Office.com video:

    Video: INDEX function

    As for the warning messages you're getting about having macros in your workbook, yes you do have a couple of macros that you'll want to get rid of. They're in Sheet2 and Sheet12. Looks like someone started to write or record a macro and never got around to it (there's no code between the Sub and End Sub lines).

    In Excel, press Alt+F11 to open the Visual Basic Editor and in the left pane you'll see your workbook's name. Double-click Sheet2 and then delete the 3 macro lines and then do the same for Sheet12. That ought to clean things up and those warnings should go away.

  3. #3
    Registered User
    Join Date
    02-20-2011
    Location
    Varna
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help with Find across multiple sheets

    I'll look the index function and the macros.
    Thank you!

+ Reply to Thread

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