Extracting Data from one Sheet to generate Reports on another Sheet

[sfowlow]

I need to use data from one sheet to populate a report on another sheet

Here is the scenario:

Once "Envelope #" is selected from the drop-down menu in Cell C3 on Report Sheet, I need all data associated with the specific envelope # on Data Sheet to be extracted to populate corresponding cells in Columns B12-O12

DATA SHEET

Revised Christ Church Contribution Spreadsheet 2020 (2)(4059) (version 2).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Env #	46		47		48		49		50		51		52
2	1st Qtr	Local	Others	Local	Others	Local	Others	Local	Others	Local	Others	Local	Others	Local	Others
3	1
4	2			$80.00
5	3			$40.00
6	4			$40.00
7	5			$40.00
8	6			$40.00
9	7			$40.00										$5.00
10	8			$40.00
11	9	$50.00		$40.00
12	10			$40.00				$20.00	$5.00					$5.00
13	11			$40.00
14	12			$40.00
15	13			$40.00
16	14			$40.00
17
18	Total	$50.00	$0.00	$560.00	$0.00	$0.00	$0.00	$20.00	$5.00	$0.00	$0.00	$0.00	$0.00	$10.00	$0.00
19
20
21
22	Env #	46		47		48		49		50		51		52
23	2nd Qtr	Local	Others	Local	Others	Local	Others	Local	Others	Local		Local	Others	Local	Others
24	1			$40.00										$5.00
25	2			$40.00
26	3			$40.00
27	4			$40.00					$20.00
28	5			$40.00
29	6
30	7
31	8
32	9
33	10
34	11
35	12
36	13
37	14
38
39	2nd Quarter Total	$0.00	$0.00	$200.00	$0.00	$0.00	$0.00	$0.00	$20.00	$0.00	$0.00	$0.00	$0.00	$5.00	$0.00
40	Year to Date	$50.00	$0.00	$760.00	$0.00	$0.00	$0.00	$20.00	$25.00	$0.00	$0.00	$0.00	$0.00	$15.00	$0.00
41
42
43	Env #	46		47		48		49		50		51		52
44	3rd Qtr	Local	Others	Local	Others	Local	Others	Local	Others	Local		Local	Others	Local	Others
45	1
46	2
47	3
48	4
49	5
50	6
51	7
52	8
53	9
54	10
55	11
56	12
57	13
58	14
59
60	3rd Quarter Total	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
61	Year to Date	$50.00	$0.00	$760.00	$0.00	$0.00	$0.00	$20.00	$25.00	$0.00	$0.00	$0.00	$0.00	$15.00	$0.00
62
63	Env #	46		47		48		49		50		51		52
64	4th Qtr	Local	Others	Local	Others	Local	Others	Local	Others	Local		Local	Others	Local	Others
65	1
66	2
67	3
68	4
69	5
70	6
71	7
72	8
73	9
74	10
75	11
76	12
77	13
78	14
79
80	4th Quarter Total	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
81	Year to Date	$50.00	$0.00	$760.00	$0.00	$0.00	$0.00	$20.00	$25.00	$0.00	$0.00	$0.00	$0.00	$15.00	$0.00
82	Year Total	$50.00		$760.00		$0.00		$45.00		$0.00		$0.00		$15.00
83	Env #	46		47		48		49		50		51		52
84
Data Sheet

Cell Formulas
Range	Formula
B80:O80,B60:O60,B39:O39,B18:O18	B18	=SUM(B3:B17)
B40:O40	B40	=SUM(B39,B18)
B61:O61	B61	=SUM(B60,B40)
B81:O81	B81	=SUM(B80,B61)
B82,N82,L82,J82,H82,F82,D82	B82	=SUM(B81:C81)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:WJ17,B24:WJ38,B45:WJ59,B65:WJ79	Cell Value	>0	text	NO

REPORT SHEET

Revised Christ Church Contribution Spreadsheet 2020 (2)(4059) (version 2).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Envelope Number		32
3
4
5	Weekly Offering to March 31st				Weekly Offering to June 30th				Weekly Offering to Sept 30th				Weekly Offering to Dec 31st
6	Week	Local	Others		Week	Local	Others		Week	Local	Others		Week	Local	Others
7	1				1				1				1
8	2				2				2				2
9	3				3				3				3
10	4				4				4				4
11	5				5				5				5
12	6				6				6				6
13	7				7				7				7
14	8				8				8				8
15	9				9				9				9
16	10				10				10				10
17	11				11				11				11
18	12				12				12				12
19	13				13				13				13
20	14				14				14				14
21	Total	$0.00	$0.00		Total	$0.00	$0.00		Total	$0.00	$0.00		Total	$0.00	$0.00
22	Balance	$0.00	$0.00		Fwd from 1st Qtr	$0.00	$0.00		Fwd from 2nd Qtr	$0.00	$0.00		Fwd from 3rd Qtr	$0.00	$0.00
23					Balance	$0.00	$0.00		Balace	$0.00	$0.00		Balace	$0.00	$0.00
24
Report Sheet

Cell Formulas
Range	Formula
N21:O21,J21:K21,F21:G21,B21:C21	B21	=SUM(B7:B20)
B22:C22	B22	=SUM(B7:B20)
N22:O22,J22:K22,F22:G22	F22	=B22
N23:O23,J23:K23,F23:G23	F23	=SUM(F21:F22)

Cells with Data Validation
Cell	Allow	Criteria
C2	List	='Data Sheet'!$B$1:$WG$1