Find Jobs
Hire Freelancers

EXCEL - ADD ADDTIONAL CONDITION INTO VBA CODE

$30-250 AUD

Concluído
Publicado há mais de 10 anos

$30-250 AUD

Pago na entrega
I HAVE A FILE THAT HAS FOUR MACRO BUTTONS - CREATE TAB FOR EACH GROUPNAME - CREATE TAB FOR EACH STAFFNAME - EMAIL - RESET ALL MACRO BUTTONS WORK FINE HOWEVER I NEED ANOTHER CONDITION APPLIED TO THE CREATE TAB FOR EACH GROUPNAME BUTTON THIS BUTTON TAKES INTO ACCOUNT THE START AND END DATE PARAMETER AND ALSO MAX TRADING MONTHS AND MAX TRADING VALUE PARAMETER WHAT IT DOES IS LOOK AT THE RAW DATA HELD IN SHEET 2 (DATA TAB) AND FILTERS ALL NAMES (COLUMN C OF DATA TAB) THAT HAVE TRADED WITHIN THE DATE PARAMETER SELECTED AND CREATE A TAB FOR EACH UNIQUE GROUPNAME HELD IN COLUMN A OF THE DATA TAB. THE NAMES LISTED IN EACH GROUPNAME TAB THEY HAVE SALES FOR THE RESULT WILL SHOW MONTH BY MONTH SALES THE CODE WILL THEN FILTER ALL THOSE NAMES (COLUMN C OF DATA TAB) THAT HAVE TRADED EQUAL TO AND LESS THEN THE VALUE IN THE MAX TRADING MONTH VALUE AND WILL EXCLUDE THOSE NAMES THAT HAVE TRADED MORE THAN THIS VALUE FINALLY THE CODE LOOKS AT THE THE VALUE IN THE MAX TRADING VALUE PARAMETER - ALL NAMES THAT HAVE HAD A GRAND TOTAL HIGHER FOR THE GROUPNAME IN QUESTION IS ALSO EXCLUDED WHAT NEEDS TO BE APPLIED IS WE WANT TO BE ABLE TO PUT A VOLUE OF 0 IN THE MAX TRADING PARAMETER AN 'IF' STATEMENT NNEDS TO BE ADDED SAYING FOR THE CODE TO RUN AS IT IS CURRENTLY EXCEPT WHEN THE VALUE 0 IS KEYED INTO THE MAX TRADING PARAMETER WHEN THE VALUE IS 0 THE CODE NEEDS TO LOOK ALL THE UNIQUE VALUES (NAMES) IN COLUMN C AND FIND ALL THOSE NAMES THAT HAVE HAD SALES IN THE DATE PARAMETER GIVEN AND ALL THIS OTHER NAMES THAT HAVE NOT HAD ANY SALES ARE TO BE DISPLAYED LETS SAY THERE ARE A TOTAL OF 10 UNIQUE NAMES (COLUMN C OF DATA TAB) WHO HAVE ALL HAD SALES OVER A 12 MONTH PERIOD i USE A START AND END DATE PARAMETER OVER TWO MONTHS SAY FROM FEB TO MARCH WITH A MAX TRADING MONTH VALUE OF 0 IF I CLICK ON THE 'CREATE TAB FOR EACH GROUPNAME' MACRO BUTTON THE CODE WILL FIRST FIND THE 10 UNIQUE NAMES IN COLUMN C OF DATA TAB (LETS SAY THE NAMES ARE CALLED CUSTOMER 1 TO CUSTOMER 10) THNE IDENTIFY THOS NAMES THAT HAVE SALES IN THE MONTHS FEB AND MARCH AND CAN SEE THAT CUSTOMER ONE THROUGH TO CUSTOMER 9 HAVE ALL HAD SALES HOWEVER CUSTOMER 10 DID NOT HAVE ANY SALES IN THIS MONTH SO THE RESULT IS CUSTOMER 10
ID do Projeto: 5116568

Sobre o projeto

10 propostas
Projeto remoto
Ativo há 10 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
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$74 AUD em 0 dia
4,9 (171 avaliações)
6,5
6,5
10 freelancers estão ofertando em média $136 AUD for esse trabalho
Avatar do Usuário
VBA expert coder here...I have completed over 100 Excel-VBA related projects here...I am available to start work and can provide complete by Australia morning time....Thanks
$126 AUD em 1 dia
4,9 (124 avaliações)
5,8
5,8
Avatar do Usuário
Hello; your 5-star excel-vba expert is ready to help you... kindly check my profile and feedbacks and get back to to me if you wish to proceed with a top-rated and reliable partner here...regards,
$105 AUD em 3 dias
5,0 (52 avaliações)
5,8
5,8
Avatar do Usuário
A proposal has not yet been provided
$150 AUD em 3 dias
5,0 (161 avaliações)
5,8
5,8
Avatar do Usuário
Hi, can we work again together ? tks. Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with positive response. Thanks.
$111 AUD em 5 dias
5,0 (38 avaliações)
5,0
5,0
Avatar do Usuário
Excel Top Rated Freelancer . I have over 10+ years of experience in VBA & Macro . Please check my past reviews and ratings. I can complete this very quickly. I assure you 200% quality job. Please share the workbook , so that i can have a look and provide you exact estimation. I give more importance to job than $ .
$100 AUD em 3 dias
4,9 (34 avaliações)
4,4
4,4
Avatar do Usuário
A proposal has not yet been provided
$152 AUD em 8 dias
5,0 (9 avaliações)
3,8
3,8
Avatar do Usuário
Bis jetzt wurde noch kein Vorschlag eingegeben
$155 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Wide experience with Excel and VBA Macros. I´m an Industrial Engineer with great analytical skills. You can trust me this work!!
$222 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, We recently worked on the graph with qualitative measurements on y axis. I have that ready. I can help you out in this also. Regards Kumail
$166 AUD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Think I can do this though it still looks a little confused to me after the reading, maybe you can send me a sample file to help me understand the request and whether or not I'm capable of this. I used to work in a small bank where Excel VBA coding is usually needed since they don't have enough budget to develop a integrated fully functional system for loan management so I'm quite confident in Excel.
$155 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
MALAGA, Australia
5,0
32
Método de pagamento verificado
Membro desde nov. 1, 2013

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.