I have an Excel Sheet which is exported from our Database.
These sheets contain some columns that we need to analyze to make a small report.
The following is sample list of the data exported from the database.
Lawyer Date Matter Client Matter Description Task Explanation Hours Rate Total
AJ Oct 4/2009 1031-001 Lipp Mizin/Remraam BW meeting w clients 1.00 1500.00 500.00
BA Oct 7/2009 1027-003 BTTS Mohsen BW Test 1.00 1500.00 500.00
AJ Oct 4/2009 1031-001 Lipp Mizin/Remraam NBW probing 1.00 1500.00 500.00
What is required is a macro that would create two sheets
1)Sort out by each lawyer,by each day with the billable and non billable work recorded each day.
Date Billable N-Billable Total
Oct 4/2009 1 1 2
Oct 9/2009 4 6 10
1)Sort out by each Matter Number,Group the total billable and non billable hours worked by each particular consultant on that particular project for that particular month.
Consultant : WJ
No Matter Client Name Description BH NBH Amount
1 022-012 Fichte & CO UCP 600Course 0.00 0.00 0.00
2 186-017 Al Ghaith Holding FIR 0.00 1.50 0.00
Please feel free to contact me in case of any doubt clearance with the project description.
Also note that the macro should be editable,for future modifications.