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:


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)

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


Hello! I am ready to carry out your project. You can read reviews about my work at: 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)

-- 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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)