Vba code for sumproduct w/ multiple worksheets

[nataliarizzatti]

Hi,

I have one spreadsheet with my product codes and another with my inventory. The code goes... color, finish, width, etc..
I could make a sumprod to check availability of product however the variables could change. Sometimes the sales people need to know the availability only of a certain color but sometimes they might need to know the availability of a specific product (color, finish, width..). My goal is to have a input w/ dropdown lists where they can either input the whole product code or only some variables.

It is almost like comparing two pivot tables.

Any ideas in VBA?

Thanks,

[GeneralDisarray]

0_o

can you post an example?

[Miraun]

Why VBA and not just some conditional formatting/expressions. Sounds like you just need a current inventory based on a couple varying values.

Additionally, seeing what kind of data and structure we're working with through an example workbook would better help us understand the request. Of course, any confidential information should be masked or removed.

[nataliarizzatti]

I made a example sheet to help you understand the issue. The problem with using formulas is that it will get huge with so many variables. Besides I want to be able to check only color for instance and leave the other variables blank and still get a availability.

Thanks a lot for you attention!!!