Visual Basic Jobs

Tengo u a hoja de sheets muy completa para trabajar en la que quiero que se ejecuten las fórmulas a las 00, mediante macros de un bot externo, y como consecuencia no se puedan ver las formulas por parte del cliente pero si pueda el trabajar con ella.

Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online

I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can help.

I'm using Microsoft Access 2013 and I'm looking for a skilled freelancer to help me integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels ...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I am in need of a proficient data analyst who can provide a comprehensive solution to our manufacturing workflow. The scope includes: - Developing an advanced order planning & costing mechanism specifically for our production unit. The system should be based on Excel and leverage the power of scripts and macros. - Certain features are a must-have: inventory management, production scheduling, cost optimization, and sales order management. - Following this, the mechanism will then be utilized to create a management dashboard on PowerBI. Core KPIs to be highlighted on the dashboard include production efficiency, inventory turnover rate, cost per unit produced. In addition, it should also provide a detailed overview of sales and profitability. The perfect candidate for this project sh...

I'm in need of an Excel expert with experience in Visual Basic scripts for a data extraction project. Here are the specifics I require: - Ability to handle 10-50 Excel files - Proficiency in extracting text, numeric, and date/time data - Creation of scripts for automating said data extraction Ideal candidates must have a strong understanding of Excel data manipulation and the ability to automate tasks using Visual Basic scripts. This project's success relies on your seamless extraction of diverse data types and transformation of Excel datasets into efficient, automated processes. Let's boost productivity together!

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I need help with entering simple text-based data into Excel. Additionally, I need data validation to ensure the accuracy and integrity of the data. Key Requirements: - Expertise in Excel data entry - Ability to handle simple text-based data - Proficiency in implementing data validation - Attention to detail to ensure data accuracy This is a straightforward task, but accuracy is of utmost importance. Please only apply if you have experience in Excel data entry and data validation.

Por favor, regístrate o inicia sesión para ver los detalles.

I am looking for an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business. Key Features: - Calculation of total receivables - Aging analysis of receivables - Customer-wise summary of receivables - Report by department - Aging report - Total Sales - VAT report - Report by month Specific Formulas and Calculations: - Sum - Average - Count - Xlookup Data Organization: - By customer name - By invoice date - By payment due date - By month - By department Ideal Skills: - Proficiency in Excel and experience in creating complex spreadsheets - Strong understanding of accounting principles and reporting - Attention to detail to ensure accuracy in formulae and data organization - Ability to design a user-friendly interface for ea...

I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming ...

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and...

I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of data organization and interpretation. Y...

I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming ...

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is extremely v...

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel. - Ability to understand and represent complex data structures....

I'm seeking a skilled Visual Basic developer to update our existing codebase. The primary goal of this update is to enhance the performance of the application. Ultimately, the application is used primarily by our internal employees, so ensuring seamless operation is essential. Key Responsibilities: - expericence of Visual Basic Development - Implementing upgrade - have Visual Studio 2022 higer - have MS Sql server Ideal Skills & Experience: - Proficiency in Visual Basic. - Strong experience in code optimization. - Previous work on internal-facing applications is a plus.

I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial data analysis and da...

I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding of automation principl...

I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be advanced, allowing me to set ...

I have a 30 sec mute video in hindi .I need someone who can read lip moment in hindi

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex sales data...

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

I'm in need of a professional who can create an editable PDF for me, with interdependent fields. Here are some essential details you should be aware of: - I will be working primarily on a Windows operating system, so it's crucial that the PDF is compatible and can be edited seamlessly on Windows. - The PDF will contain a mixture of text and date fields, both of which will be interdependent. This means altering one field will affect the content or visibility of another. - The PDF will consist of more than 10 interdependent fields in total. This could potentially make the project more complex, so experience in creating similar PDFs is highly desired. If you're confident in your skills and have a track record in creating interactive PDFs, especially with a similar number of f...

Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start ...

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex sales data...

As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal seek macro for my spreadsheet. Here are the details: - **Scope:** The macro's primary purpose is to automate complex calculations, which would otherwise be time-consuming and prone to errors if done manually. - **Functionality:** The macro should be capable of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros...

