Đã hoàn thành

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

Kĩ năng: Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Mechanicsville, United States

ID dự án: #17730772

Được trao cho:


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 Thêm

$333 USD trong 2 ngày
(193 Đánh Giá)

10 freelancer đang chào giá trung bình $323 cho công việc này


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 Thêm

$250 USD trong 1 ngày
(261 Nhận xét)

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 trong 1 ngày
(39 Nhận xét)

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 Thêm

$250 USD trong 1 ngày
(61 Nhận xét)

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 Thêm

$450 USD trong 5 ngày
(35 Nhận xét)

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 Thêm

$350 USD trong 10 ngày
(33 Nhận xét)

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] Thêm

$266 USD trong 10 ngày
(15 Nhận xét)

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 Thêm

$500 USD trong 10 ngày
(18 Nhận xét)

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 trong 5 ngày
(14 Nhận xét)

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 trong 6 ngày
(0 Nhận xét)