Đã hoàn thành

VBA Excel automation

Please refer to the spreadsheet:

I need to look at status, if the status is "Executed" then ignore and go to the next row. It then needs to find the latest date entered for that row, in row 2 this would be 16/11/17, it needs to then put into an array the contract number "2", then comments "Finalising contract" then the date 16/11/17 followed by the latest date header Closed

Once they are in an array i need to print them to sheet1 in the workbook for example. See the worksheet for the output required

Kĩ năng: Excel, Kiến trúc phần mềm, VB.NET, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel automation step step, cut paste vba excel, vba excel worksheet info form, useful vba codes for excel, vba excel download, excel vba programming examples download, vba code library, 2500 excel vba examples free download, vba excel pdf, vba excel examples, excel vba programming pdf, vba excel open output utf, extract filename worksheet name vba excel, vba excel programming compare excel worksheet, vba search word text files output excel, vba excel refer workbook, vba excel worksheet update, vba excel worksheet names file, show worksheet vba excel, vba excel data validation worksheet

Về Bên Thuê:
( 0 nhận xét ) Australia

ID dự án: #18994033

Được trao cho:


Hello, i've read the description and look at the attached file and i believe i can help you. If you are interested in working with me, please message me so i can ask you few simple follow up questions. Btw i can code t Thêm

$35 AUD trong 0 ngày
(474 Đánh Giá)

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


Hello? How are you? I have seen the project - "VBA Excel automation." I have been working in these fields((Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps)) for 7 yrs as a freelancer. I c Thêm

$155 AUD trong 3 ngày
(115 Nhận xét)

Hi! I can do this and deliver it tomorrow. I'll do it through VBA But I need an excel file that matches the written example, this one doesn't. Thanks! Felice -------------------------------------

$133 AUD trong 2 ngày
(26 Nhận xét)

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$70 AUD trong 1 ngày
(118 Nhận xét)

Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Exce Thêm

$250 AUD trong 1 ngày
(62 Nhận xét)

Hello. I have good skills in "Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps". I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you w Thêm

$70 AUD trong 0 ngày
(53 Nhận xét)

Hi, I am good with VBA. I reviewed the spreadsheet and automation you are expecting. I can help you with the project and will complete in a couple of days. Please feel free contact. Thank you! Regards, Nag Thêm

$111 AUD trong 2 ngày
(32 Nhận xét)

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Thêm

$65 AUD trong 3 ngày
(23 Nhận xét)

Hello there, I am an Excel VBA coder with more than 100+ macros was created. I can do this project for you in 30 mins or less. And I can start right now. I see your attachment I found many ways to complete. Please Thêm

$30 AUD trong 0 ngày
(43 Nhận xét)

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing and formatting using Excel Formula and VBA. I have finished a lot of projects like this. I can show you one of Thêm

$30 AUD trong 0 ngày
(19 Nhận xét)

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Thêm

$50 AUD trong 0 ngày
(30 Nhận xét)

Hi Good Day! I've done a lot of job like this one before. I can help you to complete this project in high quality. This is feasible using VBA MAcro. this is the first time I bid for a graphic design here in Freel Thêm

$50 AUD trong 2 ngày
(17 Nhận xét)

I can do the job! looks like a pretty straight forward task. If awarded a do have some questions to clarify (ie dates are not those mentioned and doubts about the contract number to load in an array) I'm an engineer w Thêm

$35 AUD trong 2 ngày
(4 Nhận xét)

hi, I`v rich experiences of Excel Macro & VBA. I understood what you need. I`ll do best for you. regards

$166 AUD trong 10 ngày
(4 Nhận xét)

Dear Sir! I read your description carefully. As I have rich experiences in vba programming, I can offer you the excellent result in time. Best Regards.

$120 AUD trong 1 ngày
(2 Nhận xét)

Hi! I am very interested in your project. I have been using Excel extensively to automate processes at work and to make our workflow easier. I would love to help you out with your project. Thank you for considera Thêm

$111 AUD trong 3 ngày
(0 Nhận xét)

Sounds like it should be a simple project, but I'll want to confirm a couple things about what you want. Should be simple to do though.

$222 AUD trong 2 ngày
(0 Nhận xét)

i can do it. i usually do job same as this project. ............................................................ ..........................................................

$155 AUD trong 1 ngày
(0 Nhận xét)

Hi, Thanks for reading my proposal. I would like to put up a bid for your project. The instructions is in 2 parts. a. Skip records that are "Executed". The macro will read from second line till there is no more Thêm

$35 AUD trong 0 ngày
(0 Nhận xét)

Hi, Having good expertise in Excel VBA and good knowledge in programming. Please let me know if I can assist you in this work. Looking forward to work with you. Thanks!!

$140 AUD trong 3 ngày
(0 Nhận xét)

Hi, I already see your file, it is not too difficult with me, so i can solve it with cheap cost. A short VBA code can solve it. Nice day,

$35 AUD trong 2 ngày
(0 Nhận xét)