I need help on data manipulation...

[doms123]

Hi I am using Excel 2007 and I am having a problem on what formula to use on my scenario...

this the scenario i have 3 Sheets, first sheet is my input sheet

Excel Workbook
	A	B	C	D	E	F
1	*	*	*	*	*	*
2	*	poducts	*			*
3	*	*	*	*	*	*
4	*	date delivered	*	*	*	*
5	*	*	month	Date	Year	*
6	*	location of delivery	*			*
7	*	*	*	*	*	*
8	*	delivered by	*			*
9	*	*	*	*	*	*
10	*	sales	*			*
11	*	*	*	*	*	*
12	*	*	Encode		*	*
13	*	*	*	*	*	*
Input Sheet

then my second sheet is my masterlist sheet

Excel Workbook
	A	B	C	D	E	F	G
1	Products	Date Delivered			Location of Delivery	Delivered by	Sales
2		Month	Day	Year
3	Shoes1	June	8	2010	Area 1	Boy 7	1k
4	Shoes2	December	17	2010	Area 2	Boy 2	1k
5	Shoes3	August	7	2010	Area 3	Boy 3	1k
6	Undrewears1	September	5	2010	Area 5	Boy 22	1k
7	Undrewears2	October	5	2010	Area 5	Boy 5	1k
8	Undrewears3	November	16	2010	Area 2	Boy 6	1k
9	Undrewears4	December	5	2010	Area 3	Boy 7	1k
10	Undrewears5	June	5	2012	Area 2	Boy 8	1k
11	Sandals1	September	25	2010	Area 1	Boy 12	1k
12	Sandals2	October	25	2010	Area 2	Boy 10	1k
13	Sandals3	November	25	2010	Area 3	Boy 11	1k
14	Towels1	December	22	2010	Area 4	Boy 7	1k
15	Towels2	January	25	2010	Area 5	Boy 3	1k
16	Towels3	June	5	2010	Area 2	Boy 1	1k
17	Towels4	May	7	2011	Area 1	Boy 13	1k
18	Towels5	June	5	2010	Area 2	Boy 6	1k
19	Towels6	August	21	2010	Area 2	Boy 10	1k
20	Towels7	June	9	2011	Area 4	Boy 2	1k
21	Towels7	July	14	2011	Area 5	Boy 1	1k
22	Shorts1	August	9	2011	Area 1	Boy 9	1k
23	Shorts2	June	14	2011	Area 5	Boy 9	1k
24	Shorts2	June	14	2011	Area 1	Boy 4	1k
25	*	*	*	*	*	*	*
26	*	*	*	*	*	*	*
Masterlist

and the third is the Summary of Delivery per Delivery Boy Sheet

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Delivered by	Select a year		2011		Summary of Delivery per Delivery Boy
2		January	February	March	April	May	June	July	August	September	October	November	December
3	Boy 13	0	0	0	0	1	0	0	0	0	0	0	0
4	Boy 2	0	0	0	0	0	1	0	0	0	0	0	0
5	Boy 1	0	0	0	0	0	0	1	0	0	0	0	0
6	Boy 9	0	0	0	0	0	1	0	1	0	0	0	0
7	Boy 4	0	0	0	0	0	1	0	0	0	0	0	0
8	*	0	0	0	0	0	0	0	0	0	0	0	0
9	*	0	0	0	0	0	0	0	0	0	0	0	0
10	*	0	0	0	0	0	0	0	0	0	0	0	0
11	*	0	0	0	0	0	0	0	0	0	0	0	0
12	*	0	0	0	0	0	0	0	0	0	0	0	0
13	*	0	0	0	0	0	0	0	0	0	0	0	0
14	*	0	0	0	0	0	0	0	0	0	0	0	0
15	*	0	0	0	0	0	0	0	0	0	0	0	0
16	*	0	0	0	0	0	0	0	0	0	0	0	0
17	*	0	0	0	0	0	0	0	0	0	0	0	0
18	*	0	0	0	0	0	0	0	0	0	0	0	0
19	*	0	0	0	0	0	0	0	0	0	0	0	0
20	*	0	0	0	0	0	0	0	0	0	0	0	0
21	*	0	0	0	0	0	0	0	0	0	0	0	0
22	*	0	0	0	0	0	0	0	0	0	0	0	0
23	*	0	0	0	0	0	0	0	0	0	0	0	0
24	*	0	0	0	0	0	0	0	0	0	0	0	0
25	*	0	0	0	0	0	0	0	0	0	0	0	0
Delivery per Delivery Boy

my problem is what formula to use so that if i pick a year that is in cell D1(List down box) the count of delivery in respective delivery boy will appear. the delivery boy is a name of a true person.

here's another example...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Delivered by	Select a year		2012		Summary of Delivery per Delivery Boy
2		January	February	March	April	May	June	July	August	September	October	November	December
3	Boy 8	0	0	0	0	0	1	0	0	0	0	0	0
4	*	0	0	0	0	0	0	0	0	0	0	0	0
5	*	0	0	0	0	0	0	0	0	0	0	0	0
6	*	0	0	0	0	0	0	0	0	0	0	0	0
7	*	0	0	0	0	0	0	0	0	0	0	0	0
8	*	0	0	0	0	0	0	0	0	0	0	0	0
9	*	0	0	0	0	0	0	0	0	0	0	0	0
10	*	0	0	0	0	0	0	0	0	0	0	0	0
11	*	0	0	0	0	0	0	0	0	0	0	0	0
12	*	0	0	0	0	0	0	0	0	0	0	0	0
13	*	0	0	0	0	0	0	0	0	0	0	0	0
14	*	0	0	0	0	0	0	0	0	0	0	0	0
15	*	0	0	0	0	0	0	0	0	0	0	0	0
16	*	0	0	0	0	0	0	0	0	0	0	0	0
17	*	0	0	0	0	0	0	0	0	0	0	0	0
18	*	0	0	0	0	0	0	0	0	0	0	0	0
19	*	0	0	0	0	0	0	0	0	0	0	0	0
20	*	0	0	0	0	0	0	0	0	0	0	0	0
21	*	0	0	0	0	0	0	0	0	0	0	0	0
22	*	0	0	0	0	0	0	0	0	0	0	0	0
23	*	0	0	0	0	0	0	0	0	0	0	0	0
24	*	0	0	0	0	0	0	0	0	0	0	0	0
25	*	0	0	0	0	0	0	0	0	0	0	0	0
Delivery per Delivery Boy

and if the number changes it will be blue like in the examples.... but if it is zero it will no fill.

Please Help me!!!
Thank You in advance...

 

[texasalynn]

so if I understand you are wanting a formula that will color the cell blue? If so then a conditional format will work. Select the B3 thru M3 and then the conditional format formula would be
=B3>0
select the format pattern blue

 

[doms123]

you have solve one of my problem, thank you for that. But I need also the formula on cell A to M of Delivery per Delivery Boy Sheet pacticularly the rows 3 downward. I want that if I select the year (at cell D1 a list down cell of years) ut will show the names of of the Delivery boy and how many it delivers it the particular month that is based on my masterlist

I hope you can help me!!!
Thank you in advance....