Find Jobs
Hire Freelancers

Develop reusable VBA Macros for my MS Excel Reports.

$10-55 USD

Concluído
Publicado há mais de 5 anos

$10-55 USD

Pago na entrega
I want to automate 2 reports via VBA Macros as follows (A) AUTOMATE MONTHLY SALES REPORT ANALYSIS A monthly sales report. My Report has the following fields (See attached). My interest is for you to develop a VBA macros script which will automatically on running the script generate the following reports (See attachment) (1) Sales Revenue Analysis by Centre showing amount paid and amount unpaid orders (2) Sales Count Analysis by Centre showing count of paid and unpaid orders (3) Analysis of Discounts (4) Top 10 customers by revenue and by orders (5) List of customers with unpaid orders (6) List of discounted orders or customers (B) AUTOMATE REVENUE ASSURANCE EXCEL I want to validate or confirm the truth for orders indicated as paid in the sales report by looking up a bank statement/reconciliation record and pulling up the date and amount paid in the bank statement into a field on the sales report. Each payment record would be set off against the order amount and it there is a difference it will indicate so. It will also allow for manual intervention for some records. This is an urgent which i need within a day or 2. Its also one I consider a simple job which I expect would cost low. I would share all the files with selected freelancer under professional NDA.
ID do Projeto: 17522692

Sobre o projeto

9 propostas
Projeto remoto
Ativo há 6 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
$55 USD em 4 dias
5,0 (117 avaliações)
6,5
6,5
9 freelancers estão ofertando em média $39 USD for esse trabalho
Avatar do Usuário
Hello, I can help with you in your project Develop reusable VBA Macros for my MS Excel Reports. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$50 USD em 1 dia
4,9 (374 avaliações)
8,0
8,0
Avatar do Usuário
Hi, I have read very carefully your project details about writing VBA Macros that will automate Monthly sales report analysis and automate revenue assurance Excel. I am absolutely sure that I can complete this project professionally. I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. Please let my reviews do the talking. Do you want me to start working on the sample right away?
$30 USD em 1 dia
4,9 (54 avaliações)
6,5
6,5
Avatar do Usuário
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: I want to automate 2 reports via VBA Macros as follows Thanks. Faisal S.
$100 USD em 1 dia
5,0 (18 avaliações)
4,0
4,0
Avatar do Usuário
Hi Sir I am a new freelancer. I am willing to do this project at minimal cost or even for free as I am only looking to get positive feedback. Regards
$10 USD em 1 dia
5,0 (8 avaliações)
2,1
2,1
Avatar do Usuário
Hello, I read your job description and I possess all the necessary skill for this work. I have 16 Years of Experience in Excel VBA. I can complete your project in 1 day. Thanks and Regards Sounak.
$30 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Excellent in excel, Microsoft office, certified Six sigma, Expert level analytical skills, .Good experience in same, also have good knowledge of Macros.
$20 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am Good at this kind of work.
$25 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) NIGERIA
LEKKI - AJAH, Nigeria
4,9
23
Método de pagamento verificado
Membro desde set. 28, 2011

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.