Em Andamento

Excel VBA macro for personal finance

Require an Excel VBA macro to do the following.

======================================

Given an Excel spreadheet (see attachment) require a macro that will prompt the user for Amount in USD, Category (See attachment for list of categories) and comment.

Once data is entered, the amount should be filled in the respective row, column in the spreadsheet. As an example, an

entry on August 01, 2003 can be the following.

Amount(US $): 34.95

Category: Restaurant

Comments: 34.95 for dinner at P.F Changs.

This will need to be automatically entered in cell H1 on sheet named August.

Similarly, other entries will need to be filled. See example on Spreadsheet. Rows are the dates for the month and columns are the categories.

If a cell already has a previous entry, the entered amount must be summed with the existing amount and applied to the cell. Comments must be concatenated to the existing comment.

Finally a report for the month should be made available that will neatly print on one page. [landscape format, comments not required to be printed]

Extra effects thrown in are appreciated.

Thanks,

Ashok Rao

President

California Design.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

This will need to run on Excel 2002, Windows 2000, XP.

Thanks

Habilidades: ASP, Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Arquitetura de software, Teste de Software, Visual Basic, Word

Ver mais: vba work, vba with, restaurant design software, landscape design software, landscape design program, data entry form excel 2003, vba personal finance, print vba, excel vba with, excel vba and, vba, vba excel macro, personal finance, Macro vba, finance in excel, finance excel, finance excel data, excel/vba, excel vba macro, excel vba form & data work, excel vba data entry form, Excel Macro VBA, excel finance, excel $2-30, restaurant form design

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #2958560

Premiar a:

vles

See private message.

$17 USD em 5 dias
(9 Avaliações)
4.3

14 freelancers estão ofertando em média $12 para este trabalho

TakeRealUK

See private message.

$17 USD in 5 dias
(810 Comentários)
7.0
ndima

See private message.

$5.1 USD in 5 dias
(96 Comentários)
6.6
prasanna123

See private message.

$17 USD in 5 dias
(58 Comentários)
5.1
timk98

See private message.

$17 USD in 5 dias
(54 Comentários)
4.7
jddvw

See private message.

$8.5 USD in 5 dias
(31 Comentários)
4.2
svetoslavvw

See private message.

$4.25 USD in 5 dias
(7 Comentários)
3.4
tucowsvw

See private message.

$8.5 USD in 5 dias
(10 Comentários)
2.6
grzegorztwa

See private message.

$17 USD in 5 dias
(3 Comentários)
2.1
frozenstorms

See private message.

$17 USD in 5 dias
(3 Comentários)
1.6
sergiobcvw

See private message.

$12.75 USD in 5 dias
(0 Comentários)
0.0
rphilipvw

See private message.

$12.75 USD in 5 dias
(0 Comentários)
0.0
cmschick

See private message.

$8.5 USD in 5 dias
(0 Comentários)
0.0
metcarob

See private message.

$8.5 USD in 5 dias
(0 Comentários)
0.0
kopibrik

See private message.

$17 USD in 5 dias
(0 Comentários)
0.0