Vba progamming işler
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I need an Excel macro develop...Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human r...
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data...row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user-friendly interfaces within Excel for ease of customization by the end user w...
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by us...project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible...
I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
...Responsibilities: - Automating repetitive tasks within the Excel spreadsheets, to increase efficiency and accuracy. - Customizing the spreadsheets to better suit the specific requirements of my business. I have a specific deadline for this project, so it's important that you are able to work efficiently and effectively within the given time frame. Skills and Experience: - Proficient in Excel and VBA - Experience in spreadsheet automation and customization - Strong communication skills to understand and implement my requirements - Ability to deliver within a set deadline - Previous experience in similar projects would be a plus. If you're an intermediate Excel developer with a solid understanding of automation and customization, I'd love to hear from you. Pleas...
I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deliver eff...
I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...
I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...
I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.
Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:
Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks
I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, please reach out and explain your approach.
I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.
I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions
I'm in need of a developer adept at using Visual Basic for Applications (VBA) within Excel to scrape exchange rate data from the web. Key aspects of the project: * The focus is on extracting textual content and tables from exchange rate websites. * The specific data to be extracted includes: * Currency codes * Exchange rates * Date and time Ideal candidate's skill set: * Proficiency in Excel VBA with a focus on data extraction from the web. * Familiarity with financial and exchange rate data is a plus. * Ability to implement robust error-handling processes within the script. * Clear communication and timeliness. I look forward to engaging with a knowledgeable freelancer who can fulfill these requirements promptly.
I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files
I'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.
As an individual who has taken the first steps towards digitizing data management, I am seeking a proficient Android developer who can transform my existing Excel-based userforms into an enticing Android appl...- A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, experience in database sync technologies is a must. All in all, a successful candidate should demonstrate ample experience in Android application development, a knack for intuitive UI/UX design, and familiarity with data syncing between Android and Excel. While the knowledge of VBA isn't required, it could be advantageous to understand the context of the userforms better. Let's enhance the usability of our userforms and bring this vision to the fing...
As a beginner in Excel and VBA Programming, I am actively seeking an experienced and knowledgeable tutor who can guide me on the journey to developing structural analysis software. I am reckoning on an efficient and in-depth learning experience tailored around my unique learning pace and style. Key Objectives: - Understand Basic to Advance VBA coding and its application in Excel - How to implement complex algorithms in VBA - Grasp of data analysis functions and graphical interface capabilities in VBA Ideal Tutor's Profile: - Qualified tutor with solid and demonstrable grasp of VBA and Excel - Proven experience teaching VBA with commendable patience and understanding - Proven experience developing structural analysis software will be a plus ...
I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.
I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA
I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already...
...talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. • Previo...
I need to automate the creation of tasks and subtasks in Microsoft Planner from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable ...
I'm in need of an expert in VB/VBA development to assist with my software solution, primarily dealing with a scale system for a food company. Understanding Macola software would be highly beneficial. The core focus will be on: - Error fixing in current functionalities when they occur like label printing and commimocation errors - Developing and integrating new features into the system - troubleshooting errors as there arent many but I need the person to be able to support US EST (East coast US) hours The exact errors to address are not currently available, but a strong analytical mindset will be crucial in tackling this project. The ideal candidate should be knowledgeable in VB/VBA, demonstrate solid problem-solving skills, and have experience working with Macola softw...
...of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate: The ideal candidate should be an exper...
I am looking for an Excel expert who can set u...a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the count in the dashboard the sample file for problem solving. Ideal skills and experience: - Expertise in Excel: A deep understanding of Excel's functionality and the ability to customize it to meet specific requirements. - VBA programming: Experience with VBA programming is a plus as it will be needed to create the custom formulas and set up the automation. - Automation: Proven experience in automating tasks within Excel and making processes more efficient. - Attention to detail: It's crucial that data is handled accurately and that the formulas are correctly implemented to ...
I need a proficient Python developer to create a stock and options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet...
I am trying to fetch ebay api token. Code works in php but not in vba
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a proficient Microsoft Word VBA expert. Your responsibility will be: - Automating repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is def...
I'm seeking a seasoned developer for an advanced VBA application. This application should principally assist in data analysis, while also automating routine tasks. The exact tasks that need automation include data import/export and manipulation. Key Requirements: - Development of a VBA app with a robust data analysis feature - The app should automate data import/export and manipulation tasks The application should also be capable of seamlessly integrating with various software tools. While Microsoft Excel and Access are a given, the ability to integrate with other tools is also vital. Having experience working with a variety of software packages is a considerable advantage. Skills and Experience Required: - Proven experience in VBA development, particularly ap...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
Data Organize and Analyze Excel VBA guy with Data Analysis skills.
I am looking for an expert who can customize Excel sheet navigation to meet my specific needs. The successful candidate should be able to create an Excel sheet that: - Moves to the right when I press 'Enter' for the first time - Moves to the left and then down when I press 'Enter' again - Allows th...my specific needs. The successful candidate should be able to create an Excel sheet that: - Moves to the right when I press 'Enter' for the first time - Moves to the left and then down when I press 'Enter' again - Allows this unique navigation pattern to loop without the need for any additional keyboard inputs Skills & Experience Required: - Proficiency in Excel functionalities - Experience in VBA coding for Excel - Good attention to deta...
I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...
...dot com failed, due to a tenant isolation policy for tenant cd75b7dd-4b48-44bd-72e7-e143a22c8mrd. If your use case requires a cross-tenant connection, contact your tenant administrator. Details: Connection owner tenant:" Another option I was thinking of could be finding a way within Microsoft Outlook to simply automate syncing of events from CompanyA to CompanyB by copying the events over using VBA or some Outlook add in, but I am open to any and all workable solutions. Also Company A has limited access to the Google Calendar connector as well. This was a working solution in Power Automate a year ago as well, but they limit the use to Google Calendar connector"... I get an error related to "Data Loss Prevention Policy". ***NOTE I am not an administrator on ...
I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your
