Finalizat

Modify a VBA script

Job Description:

I have a 3 page VBA script that reads two columns of data from Excel - about 1,000 rows. The code creates worksheet in the same Excel workbook to hold the output. The job is to modify the code to store text in columns when there multiple occurrences of the same text, instead of recording only the first one and leaving the others blank. The work should be easy for someone who knows VBA and should take a few hours.

the first image attachment is the current output i need changed. The second image attachment is what it should look like.

Aptitudini: Excel, Visual Basic, Excel VBA

Despre client:
( 2 recenzii ) New York, United States

ID Proiect: #29356885

Acordat lui:

MimiFL

Hello, would you mind attaching the actual workbook, so i can see what exactly needs to be done. Based on attached pictures this shouldn't be that complicated. I am able to start immediately. Thanks, Milan

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(629 Recenzii)
7.3

39 freelanceri licitează în medie 75$ pentru acest proiect

VladimirLilenko

Hello! I am ready to carry out your project. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Excel and vba, of course, familiar. Regards, Vladimir

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(164 recenzii)
6.8
AnowarRatul

-- 5***** VBA EXPERT --- I CAN START RIGHT AWAY ------ Hello sir, I have checked the details and attachments I can do this work as you absolutely as you want. I can start right now, please message me to discuss more…

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(277 recenzii)
6.4
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 2 hours

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(126 recenzii)
6.0
ravinderkumar248

Hi there, I can modify your VBA script based on your requirements . I have 9+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, queries and macros etc. p Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(99 recenzii)
5.7
vbexcel

Hi; I can deliver the code within 24 hours of acceptance. I am an VBA, python coder professional with over twenty years experience in developing macros to enhance personal productivity.. Please see my portfolio at Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(34 recenzii)
5.7
rumarahman

Hi, Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros. I will be able to finish before the deadline. Thanks Ruma

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(54 recenzii)
5.4
merinsinha

I can do it. Hi i am an Senior Excel VBA Expert. As 15+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works y Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(90 recenzii)
5.2
Mokshith30

Hi I'm Sai Kumar from India. I've read all your requirements in this project. I am very good VBA expert.. so basically you're trying to generate modify vba script right? i will write a vba macro to do this job. So, i Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(50 recenzii)
5.1
professional800

Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I am giving you offer that you award project after checking result. It is easy to do like you asked. I Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(37 recenzii)
4.7
mowachira77

Hi there, I am an expert in excel, VBA and data processing. In this regard, I will write a macro which is deliverable, that will transform data from single row to multiple row (only one column will have data per row). Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(39 recenzii)
4.8
NIKITALILA

Hi there, I have seen the final result required page from what I gather you need the final VBA result in one line rather then it being in a particular way. Pls share more details I'd be open to doing it for a very lo Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(23 recenzii)
4.6
remisanonymous

Hi, I have few years experience in automatic data extraction, analysis, sorting and filling, creating formulas, macros in Excel, Word and developing helpful Visual Basic applications for your needs. Usually I'm trying Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(11 recenzii)
3.8
pmshilwant9

Hi, I would like to work on your project and fix the error and updating the column and capture all the text from the column as per your requirement. I am an automation Specialist in BI domain (BI reporting, Automatio Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(3 recenzii)
2.0
NoSonforhim

Hello, I read your project description and understand all. I have 20 years in Database development, Training, Database administration, System Analysis, Data Analysis using Ms. Word, MS power point, Ms. Access, Ms. Exce Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(2 recenzii)
1.5
iamhamzazaki

Hey there I have read your project description about VBA script I have expertise at it You can contact me We can discuss further over chat

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
1.2
piyushpathania44

Becz i am better than other and i will provide the best than other you can give it to me becoz i will do in minutes

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
Saket801

Hi, I am a professional visual basic exel Expert. I complete your work within time frame. I completely your work in honesty and heartily. Thanks, Rakesh...

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
shirryantihamdan

Dear Sir My name is Sharifah and I’m a Masters graduate from UK. I have read the task description and understand you need someone to adjust the VBA code to remove the blank boxes, which I believe I would be able to Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
neabPonch

Good morning! It looks as though a nested iterable variable is being used outside of the nest, this variable should be reset with each loop vs retaining the row number. I can deliver this within a day if it's as easy Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
y3ec884

I had vast experience in handling this kind of problems in my career. Please leave it to me and you will be able to see the desired output.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0