Attached is a workbook that I need help coding. I have set up Mth Rpt this Rpt Period and Mthly Rpt Last Day of Rpt Period to
show what I want the reports to look like. I have this working via Pivot Tables which I could not include on this workbook
due to size limitations but it takes too long to gather up all the data into one sheet doing it with Pivot Tables. I will
eventually have a client load of no more than 1500 people. It may never get this big. Access is probably the best application
for this but this will work for my needs. Would appreciate the below coding help if anyone can do this.
needs to count all dates in columns T,U,V,W,X,Y from sheets "Client Files" AND T,U,V,W,X,Y from "Discharge
Client Files" based on range specified in cells B3-C3 in "Mth Rpt this Rpt Period" sheet and sort by Voucher
Group Number and place these numbers in columns B,C,D,E,F,G in Mth Rpt this Rpt Period sheet. In the future, I may be adding
a couple more Voucher Group Numbers if more vouchers are recieved.
2. Code needs to count all dates from sheet
"Discharged Client Files" in columns AA, AB, AC, AD, AE based on range specified in cells B3-C3 in "Mth Rpt
this Rpt Period" sheet and sort by Voucher Group Number and place these numbers in Mth Rpt this Rpt Period sheet in
columns H,I,J,K,L with corrsponding Voucher Group Number.
3. Code needs to count all dates from sheet "Client
Files" in column X and Y and Sum numbers in column z specified by dates entered in cells B3 - C3 in Mthly Rpt Last Day
of Rpt Period and place in column B, C, and D of Mthly Rpt Last Day of Rpt Period with corresponding Voucher Group Number.
Difference between question 1,2,&3 is that question 3 numbers are from when person started program and could
go back to 2008 to present month I am in where numbers gathered from question 1 and 2 are going to be month by month
depending on current month I am in.