Find Jobs
Hire Freelancers

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

$10-30 USD

Geschlossen
Veröffentlicht vor mehr als 4 Jahren

$10-30 USD

Bezahlt bei Lieferung
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
Projekt-ID: 20834556

Über das Projekt

32 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
32 Freelancer bieten im Durchschnitt $27 USD für diesen Auftrag
Avatar des Nutzers
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 Tag
4,9 (19 Bewertungen)
5,2
5,2
Avatar des Nutzers
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 Tag
5,0 (14 Bewertungen)
5,0
5,0
Avatar des Nutzers
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 Tag
5,0 (6 Bewertungen)
3,5
3,5
Avatar des Nutzers
$ 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 Tag
5,0 (11 Bewertungen)
3,1
3,1
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
2,5
2,5
Avatar des Nutzers
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 Tag
5,0 (3 Bewertungen)
2,4
2,4
Avatar des Nutzers
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 Tag
5,0 (2 Bewertungen)
2,4
2,4
Avatar des Nutzers
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 Tag
5,0 (3 Bewertungen)
2,4
2,4
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
1,9
1,9
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
1,6
1,6
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hey Dear ,, Give Me complete details you required and if possible screen shot,, i can do this ,,,,,,,,,,,,,,,,,,,
$15 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
Having total of 7yrs of experience into VBA programming Skills-VBA, SQal, RPA(Automation Anywhere),Python
$20 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von SAUDI ARABIA
Jeddah, Saudi Arabia
0,0
0
Zahlungsmethode verifiziert
Mitglied seit Nov. 15, 2015

Kundenüberprüfung

Ähnliche Aufträge

Expert VBA Developer for Excel Automation
₹150000-250000 INR
TEXT DETECTION in JPG Images using Google Vision API from bulk urls in excel file Java / Node JS / Python
$10-30 USD
Advanced Excel Automation VBA and Macros: Data Analysis, Reports & Data Visualization
₹600-1500 INR
Excel-Based Mark Book System for English Learning Area Tracking
$250-750 AUD
Real-Time Stock Retrieval from site
₹600-1500 INR
Swift, Comprehensive Data Typing Service
₹100-400 INR / hour
Portfolio Survivability Monte Carlo Analysis
$30-250 USD
Excel Automation (optionally AI powered) Specialist for Road Transportation Firm in kolkata, west bengal (India) -- 2
₹12500-37500 INR
Excel-WhatsApp Integration for Automated Alerts
$10 AUD
Excel Workbook Developer
$10-30 USD
Excel Automation (optionally AI powered) Specialist for Road Transportation Firm in kolkata, west bengal (India) -- 2
₹12500-37500 INR
Excel to Invoice Automation System
₹600-1500 INR
CSV File Comparison
€8-15 EUR
Advanced Excel Automation VBA and Macros: Data Analysis, Reports & Data Visualization
₹600-1500 INR
Excel Automation (optionally AI powered) Specialist for Road Transportation Firm in kolkata, west bengal (India)
₹37500-75000 INR
Advanced Excel Automation & Create DashBoard
₹600-1500 INR
Excel-WhatsApp Integration for Automated Alerts
$10 AUD
Advanced Budgeting Template Design
$10-30 USD
Excel-WhatsApp Integration for Automated Alerts
$10 AUD
Excel Automation (optionally AI powered) Specialist for Road Transportation Firm in kolkata, west bengal (India) -- 2
₹12500-37500 INR
Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.