VBA Code to Generate Report from All Sheets

[Cristinky420]

Hey there!

I am building a database and am trying to generate metrics from Log sheets in my workbook.

Below is the report I would like to generate.

Book1
	A	B	C
2	Report Generated:
3	Report Start:
4	Report End:
13
14	Client Services +/-
15	Clients Registered
16	Clients Deceased
17
18	Client Interaction Breakdown
19		# of Logs	Time
20	Phone
21	E-mail
22	Clinic
23	In-Home
24	Follow-up
Metrics

I have a Button on this sheet that opens UserForm1. UserForm1 then shows two date pickers: Report Start Date (DTPicker1) and Report End Date (DTPicker2). Once dates are picked there is CommandButton1 which I would then input the code into.

I would like the code to return counts and sums that are between the Report Start & End Dates as follows:

• B2 would equal the day the report is generated
• B3 would be the value of DTPicker1
• B4 would be the value of DTPicker2
• B15 would be a count of Master!Q:Q if the dates fall within the reporting dates
• B16 would be a count of Master!U:U if the dates fall within the reporting dates
• B20 would count across all sheets if the date in A:A is within the reporting days and there is an "x" in B:B in that row
• C20 would sum the value in G:G across all sheets if the date in A:A in that row is within the reporting days, and there is an "x" in B:B in that row
• B21 would count across all sheets if the date in A:A is within the reporting days and there is an "x" in C:C in that row
• C21 would sum the value in G:G across all sheets if the date in A:A in that row is within the reporting days, and there is an "x" in C:C in that row
• B22 would count across all sheets if the date in A:A is within the reporting days and there is an "x" in D:D in that row
• C22 would sum the value in G:G across all sheets if the date in A:A in that row is within the reporting days, and there is an "x" in D:D in that row
• B23 would count across all sheets if the date in A:A is within the reporting days and there is an "x" in E:E in that row
• C23 would sum the value in G:G across all sheets if the date in A:A in that row is within the reporting days, and there is an "x" in E:E in that row
• B24 would count across all sheets if the date in A:A is within the reporting days and there is an "x" in F:F in that row
• C24 would sum the value in G:G across all sheets if the date in A:A in that row is within the reporting days, and there is an "x" in F:F in that row

Example of Master Sheet:

Book1
	A	Q	U
1	Client #	Deceased Date	Registration Date
2	0002		1-Jan-2019
3	0004	1-Feb-2019
4	0005
5	0006
6	0009	1-Mar-2019
7	0010		15-Jan-2019
Master

Example of Log Sheet:

Book1
	A	B	C	D	E	F	G	H
1	0002	Adams, Adam					Active
2	Date	Visit Type					Time (h:mm)	File notes
3		Phone	E-mail	Clinic	In-Home	Follow-up
4	Totals:	1	1	1	1	1	5:00
5	1-Jan-2019	x					1:00
6	1-Feb-2019		x				1:00
7	1-Mar-2019			x			1:00
8	1-Apr-2019				x		1:00
9	1-May-2019					x	1:00
0002

Thank-you for your help!!!!!