Product Comparison

Excel file would be a good start

Kind regards
Leo

Originally Posted by LeoTaxi

Excel file would be a good start

Kind regards
Leo

Hi Leo,

Thanks for the reply. I will make a smaller version of my file and upload it, as right now the file is over 80MB because of the hundreds of images it has inserted as comments.

Will be up this night. Thanks again.

Hi again,

I did a smaller version of my file and using only 2 company products as I have not filled in the third one.

Hope this gives a better idea of what I'm trying to, I left the template of the User Form I posted on the first post.

Thanks

PS: There's a macro intended to put images as comments when you click the button, that one works perfect.

Anyone? I'm very stuck I don't know how to even start. A little guide on what codes to look or which way I should start going would be very helpful to me.

The main goal of this is to compare the same product of 3 companies to know who has the best price.

I'm maybe thinking in just leaving the User Form to have the options to entry data of the characteristics of the products and when click "Search", have the results down in a spreadsheet by company, would this be easier?

Regards,

I made something, i can not test on Mac so you have to find out,

i rebuild the sheet, only 1 column for price, 1 column for Item and 1 column for Company
the button show form opens the userform and the 9 comboboxes get populated with unique values of each column
the search button on the userform populate the listbox with items that match all criteria from comboboxes
by choosing 1 item from the listbox, the textboxes get populated.

Kind regards
Leo

I'm so mad at myself for not having Windows, does not work on Mac but I will find a Computer to try it. Will comment back.

Thanks a lot again, really helps me out.

Wow, that is perfect. I don't know what you did there but for sure need to learn to!

That's amazing, thanks a lot.