It needs to scan and autoselect the lowest vendor for all items

**suresh mongam** · 05-29-2012, 04:58 AM

Hi frnds,

I am new to excel coding,

My doubt is when i click "Master List" tab it needs to scan and autoselect the lowest vendor for all items dynamically. please help me frnds.

Thanks in advance.

**arlu1201** · 05-29-2012, 07:24 AM

When you say autoselect, do you mean highlight thru color?

The lowest vendor should be for all the columns? Do you mean the vendor that has the lowest values in all columns should be highlighted?

**suresh mongam** · 05-29-2012, 07:37 AM

Hi arlu1201,

yes, all columns should be highlighted and i add any row to the "Master List" tab it is also highlighted dynamically. please help me

Thanks in advance.

**arlu1201** · 05-29-2012, 07:47 AM

So if i understand your question correctly, as per your sample sheet, for row 13, the macro needs to highlight Vendor3 and for row 14, vendor1 ,etc right?

**suresh mongam** · 05-29-2012, 07:56 AM

Hi arlu1201,

yes, i want auto select the lowest vendor for all items at a time dynamically. if i click "Sheet1" tab to "Master List" tab that should be displayed with minimum cost vendor and it should be highlighted .

Thanks in advance.

**suresh mongam** · 05-30-2012, 02:34 AM

Hi frnds,

we don't know any idea about that question,so many developers are watched that question but they didn't give any solution.

please help me frnds.....

Thanks in advance