Em Andamento

Excel VBA Data Processing

Dear All,

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 [url removed, login to view] [url removed, login to view] [url removed, login to view]

BA Oct 7/2009 1027-003 BTTS Mohsen BW Test [url removed, login to view] [url removed, login to view] [url removed, login to view]

AJ Oct 4/2009 1031-001 Lipp Mizin/Remraam NBW probing [url removed, login to view] [url removed, login to view] [url removed, login to view]

What is required is a macro that would create two sheets

Sheet One:

1)Sort out by each lawyer,by each day with the billable and non billable work recorded each day.

AJ

Date Billable N-Billable Total

Oct 1

Oct 2

Oct 3

Oct 4/2009 1 1 2

....

Oct 9/2009 4 6 10

...

Oct 31/2000

Sheet Two:

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 [url removed, login to view] [url removed, login to view] [url removed, login to view]

2 186-017 Al Ghaith Holding FIR [url removed, login to view] [url removed, login to view] [url removed, login to view]

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.

Thanks

Habilidades: Processamento de dados, Excel

Ver mais: vba processing, we excel, vba work, vba with, need data processing, need lawyer one day, me excel, lawyer consultant, free consultant, excel vba consultant, excel macro consultant, excel vba data processing, vba for, me vba, in vba, wj, vba excel macro, vba excel, sort excel, report w, mohsen, macro vba, macro excel, excel w, excel vba macro

Acerca do Empregador:
( 15 comentários ) Dubai, United Arab Emirates

ID do Projeto: #548215

Premiar a:

guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

$50 USD em 1 dia
(2 Avaliações)
2.9

4 freelancers estão ofertando em média $85 para este trabalho

MAnkita

Hello,Please refer your PMB.Thank you.

$100 USD in 3 dias
(90 Comentários)
6.3
ichurakov

Please check PM. Thnx.

$70 USD em 1 dia
(3 Comentários)
2.1
LydiaK

Please Check PM

$120 USD in 4 dias
(0 Comentários)
0.0