Em Andamento

EXCEL - ADD ADDTIONAL CONDITION INTO VBA CODE

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

Habilidades: Excel, Matemática, Photoshop, PHP, Visual Basic

Ver mais: what is vba in excel, what is vba, what is macro in excel, less than excel, find in vba, excel less than, excel 2013 vba, end vba, vba excel macro, vba code excel, Excel Macro VBA, excel add-in, excel add in, condition, excel 2013 vba find date, filter vba, excel macro add, vba filter, excel unique, excel vba macro file, file filter excel, excel 2013 macro, excel raw data work, php excel macro, trading result

Acerca do Empregador:
( 32 comentários ) MALAGA, Australia

ID do Projeto: #5116568

Premiar a:

Teloquence

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 dias
(171 Avaliações)
6.5

10 freelancers estão ofertando em média $136 para este trabalho

mrbrave

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
(124 Comentários)
5.8
seaanddream

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 in 3 dias
(52 Comentários)
5.8
deepbluetech

A proposal has not yet been provided

$150 AUD in 3 dias
(161 Comentários)
5.8
dpune

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

$111 AUD in 5 dias
(38 Comentários)
5.0
rengrish

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

$100 AUD in 3 dias
(34 Comentários)
4.4
pinkysona

A proposal has not yet been provided

$152 AUD in 8 dias
(9 Comentários)
3.8
eikebierman

Bis jetzt wurde noch kein Vorschlag eingegeben

$155 AUD in 3 dias
(0 Comentários)
0.0
ivancornejo

Wide experience with Excel and VBA Macros. I´m an Industrial Engineer with great analytical skills. You can trust me this work!!

$222 AUD in 3 dias
(0 Comentários)
0.0
KRKans

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 in 2 dias
(0 Comentários)
0.0
qjhtc

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 Mais

$155 AUD in 3 dias
(0 Comentários)
0.0