As the initiator of this project, I'm on the lookout for an intermediate-level VBA specialist. I am looking for someone who have Finance background, While the specific tasks were not laid out, the hired freelancer should be comfortable with various activities, including but not limited to automating data entry, generating reports, and creating macros. The key skills and experience required include: - Proficiency in Visual Basic for Applications (VBA) programming language. - Ability to automate tasks, create macros, and produce reports using VBA. - Demonstrated experience in a similar role or project. Please highlight your experience in your application. Remember, your ability to showcase your skills and past success in this area will significantly imp...
VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on
I am looking for a freelancer who can make moderate changes to my VBA software in Excel. Here are the details of the project: Type of software: VBA in Excel Function or feature: I do not have a specific function or feature in mind for the software, but I am open to suggestions. Level of customization: Moderate changes are needed for the software. Ideal skills and experience: - Strong proficiency in VBA programming in Excel - Experience in customizing and modifying existing VBA software - Ability to suggest and implement improvements to enhance the software's functionality and usability
VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on
Primero, recibo los pedidos a través de WhatsApp. Luego, transcribo los nombres de los pedidos en un documento de Excel. Utilizo una macro VBA en Excel para generar archivos individuales para cada nombre listado en el documento. Estos archivos se crean a partir de una plantilla base llamada "libro ". Una vez generados los archivos, los protejo manualmente uno por uno utilizando un programa externo. Finalmente, adjunto cada libro de Excel protegido a los respectivos contactos de WhatsApp. Estoy interesado en automatizar este proceso y me gustaría explorar diferentes propuestas para lograrlo. Próximamente, compartiré un video detallando el proceso actual a través de un mensaje directo. puede ser web, que funcione tambien con el cel...
The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the open-source version of (free!). Screenshot attached. We need this macro within a week. So please only bid if you can work on this now. In your bid, please mention "within-a-week". Sorry about that, we need that filter to avoid all the spam bids.
I'm looking for an individual with proficiency in...and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and addresses, item descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data processing, and automation...
I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.
(USA Position Only) Hey there! I'm Jaden, a freelance designer specializing in Tradeshow Graphic design. I prioritize client happiness above all else. With my workload reaching its limit, I'm seeking a junior designer to join me on this exciting journey. Are you an aspiring graphic designer ready to kickstart your career? Join me and dive into the world of Tradeshow Graphic design! I'm offering an opportunity for entry-level designers to grow alongside me, delivering top-notch designs and ensuring client satisfaction. Details: Pay: $15-25/hour Workload: 5-10 hours/week, with potential for more Perks: Bonuses for completed projects and potential for a long-term contract While experience is a plus, what's most important is your ability to understand a brief and meet d...
I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.
...sales per share as the key underlying variables. Furthermore, you must build the spreadsheet so that the user can enter information for up to a minimum of 5 stocks. You should populate the input section of the spreadsheet with data from at least five stocks from a sector of your choosing. Ideal Skills and Experiences: - Extensive financial modelling experience - Knowledge of stock markets and investment - Familiarity with current market trends Application Requirements: - To stand out as a candidate, detailed past work within this specific field is necessary. Show me practical examples where you developed similar financial models. Minimum requirements: 1) A dashboard that allows the user to... 리 b ...enter company-specific information collected from Yahoo Finance or ...
Hi Need to send and receive e-Mail from G-Mail. Need to use oAuth2
check reference image, excel insert row & copy the value from above row
I am attaching a file that includes the current output with notes. You can see yellow highlights as to what needs to be corrected in the existing code. Then I need a second macro to output data into the DoD_merge template. I added notes to that docunment.
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring data from PDF to Excel.
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
Seeking a Reality Show Style look for poster image. These are salon workers. We want a VH1 Reality Show look to the company poster image. I really like the group photos. And try to add: DSC00398N (photo), DSC09980 (photo), and DSC00042 (photo) faded or however you see fit. TITLE IS: "BEYOND THE CHAIR”
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and can deliv...
...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...
I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bon...
...description of the database. The specific responsibilities include: - Developing 3 types of queries: Data extraction, data modification, and data calculation (specific instructions will be provided after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. ...
I'm organizing a cabaret show and require a front-facing seat selection interface for guests to choose their spots. There'll be 50-100 attendees, so the developed tool must be robust and user-friendly. We'll use mixed tables for the seats arrangement. These will need to be sent to guests as a link and the selection sent back as a response to the email Ideal Skills & Experience: - Event planning - User interface design - Coding expertise - Experience with seating arrangement software designs. Key Requirements: - Design user-friendly interface. - Ensure capacity for 50-100 guests in the seat selection system. - Include both individual seats and mixed tables. - Incorporate an option for food and beverage selection. - Deliver a working tool with minimal bugs. ...
I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirment carefully before bidding....
...updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your recommendation. Famil...
...market research - Appropriate valuation for token launch - Coordinating investor outreach While the specific expertise needed isn't pinpointed, a broad range of macroeconomic, financial modelling, and data analysis skills are suggested. The successful freelancer will show initiative by providing information about their past work, experience and their proposed approach. Please include these in your application: - A showcase of your previous token launches or similar projects - In-depth understanding and experience in macro economics and financial modelling - Demonstrated capability in data analysis - A detailed project proposal outlining your approach for market research, token valuation, and investor outreach The most suitable candidate will hav...
I'm seeking a proficient developer to create a macro screen recorder specifically for corporate websites. This tool should automate repetitive tasks majorly involving mouse clicks, and should also support recording of keyboard inputs. Key Requirements: - Proficient understanding of website functioning, especially corporate sites. - Strong skills in programming languages relevant to macro recorder development. - Capable of integrating both mouse click recording and keyboard input recording. - Ability to test and guarantee the functioning of the tool on corporate websites. Your primary focus should be reliability and efficient performance of the macro.
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).
I need an innovative graphic designer to create a retractable banner for use at trade shows. The primary purpose of the banner is to increase brand awareness. Therefore, the design should prominently feature elements such as our company logo, specific product images, and key phrases or our tagline. The ideal candidate will have significant experience with marketing and visibility strategies, and a history of eye-catching design for trade shows or similar events. Previous work with brand awareness is highly beneficial.
I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid
More details: Which programming language are you more comfortable with? C# or Python or AI What is the level of understanding or background do you have in the chosen programming language? Advanced What type of data are you looking to extract from the website? Contact information, Registration details, Company profiles The website: Is the regulator for estate agents in the UK. They hold information on al estate agents. I would like a script or console app r automated way (could be AI) of extracting all the UK estate agents from this website. I need their sector, address, phone number and name and website. Thank you
I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.
...sheet) Botón "Entregar": Debe haber un botón "Entregar" en el sistema. Al presionarlo, se deben activar acciones automatizadas relacionadas con la gestión del pedido. Integración con Excel: El sistema debe poder asignar automáticamente las credenciales y detalles del pedido a un libro de Excel. Esto incluye información como el nombre del cliente y el código del pedido. Automatización con VBA: Ya que utilizo VBA en Excel para manejar estos procesos, el sistema debe ser compatible o integrar esta automatización para facilitar la transición y el mantenimiento. Subida Automática a Google Drive: El sistema debe ser capaz de subir automáticamente el libro de Excel generado...
I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power...
Some record is not showing in table. But data is in db
...ANNUALE" sheet which shows some personal data and some characteristics of the users of a service. The data is entered into the sheet through a userform called "userform1". The data entered through userform 1 are always recorded in the main "CEL ANNUALE" sheet Among these data are: - an "insertion date" field which concerns the date on which a user was added to the service. - a "resignation date" field which reports the date on which a user concluded the service. In addition to the "CEL ANNUALE" sheet there are 12 other sheets called "CEL 01-24" (which refers to the service status as of January 2024), "CEL 02-24" (which refers to the service status as of February 2024) and so on with t...
necesito una macro que sea capaz de hacer una tarea sencilla: volver el menu de un juego (sería el boton de atrás), darle a "Jugar" y a "aceptar". Esta tarea la debe hacer presionando un botón flotante.
I need a skilled IT professional to handle my network hub and server management issues. Your responsibilities would include: - Server management: Delve into the intricate details of server operation, configuration, and routine maintenance, focusing on a Windows operating system. - Network hub management: Macro-level management of the network hub, ensuring seamless interconnectivity and performance. - Troubleshooting & maintenance: Prompt identification and resolution of issues related to the server and network hub, ensuring optimal uptime and reliability. - Security enhancement: Develop and implement strategies to fortify the security of my servers and network hubs preventing unauthorised access or potential attacks. Key skills include extensive experience in Windows server...
Hi Irfan. I'm in need of a new logo for a new show. I just invited you to bid on the project. You think we could do it for $250 this time? Also, are you new to Canada? I thought you were elsewhere in the world?
I need a logo for my musical comedy show, "Works In Progress". It focuses on the concept of 'Works In Progress', symbolized by gears and tools. Your design should embody a blend of vibrant colors and metallic tones, with imagery of gears, tools, and musical elements incorporated. Ideal candidates will have experience in graphic design and an understanding of modern satire. Excellence in logo design and the ability to translate concepts into visuals is crucial. Attached is the main image that will be used for the poster.
I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible with Microsoft E...
...columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your detailed proposals!...
...production, I am seeking a professional who can: - Generate moderately realistic AI locations and characters for a talk show. It's important to strike the balance between realism and a visually engaging aesthetic, meaning they don't necessarily need to be highly authentic, but still need to keep viewers engaged. - Lead the AI scriptwriting process, populate the stage with AI algorithm-based casting, and manage the editing. The ideal freelancer for this job should have: - Extensive experience in AI technology, specifically in film scripting, casting, and editing. - A track record of producing visually appealing and engaging content. - A strong understanding of the talk show genre, including its conventions and audience expectations. Let's push the bou...
I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgen...
I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.
More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data
...regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data input - Implementing error-checking measures to ensure data integr...
More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data
