Re: Automatic Hyperlink
Thanks a lot for your help SMC, it works perfectly!
Re: Automatic Hyperlink
Thanks a lot for your help SMC, it works perfectly!
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 designed this report, where I use a typing base, and then I save the other sheets as a backup on the same file. My doubt is, if is there any way to automatically link the numbers that are listed on the menu, with their correspondent sheets' numbers.
I attached a sloppy example, just to give you an idea of what I'm trying to do. Thanks a bunch!
forum.ozgrid.com/index.php?attachment/33084/
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