Find Jobs
Hire Freelancers

Modify a VBA Code for an array to paste till end of row

$10-30 USD

Lezárt
Kiadva ekkor: több mint 4 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve
I have a code that has INDEX then MATCH in it it will paste a formula on a cell till ( THE LAST DATA EXISTING IN THAT SHEET even if there is a blank and then a value after ) using a reference column A. this is the code " =IF(INDEX('Raw Data for PR Dist'!$C$7:$C$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR Dist'!$B$7:$B$100000),0))="","",INDEX('Raw Data for PR Dist'!$C$7:$C$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR Dist'!$B$7:$B$100000),0))) " Must ensure the code does not change if reference sheet insert or deletes a column
Projektazonosító: 20834556

A projektről

32 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
32 szabadúszó adott átlagosan $27 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$35 USD 1 napon belül
4,9 (19 értékelés)
5,2
5,2
Felhasználó avatár
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$30 USD 1 napon belül
5,0 (14 értékelés)
5,0
5,0
Felhasználó avatár
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$30 USD 1 napon belül
5,0 (6 értékelés)
3,5
3,5
Felhasználó avatár
$ 15 ONLY!!! In just 1 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] Sir, please CONTACT with me, I can SEND you a DRAFT project file to ensure my EXPERTISE. If you are 100% satisfied first, then please award me the project. You can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar
$15 USD 1 napon belül
5,0 (11 értékelés)
3,1
3,1
Felhasználó avatár
hey there this is a very easy job for me. i m am expert at excel vba. can start right now.
$15 USD 1 napon belül
5,0 (1 értékelés)
2,5
2,5
Felhasználó avatár
I can do the job! About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$30 USD 1 napon belül
5,0 (3 értékelés)
2,4
2,4
Felhasználó avatár
Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Looking forward to hearing from you. Thanks.
$30 USD 1 napon belül
5,0 (2 értékelés)
2,4
2,4
Felhasználó avatár
VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/need-calculate-KPI-scoring-matrix/?w=f https://www.freelancer.com/projects/excel/Excel-Macro-pull-data-from/?w=f https://www.freelancer.com/projects/excel/Excel-VBA-Time-Series-Decomposition-20459676/?w=f https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f After complete project, I can support fixing bugs with free. and support update features with low price. Please contact me. Thanks
$20 USD 1 napon belül
5,0 (3 értékelés)
2,4
2,4
Felhasználó avatár
Hi, I can modify your excel VBA code to put the formula only in the cell that you need. Best regards, Florin Enache
$25 USD 1 napon belül
5,0 (1 értékelés)
1,9
1,9
Felhasználó avatár
I’m good in VBA and excel functions And I have good experience in data analytics over 8 years ago And I made many projects like your project
$35 USD 1 napon belül
5,0 (1 értékelés)
1,6
1,6
Felhasználó avatár
1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$100 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hey Dear ,, Give Me complete details you required and if possible screen shot,, i can do this ,,,,,,,,,,,,,,,,,,,
$15 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Dear employer, Hi I can solve the issue of your VBA code so that it works when a column is deleted or inserted. Please read the reviews of other employers on my profile. I have done my M.Sc. thesis using Python and MS Excel. It was about developing a numerical model for simulating fluids flow through porous media. I developed the main code in Python and developed my analyzer tools in MS Excel VBA. I learned lots of tricks in programming with these two great languages. It would be a great chance for me if we could collaborate with each other as I am an engineer who loves computer programming. My rating is a little low because one of my employers was a dealer and he did not want me to improve my business on this website. But honestly, I have some rules for my working life and their most important are: Be ON TIME, RESPONSIBLE, and RESPECTFUL. You can read the reviews of other employers on my profile. I am always here to answer your questions even after the project completion. It would be highly appreciated if you could send me a message so we can discuss more. Regards, Amir
$30 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I'm expert in VBA excel formulas and done many projects on time. waiting first hire from freelancer. chat me if interested
$15 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I am good in Excel, please send your Excel file to check it. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$29 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
$35 USD 1 napon belül
5,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
Having total of 7yrs of experience into VBA programming Skills-VBA, SQal, RPA(Automation Anywhere),Python
$20 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I've done many similar tasks in various assignments. Your requirement seems doable. I would like to understand more let me know when we can sync.
$20 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I will use an Excel VBA code to fill the required cells with the required formula. Need to see a sample worksheet.
$10 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I'm Ganex! First of all, i admire how complicated your code is. I think you're so good in excel. Maybe you just need a little more time, if not, someone to help you ( probably, that's me). Did you also use "Ctrl+ shift+ enter" or did you experience that excel is hanging or is too long to respond? Let me help you with that! I already have six years of experience in excel, macro and VBA.
$20 USD 4 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

SAUDI ARABIA zászlója
Jeddah, Saudi Arabia
0,0
0
Fizetési mód hitelesítve
Tagság kezdete: nov. 15, 2015

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.