Posts by Zenarte

    Re: Replace multiple words in excel

    Hello, I tried to create something to assist you. I believe that it doesn't have to be so bureaucratic as in the example attached to this post, but it doesn't let to be a solution anyway.

    03 Sheets, being:

    - Base: Where you register the codes, descriptions and prices;
    - Main List: Where you add a couple of columns (Description / Price), with a VLOOKUP formula (linked to each code on the base, which provides other info);
    - Total: Where you can have a total per worker, through the SumIf formula.

    I hope that this will be able to assist you on your work. Cheers!

    Hello, I need some help with this matter, and I'd like to know if someone could please give me some assistance. Here's the situation (ex):

    A B
    1 Whiskey Johnny Walker
    2 Vodka Smirnoff
    3 Whiskey Jack Daniel's

    I'd like to know if it's possible to filter through the ComboBoxA the list of values on Column A, and then use them as a reference for the results on ComboBoxB (Column B). Like, if I choose Whiskey, I only want Johnny Walker and Jack Daniel's as a result on the second ComboBox.

    And just to finish, I'd also like to know if it's possible to link the chosen option on the second ComboBox to a certain cell, so that way I could also apply a LookV on it.

    Thanks in advance,