Encerrado

Automate excel spreadsheet with macros vba

Have exisitng excel spreadsheet that requires automation. We use the ssheet for all contact and job info for service calls throughout the year. We schedule the calls at the beginning of the year, add new customer/jobs and pull from the sheet jobs according to date and several other parameters(i.e. part of town, job type, etc.). We would like to automate the data entry on a separat UI page and the same with sorting/filtering for selecting the appropriate jobs.

We would also like the capabilities to batch print the selected jobs onto a custom work order form(already created in Access, but would like to do all of this in excel, I think). We would like to update the ssheet with jobs remaining for the year by importing a report from Qbooks which has the invoiced jobs removed to overwrite the exisiting list.

Habilidades: Engenharia, Microsoft, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic para Apps, Área de trabalho do Windows

Ver mais: vba with, vba jobs, vba excel jobs, sorting jobs, service spreadsheet, order entry jobs, jobs vba excel, jobs that use excel, jobs spreadsheet, jobs excel vba, info job customer service, excel data entry form 2010, data entry form for excel 2010, data entry form excel 2010, custom list in excel, customer service data entry jobs, custom data entry form in excel 2010, batch data entry, vba and macros, ui-date, print vba, excel vba with, excel 2010 data entry form, customer data in excel, windows automation

Acerca do Empregador:
( 2 comentários ) Post Falls, United States

ID do Projeto: #2984804

9 freelancers are bidding on average $765 for this job

gribfritz

See private message.

$1024.25 USD in 45 dias
(487 Comentários)
7.6
jal540

See private message.

$510 USD in 45 dias
(39 Comentários)
5.6
lukmcg

See private message.

$1572.5 USD in 45 dias
(3 Comentários)
4.2
tjscience

See private message.

$510 USD in 45 dias
(5 Comentários)
4.0
ssusavw

See private message.

$467.5 USD in 45 dias
(4 Comentários)
4.5
jhitchcock

See private message.

$425 USD in 45 dias
(9 Comentários)
3.6
spalmer1

See private message.

$425 USD in 45 dias
(1 Comentário)
1.7
technolux

See private message.

$1530 USD in 45 dias
(0 Comentários)
0.0
JohnBHarris

See private message.

$425 USD in 45 dias
(1 Comentário)
0.0