This project is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer master and product master. When order is saved, Reduce...

I need assistance with my Excel data. Unfortunately, I haven't specified the exact issue I'm facing. However, I'm looking for a freelancer with advanced Excel skills. Ideal Freelancer: - Should be proficient in Excel - Ability to handle a variety of data-related tasks - Strong problem-solving skills - Experience in working with large datasets Please include a detailed project proposal in your application. This will help me understand how you plan to address my data-related challenges.

I'm looking for a software that can be designed within Excel to track daily sales and present a detailed profit calculation per liter of petrol. Key Features: - Daily Sales Tracking: The software should enable manual entry of daily sales figures for accuracy. - Profit Calculation: The software should generate a detailed report on profit per liter of petrol sold. - Remining fuel in tank also show - calculate auto profit in the tank Ideal Skills: - Proficiency with Excel including advanced formula writing, data organization, and report generation. - Understanding of petrol pump operations and metrics. Note: While the project is to be developed in Excel, suggestions for potential future software integration are welcome.

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am looking for an Excel expert to help me create a custom ELO ranking system for our pool and other sports. The system should integrate seamlessly with Excel for easy data input and allow us to rank players based on their performances in these sports. We need an Excel system that will integrate with our app. We need the Excel to stand alone as a backup to our app and test the ranking system before integrating it completely into the app. The players will use a paper scorecard to record the match, and then we will enter the game information into the Excel template to track and update players' score and rankings. Ideal Skills: - Proficiency in Excel to develop complex ranking formulas - Previous experience in creating ELO ranking systems - Strong understanding of data analysis a...

I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight

I'm in need of a freelancer who is proficient in Microsoft Excel to create 3 comprehensive pro forma sheets and 4 sensitivity analysis sheets. The purpose of these sheets will be for financial forecasting, specifically in a year-by-year breakdown. Ideal Skills: - Advanced Microsoft Excel proficiency - Previous experience in financial forecasting - Attention to detail - Excellent analytical skills Please note, the project entails: - Creating 3 pro forma sheets - Developing 4 sensitivity analysis sheets - Ensuring a year-by-year breakdown for the financial forecasting - Providing a high level of accuracy and attention to detail - Adhering to deadlines with commitment If you have a solid background in financial analysis and are proficient in Microsoft Excel, please feel free to reach ...

I need help creating a CSV file or Excel data sheet. I need a professional who can assist with: - Creating a CSV file or Excel data sheet - Formatting the data accurately - Ensuring the file is easily accessible and understandable - Potentially, assisting with data input This project may require someone with a good eye for detail, data management skills, and experience with Excel or similar software. Please apply to discuss further.

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

I'm in need of an experienced Power BI expert to assist me in creating daily reports from Excel/CSV files. Key Responsibilities: - Develop daily reports using Power BI, based on data in Excel/CSV files. - Ensure that the reports are insightful, visually appealing, and easy to understand. - Provide assistance in setting up an automated process for updating the reports on a daily basis. Ideal Candidate: - Proven experience in Power BI, specifically in report creation. - Proficient in managing data from Excel/CSV files. - Capable of creating visually engaging and informative reports. - Familiarity with setting up automated daily updates is a plus.

I'm looking for a skilled Excel expert who can create a sales-focused dashboard in Excel. Key Requirements: - Data Visualization: The dashboard needs to present sales figures in an engaging and easy-to-understand manner. - Regular Updates: The dashboard should be designed to be updated monthly, so it should be able to handle new data efficiently. Ideal Candidate: - Proficient in Excel: A strong understanding of Excel's charting and graphing capabilities is a must. - Data Visualization Expertise: Prior experience with creating visually appealing and informative dashboards is highly preferred. - Attention to Detail: The ability to ensure accuracy and consistency in the representation of data in the dashboard is critical.

I need a vb.net windows application to upload a video file to youtube using google API credentials. This video will need to have a title, descriptions, and linked to a playlist.

Need a vb.net windows form program to upload a video to youtube playlist