+ Reply to Thread
Results 1 to 2 of 2

Searching and displaying multiple products per customer

  1. #1
    Registered User
    Join Date
    09-12-2011
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    7

    Searching and displaying multiple products per customer

    I have a file with multiple worksheets.
    In the first worksheet "Klanten" i have made a table with two columns, the first column gives the clientnumber and the second the attached product.

    I have used the following code to display all the products linked to a client number.

    =IF($D$17="";"";IF(ISNUMBER(SMALL(IF($A$1:$C$999=$D$17;ROW($A$1:$C$999));ROW()-ROW($D$18)+1));INDIRECT(ADDRESS(SMALL(IF($A$1:$C$999=$D$17;ROW($A$1:$C$999));ROW()-ROW($D$18)+1);COLUMN($B$1)));""))

    This code works and displays the products per client.
    Now I want to be able to work with multiple sheets (one sheet per client) and still search and display products per client (see worksheet 001,002,003 etc)
    However this code does not work when it is linked from another worksheet.

    I hope someone knows how to get the products per client to work on the seperate worksheets.

    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-12-2011
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Searching and displaying multiple products per customer

    To give some more insight -->

    I am creating one sheet per customer, and would likte to get the above formula to work on these sheets. When this formula is placed on another worksheet to work with sheet "klanten" it does not work and takes the column of the sheet were it is placed in stead of the sheet "klanten".

    Does anybody have a code that does a similar action but does work on multiple sheets?

+ 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