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
Bookmarks