I have a spreadsheet with a drop down combo box with months which give the values by each individual name by a HLOOKUP. I am stuck on the next step, I have created a dropdown List with everyone’s name and when I pick the name I would like the values to be highlighted, could anyone tell me how I could do this?
I have put an example below
And is there anyway I could have the highest values to the lowest values appear in order instead of the names, each time i change the month?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
<o></o>(combo box) Month (All Months) Dropdown List (all names)
<o> </o>
No jobs No Goods No Items
Jane 1 Jane 4 Jane 4
Fred 3 Fred 5 Fred 5
Sarah 2 Sarah 5 Sarah 6
Mark 1 Mark 2 Mark 7
Would be very grateful if someone could help me out?
I have put an example below
And is there anyway I could have the highest values to the lowest values appear in order instead of the names, each time i change the month?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o><o
></o>(combo box) Month (All Months) Dropdown List (all names) <o
> </o>No jobs No Goods No Items
Jane 1 Jane 4 Jane 4
Fred 3 Fred 5 Fred 5
Sarah 2 Sarah 5 Sarah 6
Mark 1 Mark 2 Mark 7
Would be very grateful if someone could help me out?
