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!


    forum.ozgrid.com/index.php?attachment/33086/

    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,
    Zenarte