Ολοκληρωμένο

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

Ικανότητες: Επεξεργασία Δεδομένων, Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 0 αξιολογήσεις ) Mechanicsville, United States

Ταυτότητα Εργασίας: #17730772

Ανατέθηκε στον:

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 Περισσότερα

$333 USD σε 2 μέρες
(193 Αξιολογήσεις)
7.5

10 freelancers κάνουν προσφορές κατά μέσο όρο $323 για αυτή τη δουλειά

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 Περισσότερα

$250 USD σε 1 μέρα
(261 Αξιολογήσεις)
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.

$250 USD σε 1 μέρα
(39 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 1 μέρα
(61 Αξιολογήσεις)
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 Περισσότερα

$450 USD σε 5 μέρες
(35 Αξιολογήσεις)
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 Περισσότερα

$350 USD σε 10 μέρες
(33 Αξιολογήσεις)
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] Περισσότερα

$266 USD σε 10 μέρες
(15 Αξιολογήσεις)
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 Περισσότερα

$500 USD σε 10 μέρες
(18 Αξιολογήσεις)
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]

$300 USD σε 5 μέρες
(14 Αξιολογήσεις)
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!!

$277 USD σε 6 μέρες
(0 Αξιολογήσεις)
0.0