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 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

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 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.

Thanks

Habilidades: Processamento de dados, Excel

Ver mais: vba processing, we excel, vba work, vba with, should i be a lawyer, need for data processing, need a lawyer for one day, need a lawyer for free, me excel, is lawyer a consultant, i need lawyer for free, free consultant, excel vba consultant, excel macro consultant, data processing co, excel vba data processing, what is vba in excel, what is vba, what is macro in excel, what is a test case, vba for, me vba, in vba, excel vba with, excel vba and

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