Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$30-250 AUD

Terminado
Publicado hace más de 5 años

$30-250 AUD

Pagado a la entrega
I am trying to automate an excel file for reporting purpose. Currently I do it manually and bits and pieces of automation which I have recorded macro, it was working fine till I had to do conditional formatting for duplicates and delete column 1 data based on duplicates. I have attached a dummy data file for your reference, when I receive the raw data, it consists of 131 columns, I recorded macro to delete unwanted columns which I don’t need for reporting. Columns in Yellow to keep Columns in Grey to delete Here are the steps, I need to perform every week on this workbook. 1. Copy and paste the Raw data worksheet from H:\ drive into macro enabled worksheet 2. Sort column 1 by A-Z 3. Use conditional formatting and highlight the duplicates in column 2 (pink color) 4. Once conditional formatting highlighted duplicates, filter them by cell color (Pink) 5. Highlight the rows in column 1 whose value = “capture & form” Delete these rows only if they are duplicates (these will be highlighted in pink color on column 2). Duplicate captures and forms are deleted in this step. 6. Delete all the columns which are highlighted in Grey, leaving only columns in Yellow. 7. Cut (Ctrl X) the left-over “capture, form and blank cells” in column 1 and paste them in sheet 2 (NFA – sheet name). This is where the macro recording doesn’t work. 8. Export/save this workbook with 2 worksheets to (closed folder in H:/drive – when automated), currently manually open the folder and paste the workbook with file name: data &Current date. 9. This is where the fun part starts: this task takes 2 to 3 days in between other jobs. 10. Column header (65 Question 20), select filter and for every item in the filter (e.g.: sort by value “A”, copy the filtered selection rows and paste in new workbook by the name “A and date” in H:\ drive folder, repeat this process for all the items in filter and save them, this could be the closed workbook for automation purpose, currently manually opened and pasted the workbook. 11. Repeat the step 10 for Column Headers (68 Question 23), (63 Question 18) and (60 Question 15) in next blank cell. 12. In the above steps copy all the “A” from column 65 Question 20 and “A” from column 68 Question 23 in next available blank cell, repeat the same process for Column Headers (68 Question 23), (63 Question 18) and (60 Question 15) in next blank cell. As you can see there is lot of manual work involved, I tried to automate bits and pieces, don’t have skills to automate whole process, trying to learn VBA. Forgot to mention, I have a Userform with buttons (this is what I used for recorded macro to sort, delete unwanted columns), this Userform is on the workbook where I copy and past the raw data sheet and work on it. If you can help with automation, it will save lot of time. Thanks in advance.
ID del proyecto: 17657139

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 6 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
$50 AUD en 1 día
4,7 (32 comentarios)
5,0
5,0
13 freelancers están ofertando un promedio de $138 AUD por este trabajo
Avatar del usuario
Hello Sir Im excel VBA macro and formula Expert :) i can do make your excel spreadsheet automaticly Sir :) please give me this job and im able to start working today Thank You Sincerely Galih AP
$100 AUD en 3 días
4,9 (306 comentarios)
6,9
6,9
Avatar del usuario
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to implement the 12 steps through VBA code. I can certainly do that. I've delivered more than 240 projects in the last 5 years and this makes me very comfortable with your task. I can deliver the project within 7 days including all required revisions for $200. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Paris Pallas
$200 AUD en 7 días
4,9 (139 comentarios)
6,6
6,6
Avatar del usuario
- Went through the Excel file having the Data Tab (I see about 131 columns) NFa Tab - Can got copied the Raw data - Can get the conditional formattting highlighting a row based on certain condition. - Removing rows that have duplicated column1 value. - Recording macro is start of the solution, and there needs to be additional customization of code, to Keep the data in Yello, and remove the columns in Grey. - Once all done copying the data a new workbook with the name of the file including current date. These steps could be automated. - Just the recent project which I completed goes through the same flow, getting raw data highlighting rows based on columns Additional analysis and filtering of data. Filtering data based on certain conditions. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
$160 AUD en 3 días
4,6 (45 comentarios)
6,0
6,0
Avatar del usuario
Hi, After reading your project description about automating the formatting of Excel sheet, I feel like you have me in mind when creating the project. I have all it takes to deliver. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
$150 AUD en 3 días
4,7 (33 comentarios)
5,5
5,5
Avatar del usuario
Hello there As an excel and VBA expert, i can develop the necessary VBA code for your automation process. Please contact me and let us discuss more on your project. Thanks
$100 AUD en 3 días
4,9 (50 comentarios)
4,9
4,9
Avatar del usuario
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$120 AUD en 3 días
4,8 (44 comentarios)
4,7
4,7
Avatar del usuario
I can help you perfectly to automate all the process as needed. let's start....
$200 AUD en 2 días
5,0 (9 comentarios)
3,8
3,8
Avatar del usuario
Hi, I am fast and Extremely Detailed Oriented. I can do a great work for you and ensure your complete Satisfaction. I understand the value of deadline. if you are not satisfied You do not need to pay a penny. Thank You.
$90 AUD en 3 días
5,0 (1 comentario)
1,6
1,6

Sobre este cliente

Bandera de AUSTRALIA
Australia
0,0
0
Miembro desde ago 28, 2018

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.