Find Jobs
Hire Freelancers

VBA in Excel | Combine all sheets into one page + conditions

$40-75 AUD

Terminado
Publicado hace más de 5 años

$40-75 AUD

Pagado a la entrega
Hi there, Looking to have a freelancer update an Excel document's VBA script to provide better outcome. Attached is file (see 'Master_Contact_List' tab), which combines all sheets into a single page. Hoping to have the below achieved for 'Master_Contact_List' tab: #1 Only use columns A-J from other sheets (not collect entire sheet) #2 Have predefined heading and heading columns in master page (right now it is duplicated as copied from each sheet) - this includes new columns that show sheet's name. #3 Where a name appears within a sheet, write 'Yes' under that column #4 Where a name appears in more than 1 sheet (match with first_name and last_name), please show 'Yes' under the sheet's name in these new columns. #5 Only display distinct values (remove duplicate names) #6 Display the master contact list sheet with no additional formatting / colours. Please write 'Master_Contact_List' in your response so I can confirm you have read this brief. I look forward to receiving your bid.
ID del proyecto: 18266526

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 5 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
Master_Contact_List HI, I am good at Excel and vba. I have referred the requirements. Looking forward to work on the project to transfer the data between sheets and discuss in the chat. -Chandra
$75 AUD en 0 día
5,0 (791 comentarios)
7,9
7,9
11 freelancers están ofertando un promedio de $72 AUD por este trabajo
Avatar del usuario
Hello, Hope you are doing well. I can help with you in your project VBA in Excel | Combine all sheets into one page + conditions. I can assure you the quality job. I have good experience in Excel, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$180 AUD en 4 días
4,9 (285 comentarios)
7,6
7,6
Avatar del usuario
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
$66 AUD en 10 días
4,9 (57 comentarios)
5,6
5,6
Avatar del usuario
I am an IT professional with 2 decades of experience. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple excel with formulas to complex power pivots with macros with ease.
$66 AUD en 10 días
4,9 (24 comentarios)
4,6
4,6
Avatar del usuario
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$77 AUD en 2 días
4,9 (29 comentarios)
4,8
4,8
Avatar del usuario
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
$50 AUD en 10 días
5,0 (15 comentarios)
3,6
3,6
Avatar del usuario
Hello How are you? I have reviewed "VBA in Excel | Combine all sheets into one page + conditions" .I have good skills for these (Excel, Visual Basic, Visual Basic for Apps). 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. I hope to work with you. Thank you.
$70 AUD en 1 día
5,0 (7 comentarios)
3,7
3,7
Avatar del usuario
Dear Recruter As a VBA developer, I have been busy the past few years, designing, analyzing, and developing new VBA applications – with a difference. My experience in this regard is quite vast. Over 4 years of experience in maintaining and improving existing VBA applications, as well as reverse engineer current macros by debugging and stepping through code, makes me an excellent person to consider for a VBA developer position at your company. As a highly analytic and organized individual, I can proactively clarify and question business requirements, in relation to system capabilities. Moreover, these skills help me in effectively analyzing and converting business requirements to develop VB applications, and perform well-placed object oriented designing and analysis. Owing to the fact that I am a diligent individual, I can perform testing work in an exceptional manner, aiming for optimal performance.
$63 AUD en 1 día
4,9 (8 comentarios)
3,5
3,5
Avatar del usuario
Master_Contact_List Hi Good Day! A serious freelancer here! I can help you to complete this project in less than 1 day. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$50 AUD en 0 día
5,0 (16 comentarios)
3,5
3,5
Avatar del usuario
"Master_Contact_List" Hi, I will be able to complete this task in quick time. My experience will be of great help for you in optimizing or completing other daily office tasks as well. General Profile Information: Also,I am 12 yrs Experienced in Excel,Python,Php, Office/web Automation & blogging on Office Tricks & tips. I work full time in here & will be able to start your work immediately. Services Provided: 1. Excel Macro (VBA) - Web Scraping & Automation 2. Python - Web Scraping 3. Excel Pivot Charts & Tables 4. Excel Auto Filter, Vlookup, Formula Assistance 5. Excel to Access 6. Sending Email from Excel 7. Extract Data from Webpages Please drop a message once you feel comfortable with my profile & lets get started. Thanks for your time
$45 AUD en 1 día
4,6 (10 comentarios)
2,6
2,6
Avatar del usuario
I can do the work and deliver exceptional results. I possess a combination of skills and experience that make me stand out from the crowd. regards, Yasmina
$50 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
4,9
68
Forma de pago verificada
Miembro desde ene 15, 2012

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.