Lukket

Excel VBA find data, copy, paste

A VBA Excel is requested to program that:

Pre-condition:

1) shall consider excel input as in "Sheet1".

2) shall consider excel input as in "Sheet2".

----------------------------------------------------------------------------------

To Do: (see Result_Sheet)

1) shall take "Sheet 2" as basis.

2) for data in Col-B insert new rows.

Note: Data in Col-B are multi-line data separated with line breakers. Col-B can contain only one line, multiple lines, and empty lines, or contain nothing at all (then no action is required).

3) for each newly inserted row, search the content of Col-B from "Sheet1" and enter the corresponding Col_Description for it.

4) newly entered data/rows be in a green font color.

5) newly entered rows be grouped.

6) code shall be appliable for different size of data (rows)

----------------------------------------------------------------------------------

To deliver as output for job acceptance is the macro code/excel.

---------------------------------------------------------------------------------

Data are given in txt file. Just copy and paste in excel.

Evner: Excel, Visual Basic, Dataindførsel, Databehandling, Visual Basic for Apps

Se mere: excel vba copy range to another sheet, excel vba copy cell value and paste to another cell, excel vba copy paste values, excel vba copy destination values only, excel vba copy paste range another worksheet, excel macro to copy and paste from one worksheet to another, excel vba paste from clipboard, excel vba copy range to another workbook, internet explorer vba select copy paste, web excel entry ajax copy paste, excel vba data mining, vba find copy paste sometimes results, excel web browser copy paste, vba word copy paste text formatting, excel macro vba select copy paste internet explorer, excel vba data mpp file, excel vba enable cut paste, vba script copy paste data internet explorer, data entry excel internet par copy paste, excel vba data multiple worksheets

Om arbejdsgiveren:
( 0 bedømmelser ) Germany

Projekt ID: #27556287

26 freelancers are bidding on average ₹1143 for this job

(113 bedømmelser)
5.9
ravinderkumar248

HI there, I can create vba script/Macro based on your requirements . I have 12+ years of experience in Excel VBA, creating complex automation tools, formulas, databases, queries and macros. Please message me to dis Flere

₹900 INR på 1 dag
(57 bedømmelser)
5.2
MartinDudumi

Hi there, I'd like to be considered for your request. I’m a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can ass Flere

₹1050 INR på 1 dag
(35 bedømmelser)
4.9
dhanrajkarthick

Hi there, I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response Regards, Karthick G.

₹1500 INR in 2 dage
(31 bedømmelser)
4.9
swarnali2017

Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfoli Flere

₹1500 INR in 2 dage
(19 bedømmelser)
4.2
maguirrer

Hello, I can help you with the macro to copy and paste, please send me a message with more details and I will start working on it inmediately

₹850 INR på 1 dag
(37 bedømmelser)
4.3
kayarshadi

Hi, I am an Excel , Access, VBA , Power BI expert. Please tell me more about your project in details. Best Regards Kayvan Arshadi

₹1500 INR på 1 dag
(9 bedømmelser)
3.4
Jayant222

Hi there, I am an expert in excel formulas, dashboards, macros. I have gone through the description on your project and will be able to finish in few hours. Thanks Jayant

₹1050 INR på 1 dag
(10 bedømmelser)
2.9
aleksrozenstrauc

I can write a macro to implement the above requirements as shown in the attachments. Looking forward to a positive reply.

₹1050 INR in 4 dage
(3 bedømmelser)
2.3
mmartinezruiz96

Hi, I am an industrial engineer with 3 years of experience who is proficient in VBA. I can develop a script with several macros that can do the required job. I can deliver in less than 1 day. Best Regards, Marc

₹800 INR på 1 dag
(1 bedømmelse)
2.4
arunodaya123

HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I understand your requirement. I can give my full effort to deliver the Flere

₹1500 INR in 2 dage
(3 bedømmelser)
1.8
malikabdulbasit4

Hi.. i am Abdul Basit...i am new but i am sure i will fullfill this task with in few days...so kindly give me a chance... Thankyou

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
stu19

I can now deliver a prototype that is running to be tested. I am new to this platform, if this is not possible, I apologize.

₹1500 INR in 7 dage
(0 bedømmelser)
0.0
sumanshee33

Dear sir/mam, I've completed the project as per your input. I can show the snapshot of the result developed from your input. I wish to handover to you. I'm an experienced professional in excel. I've developed various Flere

₹800 INR på 1 dag
(0 bedømmelser)
0.0
sahedurahman

Dear Sir I have read your job description and I understood this job. I will do your job 100% perfectly without any mistake. If you give me this job I will do my best. So you can give me this job without any confusion. Flere

₹600 INR in 5 dage
(0 bedømmelser)
0.0
Abhiraj1502

We know that Excel As Vlookup, Hlookup, conditional Format, Pivot table , Concatenate Etc.) we handle the Project as a team leader. We send the report on daily basis. we manage the calling team . We Have typing sp Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
Annduples

Good day. My name is Annemarie. I am a seasoned data entry spesialist residing in South Africa. I have experience in microsoft office, Word, Excel and PDF. I know you will get many bids on this project and some of them Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
abdimullah44

Hi! I have decided to search for work online through my level of education and work experience in writing and translating some news and books, with having good typing speed with careful and accurate to every detail. I Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
ikram2277

Hello...! i am Ikram. I have read your requirement and my expertise perfectly align with your needs. I would be delighted to work on this job. Before accepting this offer, please message me in my inbox to have a discus Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
aleximran

i can do it. give me the project. maybe it's my first job if i get it . but, dont worry i work in a IT company for 3 years. but, in freelancer im new. let's do it..

₹900 INR på 1 dag
(0 bedømmelser)
0.0