Suoritettu

Copy Excel Data from Rows into unpopulated Rows based on a PARTIAL MATCH in a Column.

Please see attached file.

You need to get the following data:

Rows 2-780

Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S

into the same Columns for Rows 783-2495

You will create a script or macro that will look at Column D, from Rows 2-780, and if the first 8 characters of the data in Cell D2:D780 match D783:D2495, then you will paste the data from the previously mentioned Columns, and leave the other Columns untouched.

Example -

Cell D2 contains 10040970-00. The first 8 characters are 10040970. Cell D802, D803, D804 contains 10040970, therefore the data from Row 2, Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S, should be pasted into Rows 802, 803 & 804.

You must not overwrite Columns B, D, E, F, G, T, U, V, W, X, Y, Z, AA, AB, AC, AD whilst doing that.

Please explain your method.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Scripting, Visual Basic

Näytä lisää: excel macro copy paste data application, copy paste data internet explorer excel within macro, excel macro copy paste data, how to copy a row in excel based on a cell value, excel copy row if cell contains certain text vba, excel index, how to copy rows if column contains specific text/value in excel?, excel copy rows to another sheet based on criteria, if match excel, index match excel, excel copy row if cell contains certain text formula, excel script copy cell data closed file, can copy website data excel sheet, copy paste data excel using visual basic, excel macro copy excel data, copy excel data paste internet explorer, copy word data excel file, copy excel cell column, excel macro copy site data, copy excel data internet explore

Tietoa työnantajasta:
( 3 arvostelua ) Hornchurch, United Kingdom

Projektin tunnus: #18120078

Myönnetty käyttäjälle:

TonmoyRoy111

Dear client I have read the specs and have seen the file also when you posted the project for the first time with slightly less budget. I can do this for you using formulas. Please contact me. Roy

£30 GBP 0 päivässä
(281 Arvostelua)
6.6

26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

sy3d

sir, we can extract first 8 characters of column-D and then we can use vlookup formula and fill required cells is this method ok near you? i can do this i've file, if you give me chance, i can do this i am looking Lisää

£50 GBP 1 päivässä
(358 arvostelua)
7.4
MimiFL

Hello, i am serious freelancer with 100% completion rate and i believe i can help you. I've completed hundreds of excel VBA (macro) projects, and i've never had a single problem. If you are interested in working with m Lisää

£33 GBP 0 päivässä
(416 arvostelua)
6.8
polarjin2017

Hello? How are you? I have good experiences in "Copy Excel Data from Rows into unpopulated Rows based on a PARTIAL MATCH in a Column." as you can see my profile for these (Data Entry, Data Processing, Excel, Scriptin Lisää

£55 GBP 3 päivässä
(67 arvostelua)
6.4
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Well. I will use vba scripting to achieve the desired result. Willing to Lisää

£40 GBP 1 päivässä
(64 arvostelua)
5.6
ahmadca2017

Hello, I would like to complete your project as your requirement like need to get the following data: Rows 2-780 Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S into the same Columns for Rows 783-2495 Y Lisää

£33 GBP 1 päivässä
(65 arvostelua)
5.2
dvcontact

Hi, I have examined your project description about writing formulas that will look through a column of a given number of rows and match the first 8 characters with that of the subsequent rows and past the values of so Lisää

£50 GBP 2 päivässä
(33 arvostelua)
5.5
nwss1986

Hi, I can start right now and can deliver the working macro that does the requirement, in a couple of hours. Please contact me, if interested. Thanks.

£28 GBP 0 päivässä
(82 arvostelua)
5.4
wiisetech

Hi, I am interested in this job. I understand what you required. I will provide you fast,quality and error free work because I am professional and experienced in it. Waiting to discuss with you more. Regards.

£55 GBP 4 päivässä
(40 arvostelua)
4.2
shezy007

I'll Use if else condition for this work to Copy Excel Data from Rows into unpopulated Rows based on a PARTIAL MATCH in a Column

£40 GBP 1 päivässä
(20 arvostelua)
3.9
mtanveer2012

Hello Boss, Got it, I can make script for you in python and I'll also seen your attached file and looked Cell D2 contains 10040970-00. The first 8 characters are 10040970. Cell D802, D803, D804 contains 10040970, ther Lisää

£100 GBP 2 päivässä
(6 arvostelua)
3.1
stewartjlogan1

As an advanced excel user with valuable Financial / Analytical and Data Entry experience, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offe Lisää

£55 GBP 3 päivässä
(1 arvostelu)
3.0
srijanagrawal21

I will fetch 8 digits and find it rows 783-2495 and then I will copy individual cells ensuring that B, D, E, F, G, T, U, V, W, X, Y, Z, AA, AB, AC, AD are not overwritten. About me & what I can provide - • 5 Yrs. Lisää

£36 GBP 10 päivässä
(4 arvostelua)
2.2
Veera777

Hi there, I'm interested in your project. Please send me a message, that we can discuss more. Thanks

£28 GBP 10 päivässä
(3 arvostelua)
1.4
dhgjjfnm

HI, I work on excel..I have more then 3 year experience in this field..I will give you best services ..Please contact with me for your job..Thank you.. Sincerely juwel

£50 GBP 3 päivässä
(0 arvostelua)
0.0
Sunbase

I have a 5 years experience as a research analyst and I'm very skilled in the use of Microsoft excel. I will handle the job neatly and deliver as scheduled. If you are not satisfied with the results, do not pay me. In Lisää

£44 GBP 1 päivässä
(0 arvostelua)
0.0
psr1427

Dear Revered, I have understood your requirements clearly and I can ably assist you in this task of data entry exactly as per guidance. My inclusion in your scheme of things will be an excellent decision as I will b Lisää

£33 GBP 1 päivässä
(0 arvostelua)
0.0
mukeshrana824

Dear sir, I will give you the best result on your project. you can chat with me and let's get started project. I am ready to show you samples of similar project, I have completed thanks.

£33 GBP 10 päivässä
(0 arvostelua)
0.0
£38 GBP 10 päivässä
(0 arvostelua)
0.0
amirmukhtar149

Greetings, very simple task. Expert is here. I can do this task with high accuracy I am confident that i can deliver best service for you if i am awarded Thanks in advance!

£38 GBP 1 päivässä
(0 arvostelua)
0.0
echessalavender

I am lavender echessa from Kenya. I request for the above job offer because I have great skill in Microsoft Excel ,generally. My bid is $30 and I deliver work in 5days Relevant Skills and Experience I am lavender eche Lisää

£38 GBP 10 päivässä
(0 arvostelua)
0.0