Find Jobs
Hire Freelancers

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

$10-30 USD

Closed
Posted over 4 years ago

$10-30 USD

Paid on delivery
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
Project ID: 20834556

About the project

32 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average $27 USD for this job
User Avatar
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 in 1 day
4.9 (19 reviews)
5.2
5.2
User Avatar
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 in 1 day
5.0 (14 reviews)
5.0
5.0
User Avatar
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 in 1 day
5.0 (6 reviews)
3.5
3.5
User Avatar
$ 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 in 1 day
5.0 (11 reviews)
3.1
3.1
User Avatar
hey there this is a very easy job for me. i m am expert at excel vba. can start right now.
$15 USD in 1 day
5.0 (1 review)
2.5
2.5
User Avatar
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 in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
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 in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
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 in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
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 in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
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 in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey Dear ,, Give Me complete details you required and if possible screen shot,, i can do this ,,,,,,,,,,,,,,,,,,,
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm expert in VBA excel formulas and done many projects on time. waiting first hire from freelancer. chat me if interested
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Having total of 7yrs of experience into VBA programming Skills-VBA, SQal, RPA(Automation Anywhere),Python
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will use an Excel VBA code to fill the required cells with the required formula. Need to see a sample worksheet.
$10 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Jeddah, Saudi Arabia
0.0
0
Payment method verified
Member since Nov 15, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.