Perseverance: A Freelancer's Secret to Being Better
Jay Patkar has been a freelancer for four years now. He has worked on 300+ jobs. Now, he owns his own business and travels all over the globe.
Create macro-enabled Excel file for roster plan
As someone who values efficiency and automation, I need a proficient Python programmer to replace an existing macro that has been automating a repetitive task in my workflow. The task needs to be executed multiple times a day, hence the need for a dependable script. Here's a deep dive into what I need: - Convert an existing macro to a Python script. - The Python script should perform the same functionality as the macro, which is to automate a repetitive task. - The Python script will be expected to run on a Windows platform. Ideal Skills and Experiences: - You should have experience with both macros and Python script development. - You should have a strong understanding of repetitive task automation, and ideally have some experience in converting macros to Pyth...
Creating a macro that will perform automated filtering of the "Master" sheet and separation of data according to the PEND, Prospect and Last 15 Days statuses in separate sheets without changing the "Master" sheet. Creation of macros in sheet "PEND" and sheet "Prospect" that will remove the record if the status changes.
I'm experiencing an issue with a Macro-enabled Excel sheet. When I attempt to open the file, it closes automatically. I am in need of a professional with advanced knowledge and skills in handling Excel Macro issues. Key details include: - The Excel Sheet is not opening properly: Instead of loading correctly, the file automatically closes after I attempt to open it. - Issue presents in Excel's Safe Mode: The problem persists even when unloading all add-ins and opening Excel in safe mode. The ideal candidate for this job would have: - Extensive experience with debugging and troubleshooting Excel Macros. - A methodical approach to problem-solving. - Strong attention to detail to ensure that no related issues are overlooked. - A proven track record of resolving com...
I need a professional who can help me effectively market Excel VBA (macro) in Singapore and Malaysia. As the in's and out's of the intended audience's industry/s is not specified, a broad-spectrum approach that can appeal to a variety of sectors would be imperative. Key Responsibilities: - Implement this strategy aiming to peak interest and usage of Excel VBA The ideal candidate should: - Have proven marketing experience, particularly within the regions of interest, Singapore and Malaysia - Posses a profound understanding of Excel VBA and its potential applications
Necesito que alguien con habilidades en Excel y programación cree una macro en Excel que me permita enviar mensajes de WhatsApp personalizados, tanto de texto como de imágenes. Estos son los detalles: - La macro necesitará enviar mensajes con una frecuencia programada. Más bien, quiero poder controlar cuándo se envían los mensajes yo mismo. - Los destinatarios de los mensajes se seleccionarán a través de una columna específica en Excel. Sería ideal si el FreeLancer pudiera guiarme sobre cómo configurar y administrar esta columna. El FreeLancer ideal para este proyecto tiene habilidades sólidas en Excel y programación, y preferiblemente tiene experiencia creando macros para generar y e...
...of sales data - A proven track record in automating data reporting tasks Tasks will include: - Understanding my sales data structure and reporting needs - Designing and implementing a process to extract significant data - in this case, Revenue, from my Excel sheets - Setting up an automatic report generation mechanism This project will require a tool or macro that can generate these reports on a weekly basis, without fail. The tool or macro should be straightforward to use and should effectively sort and analyze the data to produce the desired reports, highlighting Revenue, which is a crucial parameter in my sales data. In summary, a successful outcome for this project would mean I no longer have to manually generate these weekly reports. Instead, the process would be a...
I am seeking an experienced professional, skilled in typing text, data entry, and Excel sheet preparation. I require assistance with approximately 10-50 pages of work. - The project involves both typing text and data entry tasks. Accuracy is paramount. - Furthermore, an essential part of this proje...paramount. - Furthermore, an essential part of this project is Excel preparation. This is more than just basic data entry and formatting. Adept knowledge and application of Excel macros and pivot tables is a must. Ideal candidates for this project would possess strong typing skills, a keen eye for detail, and advanced Excel capabilities, especially in the creation and utilization of pivot tables and macro functions. A strong track record for precision in data entry tasks is also ...
I'm in need of a macro expert who can help with automation in Excel. The specific tasks will be discussed more in detail once we've settled on the right freelancer, but it will involve creating macros to streamline operations. Key Responsibilities: - Developing and implementing macro scripts - Enhancing the existing process to improve efficiency - Offer solutions and improvements in the process Ideal Skills: - Proficiency in Microsoft Excel - Proven experience in developing macros - Strong comprehension of Excel functions and VBA - Excellent problem-solving abilities - Ability to work independently This project is a great opportunity for anyone who loves problem-solving and efficiency. Your contributions will make a significant impact by streamlining our operatio...
I'm in need of a macro expert who can help with automation in Excel. The specific tasks will be discussed more in detail once we've settled on the right freelancer, but it will involve creating macros to streamline operations. Key Responsibilities: - Developing and implementing macro scripts - Enhancing the existing process to improve efficiency - Offer solutions and improvements in the process Ideal Skills: - Proficiency in Microsoft Excel - Proven experience in developing macros - Strong comprehension of Excel functions and VBA - Excellent problem-solving abilities - Ability to work independently This project is a great opportunity for anyone who loves problem-solving and efficiency. Your contributions will make a significant impact by streamlining our operatio...
I'm seeking a skilled professional in influencer marketing to spearhead a campaign focused solely on Instagram. The main goal is to increase sales for my business. This project entails: - Identifying and establishing connections with macro-influencers (100K - 1M followers) - Devising and implementing strategies to harness these relationships for maximum sales growth The ideal candidate would have a proven track record in not only influencer marketing but also other facets of Instagram marketing as well. Knowledge in targeting and working with macro-influencers will be advantageous. If you have previous case studies or achievements, particularly with sales growth, it would positively impact my decision.
Hi, I require a proficient freelancer to craft a Google Apps Script (GAS) macro compatible with Google Sheets, aiming to automate the merging and synchronising of information from two independent customer databases. Specifically, the macro should flawlessly merge and compare the following items: - Names - Email addresses - Phone numbers Additionally, the macro should also handle other fields relating to both companies and individuals. These fields include plus other fields - Addresses - Job titles - Company names - LinkedIn profiles - Mobile phone numbers - Social media handles - Website URLs - Industry/Category - Segment - Personalised notes - Required actions - Plus other fields 1. This macro will automate the process of merging and comparing data from ...
Hola, Necesito una MACRO de excel que elimine eventos solapados dando así prioridad a los que comienzan primero. Eso provocará un nuevo orden en los eventos y se extraerá información útil sobre ello. Dispongo de Docx Explicativo basado en un Excel de ejemplo. Todo eso me parece prematuro compartirlo a nivel de Introducción. Lo compartiré con las personas que me muestren un mínimo de coherencia en sus propuestas. Todo es muy sencillo, por lo tanto, aquí no veo más de 80 €. Espero vuestras respuestas, gracias!
I'm looking for an experienced VBA developer to create a macro that can compare two worksheets within Excel and output the differences into a separate Excel file. Detailed requirements: - The macro should automate this repetitive task and be able to handle large data sets. - The comparison results should be exported into a separate Excel file. Skills and experiences: - Advanced knowledge in Excel and VBA Coding - Adept at handling large datasets - Previous experience with similar projects is a plus The completion of the project is urgent, so I'm looking for a freelancer who can start as soon as possible. Appreciate your interest and look forward to your proposals.
Estoy en búsqueda de un especialista en Microsoft Excel. Necesito un profesional altamente calificado en el desarrollo y configuración de macros de Excel, con experiencia en la gestión de inventarios y el uso de códigos de barras. El objetivo principal de este proyecto es crear una macro en Excel que facilite la gestión de inventarios de insumos. La macro deberá ser capaz de: - Registrar tanto las entradas como las salidas de los insumos. - Realizar cálculos de existencias para mantener un seguimiento adecuado de todos los insumos. - Implementar un sistema de códigos de barras para aumentar la eficiencia del manejo de inventario. - Configurar alertas de vencimiento de insumos y enviar un correo electrónico autom...
...content editing services. Here's what I need: - Editing and macro clean up of header, footer, table of contents and copy throughout - Installing section breaks where necessary and adding/deleting pages - copy and content editing - Editing macros for streamlined usage If you do a good job on the immediate task, I have a document library of about 20 other documents I need help with. Project ranges from creating documents from scratch using brand guide (graphic design work) and tweaking/editing already created word templates that have design issues. Since this project is urgent, I'm looking for someone who can start this assignment ASAP. Prior experience in graphic design with specific and expertise in Word template design, macro editing and content editing is e...
I need assistance in translating VBA code from a Windows version of Excel to the Mac version. The specifics are as follows: Excel Version - I am using Excel version 16.82 on my Mac. VBA Code Features - The Windows version uses worksheet formulas, conditional formatting, and data validation features. Compatibility Requirements - In the Mac version, I would love to ensure compatibility with a macro-enabled workbook, ActiveX controls, and external data sources. Ideal Skills and Experience - Excel Skilled, in-depth knowledge of VBA coding, especially in Microsoft Excel version 16.82 for Mac. - Previous experience in translating Excel VBA code between different operating systems. - Familiarity with macros, ActiveX controls, and working with external data sources is a must. The VBA ...
...primary duty of producing weekly research reports. NOT NEWS ARTICLES. As you now - macro's and narratives drive crypto. Tokens with high quality fundamentals in those macro narratives are the best performers. You must understand this, be able to find and research this, provide this in a well written research report. We are looking for someone who can produce deep dives or in-depth, highly researched reports with technical understanding. Covering important statistics, numbers, fundamentals, alpha, "out of the box" ideas and an understanding of what drives valuations and token prices. Additionally, you should know what key macro narratives are driving the markets, stay on top of this and want to find new emerging narratives or trends (be early). The in-...
Hi Hritik D. Please create macro that deletes header and rows required (also copies column A). Then prompts user to save as CSV. Will send example of original and complete file
I'm in need of an Excel VBA macro specialist to create a simple but effective tool for managing my CSV files. The main functions required for this macro are: - Delete specific rows and columns based on their index. I will specify which indexes to eliminate. - Automatically saving the updated file post deletion. The ideal candidate should have a strong know-how in VBA/macros and a distinct ability in solving problems with Excel. Someone who has a keen eye for details will be a good fit, as accuracy in eliminating the correct rows and columns is paramount. Please be ready to provide samples of previous macros you've created, specifically those that deal with CSV files. This insight into your past work will allow me to ensure you're the right fit for this proj...
I'm in need of a savvy and experienced freelancer conversant ...complex tasks such as: - Data analysis: I require help in analyzing a large dataset of over 100,000 rows. - Spreadsheet formatting: The vast data requires proper and neat arrangement for easy interpretation and understanding. - Macro development: To handle such extensive data, automated tasks need to be established. - VBA: Ideally, I would like to incorporate Visual Basic for Applications (VBA) for advanced manipulation of data and improved macro performance. So, if you're a pro in Excel, proficient particularly in data analysis, spreadsheet formatting, macro development, and VBA, you're just the one I need for this project. Your ability to handle bulky data will be a plus. Convince me ...
Column AY (PO) - XLOOKUP “Entries Invoice Lines Report“. If shipment number (column A) match with column F (job number) of “Entries Invoice Lines Report, pull the value from “Column H”. If the shipment number matches in different rows and invoice number “Column H” has different value, then pull the invoice numbers like invoice1, invoice2.
The macro is supposed to look up the item number and put everything with that part number in the Xref sheet into the green column in a table format and the same for the vehcil listing in the yellow colum.
I'm in need of an Excel whizz who possesses a strong understanding of macros and familiarity with sales data to help me automate my report generation. The project requires: - Building a macro code that takes and copies weekly sales data from different salesperson sheet and pastes to a main sheet within a click of a button - Ensuring the macro works consistently and error-free - The final report should be in the format of an Excel spreadsheet, displaying insights in an organized manner in a dashboard Ideal candidate should have: - Proven experience with Excel macros - Knowledge of sales data and how to present its details in a comprehensive manner - Attention to detail and accuracy.
I require a proficient Excel macro designer to automate data calculations. This will maximize efficiency across my entire worksheet, eliminating the need for manual calculations. - Must possess expertise in search option inclusion, enabling the macro to locate data without restriction. - Superior knowledge in Excel macro creation is highly preferred. Experience with large data sets and competency in data management will be beneficial for this project. Ultimately, I am searching for a professional who can deliver a robust automated system for my data calculations within Excel.
I’m looking to transition my dynamic and functional macro-based Excel file into a sellable product. My file primarily focuses on simplifying tasks and automating them for efficiency. I wish to develop an application that potential users can access on both Windows and Web platforms. Crucial features for this application include: * User authentication: This is paramount to ensure only legitimate and paid users can access the services. * Subscription management: A built-in system to manage both monthly and annual subscriptions. * File encryption: This feature is necessary to secure the functionality of the application and prevent unauthorized usage or manipulation. Given these specifications, expert skills in application development and understanding of subscription-based mo...
I'm facing a challenge with my excel macro not functioning as expected. The specific issue I'm experiencing is the macro just not working anymore. What I need: * A seasoned Excel specialist to debug and repair the faulty macro. Ideal Skills: * Solid experience and expertise with Excel; past experience debugging and repairing macros would be beneficial. * Good problem-solving skills; the exact purpose of the macro was not documented. * Any experience automating common tasks, performing data analysis, or cleaning and organizing data could be relevant, as these are typical macro functions. Applying: * When applying, please briefly detail your prior experience with Excel macro repair, as well as any ideas you may have as to what might be c...
Hola, necesito la macro para hacer esto: - Activador -> Contenido de la pantalla (use expresiones regulares para obtener texto) - Acciones -> Leer el contenido de la pantalla y guardarlo en el diccionario -> Establecer variable con valor de viaje -> Establecer variables de embarque y kilometraje de viaje - > Establecer variable con el valor del recorrido dividido por el kilometraje total -> Mostrar ventana emergente con el resultado de cuánto ganaré por km recorrido en esa carrera -> Tomar captura de pantalla. La macro tiene que funcionar leyendo el contenido de la pantalla en todas las situaciones, cuando la aplicación Uber Driver está abierta en primer plano y con la ventana emergente. Puede utilizar el [iniciar sesión...
I'm currently seeking a capable freelancer who is skilled in creating Google Sheets Macros for a timely project. Your task will include developing a Macro that sends email notifications through Gmail based on the date in a particular row of a Google Sheet. The email notification should be sent only when the cell value of the row matches today's date. Ideal Skills: - Proficiency in Google Sheets Macros - Strong knowledge of Gmail API for sending emails - Experience with scripts related to date-driven triggers Please note, completion of the project is needed as soon as possible. I am looking for serious bidders who can deliver within a tight timeframe. Your proven experience and ability to deliver promptly will be a definitive factor in the selection process. Bidders...
I'm looking for an experienced WordPress developer to create a recip...WordPress developer to create a recipe website that features a members-only access. Key tasks include: - Incorporating an extensive variety of recipe categories, exceeding 10 in total. - Building members-only access functionality. This should contain: 1. An exclusive recipe section 2. Member forums for interaction 3. Personalized recipe collections feature 4, Seo implementation. 5. Calorie macro counter and menu - Implementing a feature that permits members to add their own recipes with prior review and approval mechanism. Beneficial Skills: - Expertise in WordPress design and development - Experience with membership sites - Understanding of recipe websites - Familiarity with a review and ap...
I have a fully operational VB based M6 macro script for Mach3 which I'm looking to convert into a Lua based M6 macro script for Mach4. This project needs to be completed within a month. Here are the skills and experience you'll need for the job: - Expertise in both VB and Lua scripting - Experience with Mach3 and Mach4 - Proficiency in Windows operating systems - An understanding of data manipulation, user interface interaction, and hardware control is a plus Even though I've skipped the question about specifics functions of the VB script to be present in the Lua script, I would like everything in the VB script to function similarly in the Lua script once converted. The OS being used for Mach4 will be Windows.
...system which voters need to verify and confirm. 6. Voters will need to confirm again the artiste selected. 7. On confirmation, system will generate a "Thank You" message. 8. Voters will signed out. 9. Next voter will sign in at Step 3 above. 10. Organiser will restrict the number of votes based on same IP address identified. Requirements : 1. Create a Macro (Excel VBA) to auto the voting process; 2. Macro (VBA) to bypass or validate the OTP email if required; 3. Marco to bypass the "I am Not A Robot" or "Captcha" created by system. 4. Marco to bypass the restriction on numbers of votes based on same IP address. 5. To create another Marco to bypass requirements serial number 3 where only one account will be given unlimi...
I need a skilled expert in Excel VBA and macros, who can design a comprehensive operational data dashboard for me. The dashboard will focus on presenting data through interactive charts and graphs, also demonstrating robust data filtering and sorting capabilities. Key Responsibilities: - Design an efficient and visually appealing KPI dashboard for monthly reporting. - Create dynamic and interactive charts and graphs to accurately represent the data. - Implement functionalities for effective data filtering and sorting. Ideal candidate should have: - Proficiency in Excel Macros/VBA with advanced knowledge of dashboard design. - Experience handling operational data and transforming it into meaningful visualizations. - A keen eye for detail, accuracy and design aesthetics. This project re...
I am looking for a professional with solid Microsoft Excel skills to recreate an Excel page for my training guide. The job involves: - Organizing text-based content on to the Excel sheet. - Arranging the information by categories/subjects. The ideal freelancer for this project would have a strong understanding of...involves: - Organizing text-based content on to the Excel sheet. - Arranging the information by categories/subjects. The ideal freelancer for this project would have a strong understanding of Excel and be meticulous about accuracy and organization. Experience in crafting Excel-based training guides would be a bonus. This project does not require formulas, calculations, data validation, sorting, or macro automation. It’s purely about creating an organized, user-f...
I'm seeking a proficient Eplan specialist who can tailor-make my project's needs by developing specific electrical symbols and macros. Additionally, your expertise will refurbish template layouts, adding designated design structures to suit our project demands. Key Requirements: - Expertise in Eplan software - Proven experience in customizing Eplan templates - Strong capabilities in crafting electrical symbols and macros - A discerning eye for layout adjustments and the incorporation of specific design elements. Your active engagement and professional insights will contribute significantly to the advancement of our project, hence, a strong understanding of these functions is immensely crucial.
Hi Indra P., as discussed in our chat, need to create VBA macro to automate style application into a new docx
Need a simple macro script to show me missing numbers. Custom range. lets say between 1-80. Need to add a column of numbers. as an example. 60,20,51,50,26,40,8,33,55,41 71,24,12,75,80,45,63,44,5,54 24,65,19,55,1,59,36,29,51,25 43,21,31,8,46,7,52,29,12,55 9,17,53,64,69,52,43,51,72,22 3,20,26,30,39,42,49,56,61,66 The result should be displayed like this. All the missing numbers separated by a comma on one single line. 2,4,6,10,11,13,14,15,16,18,23,27,28,32,34,35,37,38,47,48,57,58,62,67,68,70,73,74,76,77,78,79
I'm seeking an experienced freelancer proficient in Jitbit Macro Recorder for a specific project focused on automating web navigation tasks within a Windows environment. **Core Requirements:** - In-depth knowledge of Jitbit Macro Recorder. - Strong background in automating tasks on Windows OS. - Experience with web navigation automation, particularly simple navigation and clicks. **Project Tasks:** -Auto clicker - Automate a series of web navigation routines to streamline repetitive browsing activities. - Ensure the automation is reliable and can handle typical web navigation tasks without constant supervision. **Ideal Skills and Experience:** - Proficiency in scripting for automation. - Previous experience with web-based automation projects. - Ability to troublesho...
...should work is that in the "G" column we have a link to the person, and in the "H" column there is a message attached to the invitation. And when I change the I column to "YES", the invitation is to be sent with this message. 2. I would like LinkedIn to return information whether a given person has accepted my invitation (you can also check whether we are currently friends). You can set a button (macro?) to check all rows. It doesn't have to be in real time. And the current status should be returned in the "J" column. 3. The last step is to send the message normally via LinkedIn (not with an invitation). The message is in field K, and if I mark "YES" in the L column, this message should be sent via LinkedIn to the contact in ...
Macro-enabled file as per instructions already received in Doc file.
Develop formula + macro to update column C
...of a well-structured Excel macro that will be responsible for manipulating my sheet's data. Specifically, the macro will focus on the task of data sorting. Here's the set of tasks that I'd like the macro to perform: - Data sorting based on respective values, systematically reordering the data to suit my specific requirements. The ideal freelancer for this project would have strong competency in Excel macros and VBA, with a proven track-record in executing data sorting through these means. An understanding of different data types and their unique behaviors is also important. Machine learning knowledge would be an added bonus, but not a must-have. I look forward to working with someone who has a strong eye for detail and organized code formatting to e...
...up. I am in dire need of a proficient Excel developer who can tackle a variety of tasks to enhance the functionality of my spreadsheets. My aim is threefold: 1. **Sophisticated Formulas and Functions** - Though I skipped detailing specific formulas or functions, my project will require in-depth knowledge and application of a wide range. Expertise in advanced functions is a must. 2. **VBA Macro Programming for Automation** - My primary focus here is on three critical areas: - **Data Entry Automation**: Streamlining the process of inputting information into the spreadsheet. - **Report Generation**: Crafting macros that can automatically generate comprehensive reports from the data. - **Data Validation and Cleaning**: Developing macros that will clean and va...
I'm seeking a skilled freelancer experienced in Excel VBA and, specifically, in doing macros. The task will involve developing a macro to manage crowded data labels in a Line chart and addressing a few automation related to a line chart in Excel.
I'm seeking a freelancer with a strong background in Excel VBA and payroll systems to update my payroll macro file crucially. This project involves enhancing the calculation formulas to adhere to the California prevailing wage requirements which are intricate and multifaceted. We already have a macro file that take timesheet and calculates regular pay/OT vs DBT per CA law **Key Updates Required:** - **Modification of Calculation Formulas:** The updates will specifically include adjustments to incorporate: - Different hourly wage rates. - Fringe benefits calculations. - Varied rates per job classifications. - Distinct holiday pay rates per job type. - Overtime (OT) calculation enhancements. **Ideal Skills and Experience:** - Proficiency in Excel ...
I'm looking for a talented developer to transform an existing Excel VBA macro, which is primarily focused on data manipulation, into a LibreOffice Calc macro. This macro is of intermediate complexity, incorporating loops and conditionals to analyse and manipulate data. Besides replicating the current functionalities, I also wish to introduce new features to enhance its capabilities. **Key Requirements:** - Strong experience in both Excel VBA and LibreOffice Calc macro development - Ability to understand and translate complex macro logic - Creative thinking to introduce new functionalities effectively - Proficiency in data manipulation and analysis **Project Goals:** - **Replication:** Accurately convert the existing macro from Excel VBA to L...
...should work is that in the "G" column we have a link to the person, and in the "H" column there is a message attached to the invitation. And when I change the I column to "YES", the invitation is to be sent with this message. 2. I would like LinkedIn to return information whether a given person has accepted my invitation (you can also check whether we are currently friends). You can set a button (macro?) to check all rows. It doesn't have to be in real time. And the current status should be returned in the "J" column. 3. The last step is to send the message normally via LinkedIn (not with an invitation). The message is in field K, and if I mark "YES" in the L column, this message should be sent via LinkedIn to the contact in ...
I'm seeking a freelancer with expertise in Microsoft Excel automation to develop a comprehensive solution for categorizing clients into low, medium, and high risk categories. The determination of the risk levels will be based on a variety of factors, including jurisdiction, industry, and media checks. This project will not only streamline our existing processes but significantly enhance our risk evaluation capabilities. **Scope of Work:** - Develop custom functions or macros in Microsoft Excel. - Automate the process of evaluating client risk based on predefined criteria (jurisdiction, industry, media checks). - Organize data efficiently to facilitate easy analysis and reporting. **Ideal Skills and Experience:** - Proficiency in Microsoft Excel, particularly in writing macros and cu...
...attached As I add additional "date: worksheets I want it to automatically flow into Email Worksheet tab. It can be either by a macro button or a formula. But needs to automatically add the data as I create new worksheets and add data. I'm seeking an experienced Excel professional to develop a macro or formula-based system to significantly enhance our data management and reporting processes. Our goal is to automate entry from existing Excel spreadsheets and to generate comprehensive reports on a daily basis. This system will serve as a critical tool for decision-making and operational efficiency within our organization. **Key Requirements:** - Develop a macro or utilize Excel formulas to automate data entry tasks, pulling information directly from our c...
Jay Patkar has been a freelancer for four years now. He has worked on 300+ jobs. Now, he owns his own business and travels all over the globe.
The EU is a huge market, and expanding there is a huge endeavour. UK, Germany and France are all typical places to start - but where next?
Excel is the most popular and helpful programs ever created. These guidelines will be of help, and give you some insight into making the most of it.