Find Jobs
Hire Freelancers

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

£20-50 GBP

Dokončeno
Zveřejněno před více než 5 roky

£20-50 GBP

Zaplaceno při doručení
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.
IČ projektu: 18120078

O projektu

21 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
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 v 0 dni
5,0 (516 recenze)
7,8
7,8
21 freelanceři nabízejí v průměru £43 GBP za tuto práci
Avatar uživatele
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 me, please message me and i will explain step by step how i plan to match this data. And yes i am able to start immediately. Thanks, Milan
£33 GBP v 0 dni
5,0 (789 recenze)
7,6
7,6
Avatar uživatele
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 your response thanks
£50 GBP v 1 dni
4,9 (365 recenze)
7,4
7,4
Avatar uživatele
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 take up your project. Thank you, Regards.
£40 GBP v 1 dni
5,0 (191 recenze)
7,1
7,1
Avatar uživatele
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 some selected columns of the given rows to the same columns of the subsequent rows. You can be confident that this project will be professionally completed. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
£50 GBP v 2 dnech
4,9 (77 recenze)
7,0
7,0
Avatar uživatele
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, Scripting, Visual Basic). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
£55 GBP v 3 dnech
4,9 (104 recenze)
6,8
6,8
Avatar uživatele
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, 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.
£100 GBP v 2 dnech
4,9 (118 recenze)
6,6
6,6
Avatar uživatele
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 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. I hope i will do your task as your satisfaction. Thanks
£33 GBP v 1 dni
5,0 (83 recenze)
5,7
5,7
Avatar uživatele
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 v 1 dni
4,9 (52 recenze)
5,2
5,2
Avatar uživatele
hi, i am c# windows and web application developer for past 4.5 years. Have written many macro scripts for fortune companies and received appreciation from clients. Currently working in one of the top companies in india. worked in many vba scraping project and successfully delivered to client on time with high quality. i have read your task and it can be completed in a day. i have already created these type of macro for fortune companies. feel free to chat with me. looking forward to hear from you. thanks mohammed ibrahim
£25 GBP v 1 dni
5,0 (6 recenze)
4,7
4,7
Avatar uživatele
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 v 4 dnech
4,9 (43 recenze)
4,3
4,3
Avatar uživatele
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 offer. Method: I wouldn't use a macros program or VBA - I would use formulas
£55 GBP v 3 dnech
5,0 (4 recenze)
3,9
3,9
Avatar uživatele
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. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for complex tasks possible. • Have worked directly with client for an MNC IT Company. • High Accuracy. • Work in tight deadline. • Minor modification possible even after Payment.
£36 GBP v 10 dnech
4,9 (29 recenze)
4,0
4,0
Avatar uživatele
Hi there, I'm interested in your project. Please send me a message, that we can discuss more. Thanks
£28 GBP v 10 dnech
5,0 (15 recenze)
3,5
3,5
Avatar uživatele
Dear Sir, I can perfectly do the project. I have been working on such projects. I deliver quality, commitment and make sure there is no Plagiarism. I am familiar with all sorts of reference styles. Please send me a message! and let's start working.
£28 GBP v 5 dnech
5,0 (1 recenze)
1,4
1,4
Avatar uživatele
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 bring lots of experience, knowledge and expertise to the table. I have an honest approach towards work and positive attitude. I can assure you quality work, within deadline. I am ready to start immediately. My work is my passion and I believe passion drives excellence. Hope to hear from you soon. Thanks Piyush
£33 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 conclusion, I will handle your project as if my life depends on it. Look g forward to work with you.
£44 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
i am an expert in excel and VB. i can use the macros/vloop-up and partial matches to arrive at the result your are expecting. this will be then automated using macros
£44 GBP v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 echessa from Kenya. I am good at Microsoft Excel, data processing,microsoft word and generally computer skills and 1year experience my bid is $25 and your work will be delivered in 5days
£38 GBP v 10 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED KINGDOM
Hornchurch, United Kingdom
5,0
5
Ověřená platební metoda
Členem od čvn 28, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.