Excel VB macros

1 Workbook w/7worksheets








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

Skills: Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: 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

About the Employer:
( 0 reviews ) Mechanicsville, United States

Project ID: #17730772

Awarded to:


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 More

$333 USD in 2 days
(193 Reviews)

10 freelancers are bidding on average $323 for this job


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 More

$250 USD in 1 day
(261 Reviews)

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

$250 USD in 1 day
(39 Reviews)

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

$250 USD in 1 day
(61 Reviews)

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 More

$450 USD in 5 days
(35 Reviews)

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 More

$350 USD in 10 days
(33 Reviews)

HI there can do this check my experience here [login to view URL] More

$266 USD in 10 days
(15 Reviews)

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 More

$500 USD in 10 days
(18 Reviews)

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]

$300 USD in 5 days
(14 Reviews)

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!!

$277 USD in 6 days
(0 Reviews)