Terminé

Excel VB macros

1 Workbook w/7worksheets

E

S

M

K

A

C

R

Worksheet E needs 4 “buttons” to start macros (1 each for worksheets S, M, K, and R) plus will use specified data for each to specify variables for worksheet columns

Worksheet K (Run this for all rows (typically 180,000 – 200,00))

Column K has 2 variables that will be text characters defined in Worksheet E, C13 and D13

Column L has variables that will be defined in Worksheet E, C14, D14, E14, F14, G14

Column M has variables that will be defined in Worksheet E, C15, D15, E15, F15, G15

Currently, this is a single cell argument that must be run in the sequence provided

Column P IF([@K]=E!C13,IFNA(IF([@L]=E!C14,E!C16,IF([@L]=E!D14,E!C16,IF([@L]=E!E14,E!C16,IF([@L]=E!F14,E!C16,IF([@L]=E!G14,E!C16,IF([@L]=[@M],E!D16,E!E16)))))),E!F16),E!D13)

Worksheet M (Run this for all rows (typically 120,000 – 150,00))

Column B contains text

Column N contains text or might be blank

Column O contains text or might be blank

Column R contains text or might be blank

Note that text searches are case sensitive

Column X OR(ISNUMBER(FIND(E!C21,[@N],1)),ISNUMBER(FIND(E!C21,[@R],1)),ISNUMBER(FIND(E!C21,[@O],1)))

Column Y OR(ISNUMBER(FIND(E!C22,[@N],1)),ISNUMBER(FIND(E!C22,[@R],1)),ISNUMBER(FIND(E!C22,[@O],1)))

Column Z OR(ISNUMBER(FIND(E!C23,[@N],1)),ISNUMBER(FIND(E!C23,[@R],1)),ISNUMBER(FIND(E!C23,[@O],1)))

Column AA OR(ISNUMBER(FIND(E!C24,[@N],1)),ISNUMBER(FIND(E!C24,[@R],1)),ISNUMBER(FIND(E!C24,[@O],1)))

Column AB IF([@B]=E!C20,OR(ISNUMBER(FIND(E!D26,[@N],1)),ISNUMBER(FIND(E!G25,[@N],1)),ISNUMBER(FIND(E!E25,[@N],1)),ISNUMBER(FIND(E!F25,[@N],1)),ISNUMBER(FIND(E!D25,[@R],1)),ISNUMBER(FIND(E!G25,[@R],1)),ISNUMBER(FIND(E!E25,[@R],1)),ISNUMBER(FIND(E!F25,[@R],1)),ISNUMBER(FIND(E!D25,[@O],1)),ISNUMBER(FIND(E!G25,[@O],1)),ISNUMBER(FIND(E!E25,[@O],1)),ISNUMBER(FIND(E!F25,[@O],1)),ISNUMBER(FIND(E!H25,[@N],1)),ISNUMBER(FIND(E!H25,[@R],1)),ISNUMBER(FIND(E!H25,[@O],1))),FALSE)

Column AC OR([@X]=TRUE,[@Y]=TRUE,[@Z]=TRUE,[@AA]=TRUE,[@AB]=TRUE)

Column AD IF([@L]="",FALSE,IF(43343-[@L]<730,TRUE,FALSE))

Column AE INDEX(A!C:C,MATCH(LEFT([@E],4),A!B:B,0))

Column AF IFNA(IF(INDEX(A!G:G,MATCH(LEFT([@E],4),A!B:B,0))<YEAR([@I]),YEAR([@I]),INDEX(A!G:G,MATCH(LEFT([@E],4),A!B:B,0))),"Unknown")

Column AG INDEX(A!G:G,MATCH(LEFT([@E],4),A!B:B,0))

Column AH is blank

Column AI this is what I use currently (43343 is an older date) OR(AND(IF([@H]>(43343-730),TRUE,FALSE),IF(([@H]-[@I])<730,TRUE,FALSE)),[@AE]=E!C32,[@AE]=E!D32,[@AE]=E!E32,[@AE]=E!F32,[@AE]=E!G32,[@AE]=E!H32,[@AE]=E!I32,[@AE]=E!J32,[@AE]=E!K32,[@AE]=E!L32,[@AE]=E!M32,[@AE]=E!N32,[@AE]=E!O32,[@AE]=E!P32,[@AE]=E!Q32,[@AE]=E!R32,[@AE]=E!S32,[@AE]=E!T32)

Column AJ this is what I use currently OR([@AD],[@AK])

Column AK this is what I use currently (43312 is an older date) AND(IF([@H]>(43312-730),TRUE,FALSE),IF(([@H]-[@I])<730,TRUE,FALSE))

Column AL this is what I use currently OR(ISNUMBER(FIND(E!C35,[@N],1)),ISNUMBER(FIND(E!C35,[@R],1)),ISNUMBER(FIND(E!C35,[@O],1)))

Column AM this is what I use currently OR([@X]=TRUE,[@Y]=TRUE,[@Z]=TRUE,[@AA]=TRUE,[@AB]=TRUE,[@AL]=TRUE)

Column AN IFNA(MATCH([@E],S!L:L,0),”Not in S”)

Worksheet S in file

Compétences : Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

en voir plus : excel vba xml file, excel formatting macros, excel macro read file txt, how to create a macro in excel 2010, excel macro tutorial pdf, how to create a macro in excel 2007, excel vba programming pdf, vba excel examples, how to use macros in excel, macros in excel for beginners, excel macros, excel dashboard macros, create excel order status file, excel 2003 macros, excel printing macros, excel vb read data pdf file, exporting text file excel vb script, find text occurrence multiple times word file vb macros, import file excel vb net, import text file excel vb script

Concernant l'employeur :
( 0 commentaires ) Mechanicsville, United States

Nº du projet : #17730772

Décerné à:

Webxpert4u

Hello, I am ready to create excel macro. Please send me message, I am reading whole text and checking attached,. If you are interested in my offer, please message me so we can discuss. Highly experienced in Excel Pr Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(193 Commentaires)
7.5

10 freelance font une offre moyenne de $323 pour ce travail

zExcel

I'd be happy to help you with this project. I am very familiar with all Excel features and formulas as well as advanced VBA coding. I have also very quick turnover record. So let us discuss this job in more detail Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(261 Commentaires)
7.7
usmanhassan123

PhD in computer science having seven years of experience in Excel development and visual basics. I already done many Excel vba and macros projects.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(39 Commentaires)
5.8
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(61 Commentaires)
5.6
sloker18

I am proficient with excel macro/VBA development, I have gone through your attached workbook and document, I believe I can write the macro to generate the report as requested, if you are interested feel free to message Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(35 Commentaires)
4.6
sajidkhan45

Hi, I am an excel VBA expert and would like to work on this project. Please go through my profile and reviews so that you can be confident about me. I went through the two attached files and would like to discuss ab Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(33 Commentaires)
4.8
AnumZia

HI there can do this check my experience here https://www.freelancer.com/projects/excel/Excel-Spreadsheet-Formula-Work/ https://www.freelancer.com/projects/excel/AXIS-CHART-AXIS-CHART-HISTOGRAM/ [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(15 Commentaires)
4.3
Mfaisalshahzad00

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% satis Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(18 Commentaires)
3.9
haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro VBA etc. Please review my profile and inbox [login to view URL]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(14 Commentaires)
3.6
dohakhaled6

Hi sir, I am new here but I have a good experience with Microsoft office programs ... I would like to have a chance to work on your project..Hope I will be your choice... Thanks!!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
0.0