Find Jobs
Hire Freelancers

MS Excel Data Manipulation MACRO

£20-250 GBP

Concluído
Publicado há quase 4 anos

£20-250 GBP

Pago na entrega
I need to have a macro created for MS Excel that transforms a data sheet (this example and other different ones ongoing). where there is a reference number in Column A and multiple categories in Column B, all comma separated. These comma separated values need to be moved so that each SKU/reference number only has one category per row. There are example sheets attached. AS IS is as the data will be originally, and TO BE is how it should be output. This macro should be able to be run on any different data in this format, not just the example set supplied. Example 1001740 | 321,328,327,31 should become 1001740 | 321 1001740 | 328 1001740 | 327 1001740 | 31 It might be good to used the `Text to columns` feature to populate the cells and then move them. Also, this is a good article for creating multiple rows based on a value. [login to view URL] This is needed within the next 24 hours, by 12pm UK time on the 10th July. Do not quote if you cannot complete by then. I will use a number of files to test the macro works correctly, so please ensure the macro will work on any number of data lines.
ID do Projeto: 26495297

Sobre o projeto

25 propostas
Projeto remoto
Ativo há 4 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, I'm Pranjal Kothari from India! I think this is fairly straightforward and I can achieve this within an hour by splitting the string in the values in Col B and then creating a new row for it and then looping this for all values till the end of the sheet - I can build this through a macro in VBA. If you can chat with me I will first provide you a fully working file that can achieve the above explained automation before accepting your project so that you can verify the quality of my work. Award me the project only when I have fully completed your task and you are completely satisfied with the final file - that way you too can be sure of my 100% commitment. ABOUT ME: I am proficient in Excel VBA and Python. I have designed varied kinds of automation software and utility programs in VBA and Python that have saved vast amounts of time and effort for my customers. Your satisfaction is my prime priority proof of which are my reviews and repeat hire rate: More than half of my customers have come back to me for a repeat order! You can even reach out to me for additional assistance if required after the project is over. Looking forward to a prompt response from you! Regards, Pranjal Kothari
£30 GBP em 1 dia
5,0 (39 avaliações)
5,3
5,3
25 freelancers estão ofertando em média £97 GBP for esse trabalho
Avatar do Usuário
Dear Employer, I am an Excel expert and have been working on process automation projects since a decade now. Please consider me for this job, I will deliver a highly professional project. My previous reviews on similar jobs can be viewed here: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish
£150 GBP em 1 dia
5,0 (230 avaliações)
8,0
8,0
Avatar do Usuário
-----------✅ -----------------------I CAN START RIGHT AWAY --------------------✅ ------------ Hello sir, I have read your project details and reviewed attachments carefully and understand it clearly. I can build the Excel Data Manipulation VBA Macro Program by maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain
£57 GBP em 1 dia
5,0 (240 avaliações)
6,3
6,3
Avatar do Usuário
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
£135 GBP em 7 dias
4,7 (40 avaliações)
5,9
5,9
Avatar do Usuário
Hi. Simple project. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 hour
£20 GBP em 1 dia
4,9 (101 avaliações)
5,9
5,9
Avatar do Usuário
Hi, will we be delivered today itself...will be done thru macro....pls message me....................we did similar task to a Germon customer in march this year
£50 GBP em 1 dia
5,0 (18 avaliações)
4,0
4,0
Avatar do Usuário
✅ Excel, Macros,Database 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 before the deadline. Thanks Jayant
£90 GBP em 2 dias
4,8 (14 avaliações)
3,5
3,5
Avatar do Usuário
Hello :) 20 Only ----- sir, I have experience in writing macros VBA for Excel. Best regards ***************************************************
£20 GBP em 1 dia
4,8 (9 avaliações)
3,6
3,6
Avatar do Usuário
Hi I am willing to take this task and will return to you within today. Please award the project so I can start working on it. Thank you!
£150 GBP em 1 dia
4,0 (7 avaliações)
3,7
3,7
Avatar do Usuário
Hi, We have worked on several excel data and macro projects. We have gone through the attached files and read the project description. We understand that you want same SKU with multiple lines to be merged into one with comma separated. We would be happy to help you with this work. Kindly contact us so that we can discuss further and start the work. Thank you.
£20 GBP em 1 dia
5,0 (10 avaliações)
3,0
3,0
Avatar do Usuário
Dear sir/madam, I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you by my quality services
£40 GBP em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Skilled in planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support to a large department. Sound knowledge of database management tools and data entry technologies.
£78 GBP em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear Hiring Manager, I have gone through your job requirement and I understand that it requires a high speed typing skill with 100% accuracy. I have 5+ years of experience working with Ms Excel and MS Office tools. I am having excellent speed with 100% accuracy. I would like to be a part of this to with all my experience on admin work.
£90 GBP em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi There, I can start right away and shall deliver the work well before time. sample files will be shared so you can check and confirm if things are moving in right direction.
£96 GBP em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
HI! I'm Milky and I can assure you I'm the best candidate for this job. I'm proficient in Microsoft office. I'm accurate and on time. Thank you for your time and consideration. I look forward to working from you soon.
£155 GBP em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I am quiet new to this freelancing site but have good knowledge about excel and macros I will be able to complete the subject work within time Looking forward to work with you Thanks.
£70 GBP em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello sir, Why would i benefit you? - I am confident about this project, I can start right now. - I have worked on this field for 6+ years. - I am good at working under pressure and with deadlines - I can work on my own, but I can adapt to be a part of the team if required - I'm a full-time freelancer and I am available to work long hours and on projects that requires working in different time zones - All my previous projects was feedback 5 stars so my service is best choice Hoping that you will review my cover letter and feedback, I am looking forward to hearing from you. Kind Regards
£135 GBP em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
We all ready Relevant Skills and Experience I am very saported excal work confidance and good experience
£150 GBP em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Sir give me this work. I can complete it at a time. Thanks Relevant Skills and Experience I m fresher
£128 GBP em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi! I'm new to this paltform but I'm not new to this kind of typing job due to my background of my work experiences. I've worked before in an Insurance Industry wherein our mostly used tools are Excel and Word. We process raw data into a processed one to be used for our selling strategy. And now I've been working in a Financial Industry where in we also processes closed banks records (those people who acquired loan to them). We typed those banks clients record in an excel as our raw data then we process into informative one which serves as our monitoring and for the profiling of the banks remaining assets. I worked in my own way (shorcuts) to make my work easier and can deliver it fast with good output.
£111 GBP em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
Milton Keynes, United Kingdom
5,0
15
Método de pagamento verificado
Membro desde ago. 4, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.