Find Jobs
Hire Freelancers

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

£20-50 GBP

已完成
已发布超过 5 年前

£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 年前

想赚点钱吗?

在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
付款方式已验证
会员自6月 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)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。