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
32 freelancers are bidding on average $27 for this job
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.
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.
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.
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