Find Jobs
Hire Freelancers

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

£20-50 GBP

Завершено
Опублікований over 5 years ago

£20-50 GBP

Оплачується при отриманні
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.
ID проекту: 18120078

Про проект

21 пропозицій(-ї)
Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 день
5,0 (516 відгуки(-ів))
7,8
7,8
21 фрілансерів(-и) готові виконати цю роботу у середньому за £43 GBP
Аватарка користувача
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 за 0 день
5,0 (789 відгуки(-ів))
7,6
7,6
Аватарка користувача
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 за 1 день
4,9 (365 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 1 день
5,0 (191 відгуки(-ів))
7,1
7,1
Аватарка користувача
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 за 2 дні(-в)
4,9 (77 відгуки(-ів))
7,0
7,0
Аватарка користувача
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 за 3 дні(-в)
4,9 (104 відгуки(-ів))
6,8
6,8
Аватарка користувача
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 за 2 дні(-в)
4,9 (118 відгуки(-ів))
6,6
6,6
Аватарка користувача
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 за 1 день
5,0 (83 відгуки(-ів))
5,7
5,7
Аватарка користувача
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 день
4,9 (52 відгуки(-ів))
5,2
5,2
Аватарка користувача
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 за 1 день
5,0 (6 відгуки(-ів))
4,7
4,7
Аватарка користувача
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 дні(-в)
4,9 (43 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (4 відгуки(-ів))
3,9
3,9
Аватарка користувача
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 за 10 дні(-в)
4,9 (29 відгуки(-ів))
4,0
4,0
Аватарка користувача
Hi there, I'm interested in your project. Please send me a message, that we can discuss more. Thanks
£28 GBP за 10 дні(-в)
5,0 (15 відгуки(-ів))
3,5
3,5
Аватарка користувача
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 за 5 дні(-в)
5,0 (1 відгук)
1,4
1,4
Аватарка користувача
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 за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
Hornchurch, United Kingdom
5,0
5
Спосіб оплати верифіковано
На сайті з черв. 28, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.