Closed

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

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

Skills: Excel VBA, Excel Macros

See more: vba code create xml, vba code string gzip, access copy paste vba code, cut paste vba code, ms access vba code copy paste subform form, vba code paste mathtype, excel vba code paste, excel vba code paste range table, vba code paste special excel 2007, vba code copy paste special, paste special vba code, paste html table excel vba code, vba code paste paint, excel 2010 vba code paste, vba code to copy and paste data from excel to outlook, auto-highlight row and column of selected cell with vba code, vba code to copy from excel and paste in word, excel vba find copy paste row

About the Employer:
( 0 reviews ) Jeddah, Saudi Arabia

Project ID: #20834556

33 freelancers are bidding on average $26 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$50 USD in 1 day
(44 Reviews)
7.1
schoudhary1553

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. Pl More

$35 USD in 1 day
(18 Reviews)
5.1
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$40 USD in 1 day
(44 Reviews)
5.4
periyannas

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
(14 Reviews)
4.9
elqueabandona

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 proje More

$30 USD in 1 day
(4 Reviews)
3.3
xinglong717

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. Lookin More

$30 USD in 1 day
(2 Reviews)
2.4
AnowarRatul

$ 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 proj More

$15 USD in 1 day
(3 Reviews)
2.6
purplemaestro

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
(1 Review)
2.5
valor312

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/ More

$20 USD in 1 day
(3 Reviews)
2.4
ielucerotrad1

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, O More

$30 USD in 1 day
(1 Review)
2.2
afenache

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
(1 Review)
1.9
vw1589554vw

Hi, Its very easy project. I can do this for you. Looking forward for your response. Regards, Hemant Kumar

$20 USD in 1 day
(0 Reviews)
0.0
lakshays175

i am vba developer have an experience of 2 years. I have worked on various projects as a vba developer and given result with zero [login to view URL] complete this task just want the sample file.

$15 USD in 7 days
(0 Reviews)
0.0
citijayamala

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 projec More

$100 USD in 3 days
(0 Reviews)
0.0
salemryan

Very experienced in VBA code, I have a similar working code in my toolbox currently that can easily be adapted to your application.

$30 USD in 1 day
(0 Reviews)
0.0
zekie15

create a vba formula. count the row til the last cell with data. find the column where the formula need to be placed then paste the formula equal to the total of row counted.

$22 USD in 1 day
(0 Reviews)
0.0
sathiz87

I will do this work in couple hours and in correct manner Kindly accept my request and provide this job to me

$10 USD in 1 day
(0 Reviews)
0.0
swapnaswetha

Hello, I expertise in VBA and excel, I can able to do this task and deliver you ASAP. I'm a new to freelancer, please trust me and give me this project. many thanks

$20 USD in 1 day
(0 Reviews)
0.0
Ddnj

Count me in! We can simplify your formula if you need by using shorter syntax but with the same result.

$10 USD in 1 day
(0 Reviews)
0.0
FreelancerDJ1

Hi. I have experience in advanced excel and Access. As per the project discription I can complete this project in a day. The amount will be vary as per the requirement Relevant Skills and Experience I have 7 years of More

$30 USD in 1 day
(0 Reviews)
0.0