Find Jobs
Hire Freelancers

create excel macro, and format excel file

$20-70 USD

Terminado
Publicado hace casi 9 años

$20-70 USD

Pagado a la entrega
We need an excel expert to format excel file for us based on following condition;- You need to make duplications of column data based on following rules: For each row of data, we need 10 more duplicates made You will format the duplicates in following manner 1) column A: a) original row: nothing changes b) duplicate 10 rows: create a new number that begins with RHJGJutew1, and increase the numbers 2) column B and C: a) both original row and duplicate row are same 3) column D: a) all original and duplicate row will have value that begins with RHJGJutuyu1. Unlike Column A, the value remains same for the original and its duplicate. This value only increases for each new Row 4) column E-G: a) both original row and duplicate row are same 5) column J-K a) both original row and duplicate row are same 6) column L-W a) the values will be empty on original row. the values only show in duplicate row 7) column AG and AJ a) values are same and appear in both original and duplicate 8) column AP-CN a) values are same and appear in both original and duplicate 9) column CO a) original row: value says "Parent" b) duplicate row: value says "Child" 10) column CP a) original row: its is empty b) duplicate row: they all will have the same value that appears in column A of the original row 11) column CQ: a) original row: it is empty b) duplicate row: it has value "variation" 12) column CR: a) original and duplicate have same value "RingSize" 13) column CS: a) original and duplicate have same value "US" 14) column CT: a) original and duplicate have same value "FALSE" 15) column CZ: a) original and duplicate have same value "womens" 15) column DA: a) original and duplicate have same value "JewelOcean" 16) column DD: a) original : the column is empty b) duplicate: the value remains the same 15) column DE: a) original and duplicate have same value "CARATS" 16) column DL: a) original : the column is empty b) duplicate: the value remains the same 17) column DM: a) original : the column is empty b) duplicate: the value remains the same 18) column DN: a) orignal and duplicate: value says "designer" 19) column DR: a) original: the column is empty b) duplicate: the values change from "4.5,5,5.5,6,6.5,7,7.5,8,8.5,9" 20) column DS: a) original : the column is empty b) duplicate: the value remains "TRUE" 21) column DT: a) orignal and duplicate: value says "4.5" 22) column DU: a) orignal and duplicate: value says "9" 23) column EF-FY: a) orignal and duplicate: value remain same We want you to do this as macro, so that if we make any changes we can run macro again. i am attaching 2 files. one is original which needs formatting. this file will have more data, for now i have only put 5 rows. once i give you the project, this file will have about 3000 rows. the 2nd file is the sample file to give you an example of the finished work
ID del proyecto: 7481057

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello! None of that wold be a problem. Will begin writing the code immediately, so it's ready for you to receive when you make the decision to move forward with the project. Regards, Dobri PS: I am guessing it would be better to make the code output into another sheet rather than the source sheet, so it won't create any problems if/when you try to "rerun" as you said. EDIT: The code is ready. One question remains unclear though. For columns "D" of row-copies value it's clear it will jump from "RHJGJutuyu1" to "RHJGJutuyu3000" (300 data rows in the real case sheet), but for column "A" it's not quite clear whether it will be one consecutive list "RHJGJutew1" through to "RHJGJutew30000" (10x3000 copy rows) or it will restart at each row copies from "RHJGJutew1" again? I assumed it's the former, but still can you clarify on that?
$20 USD en 0 día
4,9 (7 comentarios)
3,0
3,0
36 freelancers are bidding on average $49 USD for this job
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$45 USD en 3 días
5,0 (566 comentarios)
8,6
8,6
Avatar del usuario
A proposal has not yet been provided
$150 USD en 2 días
4,9 (251 comentarios)
7,7
7,7
Avatar del usuario
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in VBA programming. Let me do your job first and accept my bid only after you get the results. Please contact me to discuss the details. Waiting for your messages. Best regards, Tolib Rahimov
$60 USD en 3 días
5,0 (87 comentarios)
7,0
7,0
Avatar del usuario
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$36 USD en 0 día
5,0 (255 comentarios)
6,6
6,6
Avatar del usuario
Hey, I am an expert in Excel macros as you would see in my work history here on freelancer. I can create a macro that will replicate the rows as per the guidelines that you have provided and you would be able to run it on any dataset. Look like you did not attach the sample input file. If you could do that I will write the macro in it and send it back to you. Look forward to work with you. Thank You for considering my bid. Shikha
$50 USD en 3 días
4,9 (97 comentarios)
6,5
6,5
Avatar del usuario
Hello, I can do this macro. (If you can see my Freelancer feedback.) If you have any questions I will be happy to answer. Best regards Jan Krzyzak
$55 USD en 3 días
5,0 (93 comentarios)
6,1
6,1
Avatar del usuario
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.
$70 USD en 2 días
4,8 (109 comentarios)
6,2
6,2
Avatar del usuario
Hi! excel automation is my masterpiece in my accounting field. Pleasure to help your project. Thank you so much and have a great day.
$70 USD en 3 días
4,9 (73 comentarios)
5,7
5,7
Avatar del usuario
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$45 USD en 2 días
4,9 (64 comentarios)
5,7
5,7
Avatar del usuario
Hello. I do much VBA programming as my daily work. The task looks simple, just time consuming. You seem to forget to attach the second file. So far some points of the task need clarification, but I think it won't be a problem. Best regards, Alexander.
$25 USD en 1 día
5,0 (14 comentarios)
5,0
5,0
Avatar del usuario
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$70 USD en 3 días
5,0 (48 comentarios)
4,6
4,6
Avatar del usuario
Hi, We are experts in Excel and can do this project. We can write efficient VBA macro to do the task. We can only see one file though. Could you please send us the other file. And please let us know if you want is to get engaged.
$55 USD en 3 días
4,9 (24 comentarios)
4,9
4,9
Avatar del usuario
NOTE: Except for the query I posted this is close to being done. Will wait to hear and post sample! I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC. I am available now. I am familiar with this kind of work. I am guessing it is an Amazon "flat file" or similar. I have done several projects requiring this sort of approach. Only the Sample file seemed to be there but based on that I can create a sample macro for the first 10 or 20 columns. The finished macro code will run as often as required I need you to contact me before I do that because Freelancer will not let me message you unless you contact me first
$50 USD en 3 días
4,9 (32 comentarios)
5,0
5,0
Avatar del usuario
A proposal has not yet been provided
$30 USD en 1 día
4,9 (41 comentarios)
4,4
4,4
Avatar del usuario
Hello, I have seen your project and offering my services for this work. I can start this task with immediately and can complete it within defined timelines. Completing the job with 100% accuracy and with punctuality is my first priority. I believe I would be a good contractor for this job and my first work will leads to long term working relations. Looking forward to hearing from you soon. Thanks!
$50 USD en 4 días
5,0 (23 comentarios)
4,4
4,4
Avatar del usuario
A proposal has not yet been provided
$45 USD en 1 día
4,7 (39 comentarios)
4,5
4,5
Avatar del usuario
Excel VBA macro To automate your spreadsheet It will be built in a way easy for you to modify It will be robust and scalable
$50 USD en 1 día
4,9 (6 comentarios)
3,9
3,9
Avatar del usuario
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. I am proficient in making Excel Macros and conditional formatting. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$45 USD en 3 días
5,0 (19 comentarios)
4,0
4,0
Avatar del usuario
I am Data Entry Expert, MS Word and MS Excel. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
$25 USD en 3 días
5,0 (9 comentarios)
3,5
3,5
Avatar del usuario
Dear employer.. I hope you will give me a chance to take your project. I'll finish it as soon as possible with accuracy of course. I have a team here so I think I can finish it quicker. just give me a chance and I won't disappointed you at all. Best Regards, Dwiya_rara
$50 USD en 6 días
5,0 (2 comentarios)
1,3
1,3

Sobre este cliente

Bandera de CANADA
Victoria, Canada
4,9
433
Forma de pago verificada
Miembro desde ene 19, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.