Prev: Pivot Table Refresh not working properly
Next: Quarter Hour time conversions for timesheet
From: Graham on 8 Feb 2010 07:05
I have a combo box with 12 drop down lines representing January to December,I
also have about 15 peoples names in column1 that when January is selected
from the como ,all the corresponding values for January must populate in the
next row next to the corresponding name. eg,
I have a spreadsheet with all the necessary data in it.

Combo Drop down="January"
Column1 Colomn2
A2="John" 50
A3="Peter" 30
A4="Rose" 45
A5="Paul" 35
--
Eager to learn !
From: Eduardo on 8 Feb 2010 08:02
Hi,
See Debra web

http://www.contextures.com/xlDataVal02.html

if this helps please click yes thanks

"Graham" wrote:

> I have a combo box with 12 drop down lines representing January to December,I
> also have about 15 peoples names in column1 that when January is selected
> from the como ,all the corresponding values for January must populate in the
> next row next to the corresponding name. eg,
> I have a spreadsheet with all the necessary data in it.
>
> Combo Drop down="January"
> Column1 Colomn2
> A2="John" 50
> A3="Peter" 30
> A4="Rose" 45
> A5="Paul" 35
> --
> Eager to learn !
 | 
Pages: 1
Prev: Pivot Table Refresh not working properly
Next: Quarter Hour time conversions for timesheet