Search results

Hi everyone Hopefully someone has a better idea on how to handle the following: I have a sheet with scores rated by different users and it has 6 columns of demographic data. On the other hand I have 6 comboboxes that define the 6 criteria, only that in any of them there's also the option to...

I'll open a new topic to avoid confusion

OK, yes all named ranges stayed the same. It all references perfectly and the code works. And it's working ok now, they are not getting smaller for the moment. I have a new question, maybe you have a better solution that what I'm thinking: now that I have all filters working, I have a separate...

Autosize is False. It happens only sometimes, other times it works perfectly. I can't recreate it. I just opened it and it works fine. It's weird. I did the following, let me know if I did anything wrong: I copied both sheets from your example into a new file, then copied the code from...

Hi Narayan, I run into an issue while using the boxes. Each time I select a value, comboboxes get smaller and smaller in size. Do you know how to fix this?

Thanks, it works perfectly!

Hi everyone! Is anyone aware of a way of averaging while using both vertical and horizontal criterias? For example, one criteria might be in A:A, while the next in D1:D20. Thanks!

Just tried it and it's excellent. I truly can't thank you enough for your help with this. I'll let you know if I come across any issue. THANKS!

Exactly! Thank you again this is really helpful, I'll check tomorrow or over the weekend.

Exactly! Thank you again this is really helpful, I'll check tomorrow or over the weekend.

It should be for all of them, and once you select "All" on one box, the following box should skip that criteria and show all options according the box that preceded the "All". For example, if you chose "Marketing" on box 2, and "All" in the Countries box, on the cities it should display all...

Just tried it, it's perfect now!

Hi Narayank, somehow I cannot download the file, would you be so kind of posting a new link? Thank you Also, let me know if you were able to see the "All" selection that we mentioned before

Thank you! I'll check now and let you know

Tried to fix the NY issue over the weekend but had no luck

Hi Narayank, been over the file and I have 2 questions: 1) On the "City" combobox, it always includes NY as an option, regardless the country you selected previously. E.g. Brazil --> NY. 2) What if I wanted that every combobox had the option to also select "All", meaning that for example...

I just opened it and I think it's PERFECT. I truly appreciate your help. I'll let you know if I have any doubts. Thanks again

I also saw a combination of VBA and Pivot tables doing some research online

Sounds perfect thank you!

Just created this example: https://docs.google.com/open?id=0B9nov_b3A5SvOE5LVmZXb0JsSzg keep in mind there's less data (about 3K rows) Thanks a lot

I've just noticed by recording that VBA does the sorting and removing duplicates really fast, but how could I make it to create a list depending on a criteria?

It's exactly what Narayank is saying. I've checked your file Suresh and it's something like that, only that each option you select will load a large list on the following box (instead of 1 option). Will this technique be able to deal with the large data set? I'm using combo boxes because I...

Hi everyone Here's an issue I've always had and was never able to solve completely, probably quite simple for someone out there. I'm attaching an example file. I've got 6 comboboxes where the user can input 6 different variables. And there's a list with the data (8000 rows long) with the 6...

Thanks Faseeh, it works perfectly. Is there no way of doing the same with a Listbox ActiveX? That fill ranges are dynamic?

Also, I've noticed that it works OK when using a Form Control ListBox, but it fails on the ActiveX control