Find Jobs
Hire Freelancers

I NEED A MACRO FOR MS EXCEL

$10-30 USD

Closed
Posted 11 days ago

$10-30 USD

Paid on delivery
I have an Excel file where the preventive and corrective maintenance services of some equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose functionality or copy the data from a specific sheet.
Project ID: 38024915

About the project

48 proposals
Remote project
Active 5 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
48 freelancers are bidding on average $25 USD for this job
User Avatar
Hello, I am an Excel expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
5.0 (517 reviews)
8.1
8.1
User Avatar
Hi, this is definitely possible, if you are interested feel free to message me so we can go over one sample together. I am available right now and i would be happy to help. Thanks, Milan
$15 USD in 1 day
5.0 (837 reviews)
7.6
7.6
User Avatar
Hi, This is very simple Macro. I can write this Macro in 1 or 2 hra and i am ready to start it now. I have strong experience in developing Excel tools with Macros to automate the daily business activities. Let me send you my previous works in chat.
$20 USD in 1 day
4.9 (493 reviews)
7.8
7.8
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$100 USD in 1 day
5.0 (196 reviews)
7.1
7.1
User Avatar
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
$20 USD in 2 days
4.9 (135 reviews)
6.7
6.7
User Avatar
Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
$30 USD in 3 days
4.8 (148 reviews)
6.2
6.2
User Avatar
Hi, With a strong background in Excel and VBA programming, I possess the skills necessary to develop and maintain the macro you require. My experience in creating dynamic and efficient solutions aligns perfectly with your project's needs, ensuring the macro functions seamlessly across duplicated sheets.
$30 USD in 1 day
5.0 (19 reviews)
5.4
5.4
User Avatar
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$30 USD in 2 days
4.8 (52 reviews)
5.9
5.9
User Avatar
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$30 USD in 1 day
5.0 (37 reviews)
5.0
5.0
User Avatar
Hello, I hope this message finds you well. I came across your project regarding the Excel file maintenance services, and I am confident that I can assist you with this task. With over 5 years of experience in data entry, research, and Excel management, I have successfully completed similar projects in the past. I have a strong background in handling preventive and corrective maintenance data, and I am well-versed in using macros to automate data transfer and deletion processes. I am looking forward to the opportunity to work with you and provide efficient solutions for your maintenance data management needs. Best regards, Md Jamrul Mia
$20 USD in 7 days
5.0 (25 reviews)
5.1
5.1
User Avatar
How are you today? I have ✅ Full Experiences in Excel Macro, Function, Formulas and VBA ✅. I read your requirement carefully and I can do your work perfectly. And I can start Your work right now. Hope to discuss with you soon. Thanks for reading my words.
$50 USD in 1 day
4.9 (2 reviews)
4.6
4.6
User Avatar
Drawing on my 12+ years of experience working extensively with Excel, I am confident in my ability to complete your project with efficiency and proficiency. My expertise in Excel includes advanced formulae, VBA/Macro, and Power Query. Additionally, I can use these capabilities without any loss of functionality when the sheet is duplicated - a critical requirement for your project. My familiarity with and skills in Visual Basic, Visual Basic for Apps, and data processing further enhance my capacity to create precise macros that meet your specific needs. By developing a customized macro, I can ensure the "copy-paste" function between sheet tables while deleting any existing data simultaneously — all at a simple click of the finish button. In summary, partnering with me guarantees not only quality but a highly efficient solution that will save significant time in managing and organizing your equipment data across different teams. Let's work together to streamline and improve your preventive and corrective maintenance processes!
$20 USD in 1 day
4.9 (72 reviews)
4.6
4.6
User Avatar
Hi there! I am expert in writing macros for MS-Excel. I have gone through your requirements and can write macro for it. Let me know if you are interested. We can discuss further in chat. Regards!
$40 USD in 2 days
5.0 (8 reviews)
3.8
3.8
User Avatar
Soy Miguel, un analista de datos especializado en Excel, Visual Basic, Power Query y Power BI. Cuento con una amplia experiencia en la creación y visualización de informes, así como en el desarrollo de macros VBA. He participado en diversos proyectos similares a lo largo de mis 6 años de experiencia como analista de datos, abarcando áreas como ventas, compras e inventarios. Puedo ofrecerte mi expertise para la elaboración de análisis detallados, informes personalizados y automatizaciones que satisfagan tus necesidades. Mi enfoque profesional se refleja en la atención minuciosa a los detalles, siempre buscando alcanzar la completa satisfacción del cliente. Si estás interesado, por favor, contáctame para proporcionarme más detalles sobre tu proyecto y así poder dar inicio a esta colaboración.
$30 USD in 5 days
4.7 (8 reviews)
3.7
3.7
User Avatar
Hey Rodolfo, I have carefully read your project description regarding the need for a macro in MS Excel to manage preventive and corrective maintenance services for equipment across different teams. To address this requirement, I propose developing a Visual Basic for Applications (VBA) macro that will automate the process of copying existing data from the selected sheet to the BDD sheet table. The macro will also handle the deletion of elements from the in-progress sheet, setting specific fields to 0 as required. To ensure the functionality remains intact even after sheet duplication, the macro will be designed to dynamically adapt to the selected sheet. This will allow for seamless operation across multiple team sheets without any loss of functionality. I am confident in my ability to deliver a tailored solution that meets your specific needs. Please initiate the chat to discuss this project further. Best regards
$15 USD in 1 day
5.0 (2 reviews)
3.0
3.0
User Avatar
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For my past work please visit https://www.freelancer.pk/u/TayyabDastgir?frm=TayyabDastgir&sb=t Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir
$20 USD in 7 days
5.0 (5 reviews)
3.0
3.0
User Avatar
With a strong background in data processing and extensive knowledge of Excel, I can confidently say that your project is completely within my wheelhouse. My experience includes working with complex spreadsheets and writing customized macros to automate processes. I understand the importance of efficiency in handling your data, which is why I'm confident I can design a macro for Excel that will not only save you time but also maintain its functionality even after duplicating sheets. So let's get started. Thanks, Arpit Garg
$20 USD in 2 days
4.7 (13 reviews)
2.9
2.9
User Avatar
I understand that you require assistance with creating an Excel macro to manage preventive and corrective maintenance data for equipment across different teams. I have reviewed your requirements and I am confident that I can develop a macro that meets your needs efficiently and effectively.
$10 USD in 3 days
4.8 (9 reviews)
2.7
2.7
User Avatar
Hello, I am eager to take on the task of developing the Excel macro for copying and managing maintenance data across multiple sheets. With my experience in VBA and Excel automation, I am confident in my ability to create a robust macro that will seamlessly copy data from the selected sheet to the BDD sheet, while also clearing the appropriate fields and removing duplicate entries. I will ensure that the macro remains functional even when sheets are duplicated, maintaining its efficiency and effectiveness across all teams. I look forward to working on this project and delivering a solution that meets your needs. Thank you for considering my bid. I am ready to get started and provide you with a reliable Excel macro. Best regards,
$10 USD in 1 day
2.3 (3 reviews)
3.3
3.3
User Avatar
I am writing to express my interest in the position of Microsoft Word & Excel Specialist as advertised. With extensive experience in both Microsoft Word and Excel, along with a proven track record of delivering high-quality work, I am confident in my ability to effectively manage the tasks outlined in the job description.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MEXICO
Santa Cruz Xoxocotlan, Mexico
5.0
1
Payment method verified
Member since May 18, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.