Find Jobs
Hire Freelancers

I NEED A MACRO FOR MS EXCEL

$10-30 USD

Mbyllur
Postuar 23 days ago

$10-30 USD

Paguhet në dorëzim
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.
ID e Projektit: 38024915

Rreth projektit

48 propozime
Projekt në distancë
Aktive 16 days ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
48 profesionistët e pavarur ofrojnë mesatarisht $25 USD oferta për këtë punë
Avatari i Përdoruesit
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 në 1 ditë
5,0 (517 përshtypje)
8,1
8,1
Avatari i Përdoruesit
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 në 1 ditë
5,0 (837 përshtypje)
7,6
7,6
Avatari i Përdoruesit
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 në 1 ditë
4,9 (493 përshtypje)
7,8
7,8
Avatari i Përdoruesit
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 në 1 ditë
5,0 (196 përshtypje)
7,1
7,1
Avatari i Përdoruesit
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 në 2 ditë
4,9 (135 përshtypje)
6,7
6,7
Avatari i Përdoruesit
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 në 3 ditë
4,8 (148 përshtypje)
6,2
6,2
Avatari i Përdoruesit
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 në 1 ditë
5,0 (19 përshtypje)
5,4
5,4
Avatari i Përdoruesit
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 në 2 ditë
4,8 (52 përshtypje)
5,9
5,9
Avatari i Përdoruesit
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 në 1 ditë
5,0 (37 përshtypje)
5,0
5,0
Avatari i Përdoruesit
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 në 7 ditë
5,0 (25 përshtypje)
5,1
5,1
Avatari i Përdoruesit
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 në 1 ditë
4,9 (2 përshtypje)
4,6
4,6
Avatari i Përdoruesit
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 në 1 ditë
4,9 (72 përshtypje)
4,6
4,6
Avatari i Përdoruesit
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 në 2 ditë
5,0 (8 përshtypje)
3,8
3,8
Avatari i Përdoruesit
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 në 5 ditë
4,7 (8 përshtypje)
3,7
3,7
Avatari i Përdoruesit
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 në 1 ditë
5,0 (2 përshtypje)
3,0
3,0
Avatari i Përdoruesit
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 në 7 ditë
5,0 (5 përshtypje)
3,0
3,0
Avatari i Përdoruesit
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 në 2 ditë
4,7 (13 përshtypje)
2,9
2,9
Avatari i Përdoruesit
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 në 3 ditë
4,8 (9 përshtypje)
2,7
2,7
Avatari i Përdoruesit
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 në 1 ditë
2,3 (3 përshtypje)
3,3
3,3
Avatari i Përdoruesit
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 në 7 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i MEXICO
Santa Cruz Xoxocotlan, Mexico
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga maj 18, 2020

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.