Hi,
I have an Excel Workbook with several sheets filled with products from different suppliers.
In Sheet A I have all products with names only from all suppliers with all products in Stock. Colum A is the running number of the product 1 - 50230
Sheet A:
running number | product number | supplier ID | product name | stock value
I can select only ONE supplier via a macro - this Macro filters for products of this supplier (based on supplier ID) where the stock value is >0
All other products will be hidden.
In Sheet B are way more product information stored.
Running number | product code | supplier ID | supplier name | product name | product description | Purchase price | margin | ...| ... | ... | ... until column AW
I would like to create a Macro which hides all rows between row 3 (above are headers) and 60.000 in Sheet B where the running number is not equal to the ones shown in Sheet A column A (starting from row 2)
I hope I described the problem in a way that you can understand.
Thanks in advance
Thomas
I have an Excel Workbook with several sheets filled with products from different suppliers.
In Sheet A I have all products with names only from all suppliers with all products in Stock. Colum A is the running number of the product 1 - 50230
Sheet A:
running number | product number | supplier ID | product name | stock value
I can select only ONE supplier via a macro - this Macro filters for products of this supplier (based on supplier ID) where the stock value is >0
All other products will be hidden.
In Sheet B are way more product information stored.
Running number | product code | supplier ID | supplier name | product name | product description | Purchase price | margin | ...| ... | ... | ... until column AW
I would like to create a Macro which hides all rows between row 3 (above are headers) and 60.000 in Sheet B where the running number is not equal to the ones shown in Sheet A column A (starting from row 2)
I hope I described the problem in a way that you can understand.
Thanks in advance
Thomas