Vba exel project仕事

I'm looking for a skilled professional with extensive experience in SAP scripting, specifically within the MM (Material Management) module, to assist in extracting data for me. Key Requirements: - Automating data extraction from SAP using Excel VBA - Delivering the data in an Excel spreadsheet Ideal Skills: - Proficiency in Excel VBA - In-depth knowledge of SAP MM module - Experience in SAP scripting

I need a VBA script that utilizes Selenium to automate filling out forms on Google Chrome. The script will need to interact with various form fields, inputting custom data that I will define. Ideal Skills: - VBA (Visual Basic for Applications) - Selenium - Google Chrome Automation - Form Automation - Scripting/Programming The project requires a good understanding of how to use VBA with Selenium, specifically for the purpose of automating form filling. The successful freelancer will have experience in writing scripts that can input custom data into specific fields. This is a small project, but if completed successfully, there may be potential for further work.

I'm seeking a skilled Excel VBA developer to automate some tasks on the Fasal RIN portal. The primary objective is to streamline data entry, specifically form filling. Key Requirements: - Automate data entry to save time and improve efficiency. - Handle form filling with varying formats and structures, as the fields are mostly but not always the same. - Ideal skills include advanced proficiency in Excel and VBA coding, experience with the Fasal RIN portal is a plus. - Attention to detail is crucial to ensure that data is accurately entered, even with minor changes in form fields. Please provide examples of similar projects you've completed in your proposal. Thank you!

I am seeking an expert virtual assistant to help manage my business. The role involves Leads generation, customer service, Data entry, Wordpress management and Excel VBA tasks. Key Responsibilities: - Data entry (This is the highest priority) - Customer Service (Specifically responding to customer inquiries) - Lead Generation - Wordpress management - Email marketing (This is the most crucial additional skill) Ideal Skills and Experience: - Extensive experience as a virtual assistant, preferably within IT industry. - Exceptional customer service skills. - Strong organizational and management abilities. Tools: - Experience with other tools like Confluence, CRM, HUBspot and Slack is a bonus.

I'm looking for a skilled VBA expert to help me create a loop that can process data in my Excel worksheets. Key Requirements: - The loop will primarily be used for data processing - It will operate on various Excel worksheets - The main focus will be on accounting-related tasks Ideal Skills and Experience: - Strong proficiency in VBA programming - Extensive experience with Excel data processing - Familiarity with accounting concepts and data Please only bid if you have the necessary skills and experience to meet these requirements.

Need a coder that can make custom export code, to export values from excel to txt file. I will profide a sample txt file and excel values

I'm seeking a skilled VBA programmer to automate the process of filling a Word template with Excel data on a weekly basis. This project is for personal use. Key Requirements: - Expertise in VBA programming - Proficient in Excel and Word - Experience with data manipulation and automation The task involves: - Transferring textual data from an Excel spreadsheet to specific bookmarks in a Word template. - Ensuring the process is efficient and user-friendly for weekly updates. Ideal Skills: - VBA Programming - Excel and Word Proficiency - Data Manipulation - Automation Experience I look forward to working with someone who can streamline this process for me.

I'm looking for a developer who can create a dynamic map of the island of Aruba with all its districts. This map should be able to pull data in real time from an SQL database containing voting statistics. This map must be touch-enabled as it will be used in a large touch screen TV. when the user presses on the district it will show the details of the votes, inside...Proficiency in SQL and experience with SQL databases. - Expertise in creating Choropleth maps and understanding of color-coding for different districts. - Experience in developing interactive, user-friendly interfaces. - Prior experience with election data visualization will be a plus. note: a total of 59 locations to vote and a total of 17 districts locations and districts are all ready (all in exel with past ele...

...then can add another line to add another food). selection for one time form or multiple use form (one time form disappears from users list when completed, unless re-assigned) The form app on the phone or tablet (Samsung to start, then apple) must be able to complete the forms while offline, and once connected to internet, automatically sync the forms. option to send the form via email in ms exel format, .pdf and send to dropbox or sharepoint in both formats. notification area for when the user has a new form assigned to them. forms can be completed more than once. (intent is to use multiple forms multiple times per day), must eb able to create drafts of forms, and add the the form throughout teh day prior to submitting. must have a document tab to download and store do...

...representatives to input data via Excel while storing the data in a centralized database. We require the development of interactive dashboards using a Business Intelligence (BI) tool like Microsoft Power BI or similar. Project Scope: Develop Excel templates/forms for data entry by sales reps. Set up a centralized database to store all sales data. Implement a process to import data from Excel to the database efficiently. Create interactive dashboards and reports using a BI tool. Ensure data integrity, security, and scalability of the system. Requirements: Proficient in Microsoft Excel and VBA for creating advanced forms. Experience with database systems (e.g., SQL Server, MySQL). Skilled in using BI tools (e.g., Power BI, Tableau) for dashboard creation. Strong understan...

...maintain historical records, and provide insightful visualizations for informed decision-making. Project Scope: Create an Excel workbook with individual data entry sheets for each sales representative. Implement user access controls to ensure reps can only access and edit their own data. Develop a main dashboard that consolidates data from all reps and provides visual insights. Incorporate historical data tracking while preventing edits to past entries. Include specific features for tracking maintenance quotes and project statuses. Ensure the solution is scalable, user-friendly, and optimized for performance. Requirements: Proficient in Microsoft Excel, including advanced features like VBA macros and data visualization tools. Experience in creating interactive da...

I need a skilled professional to create custom Word VBA macros for me. These macros should be able to: - Automate formatting - Generate reports - Manipulate text The macros need to be compatible with Word 2016 and later versions. Furthermore, these macros should have the capability to interact with external data sources, specifically Excel files.

I'm in need of a professional with solid expertise in VBA and Excel to help me fix a script that was previously working perfectly for sorting and filtering, but has recently stopped functioning. The project involves: - Troubleshooting and repairing a VBA script in Excel - The script is used for data manipulation, specifically sorting and filtering. Also for downloading and displaying images. Ideal skills for the job include: - Proficiency in VBA and Excel - Experience with simple data manipulation tasks - Problem-solving skills to diagnose and repair the script Please reach out if you can assist. Thank you!

I'm looking for a professional with strong VBA skills to assist with a project involving transaction data. The primary task will be writing code to generate a detailed report from the transactional data. Key Requirements: - Write VBA code to automate the report generation process. - Use provided logic and dummy data to produce the report. The detailed report should cover: - Transaction velocity against customer name , card name, payment methods, schemes Ideal candidates should have: - Extensive experience with VBA, particularly in relation to report generation. - Strong data analysis skills. - Ability to understand and implement provided logic. - Experience with transaction data preferred but not essential. Please note, logic and dummy data will be pro...

...electrónicos entrantes. -Automatizar la generación de los documentos requeridos basándose en la orden del cliente. -Asegurar que solo se generen los documentos solicitados por orden. Requisitos Técnicos: -Experiencia en Microsoft Word y Excel, incluyendo funciones avanzadas como Combinar Correspondencia. -Capacidad para manejar tablas de Excel complejas con celdas y filas combinadas. -Dominio de macros VBA u otros lenguajes de scripting para automatización. -Experiencia en análisis de correos electrónicos y extracción de datos. -Familiaridad con herramientas de automatización como Microsoft Power Automate, Zapier o plataformas similares. Consideraciones Adicionales: -Asegurar el cumplimiento con las regulaciones de ...

Project Title: Excel Expert Needed for Relay Bicycle Team Tracker Overview: I am working with an Excel file related to a race grid for a bicycle team (attached: "BLANK_ Race Grid_Coaches "). The file tracks race predictions with color-coded blocks across multiple rows and columns. The main task is to automate counting colored sets of blocks in even-numbered rows and place the results in specific cells, AND count the number of cell with in each block, this needs to be updated in real time. Key Tasks: Count Consecutive Colored Sets: For even-numbered rows (e.g., rows 4, 6, 8, etc.), count consecutive blocks of the same color. The range of cells being analyzed spans from columns D to BK. The color reference for each row is located in column B of that row. For example, if r...

The aim is to automate (with an app?) a currently manual procedure. Using the VBA codes in 1 Excel doc “A”, transpose the data from one or more cells of this Excel “A” into the indicated cell(s) of an another Excel doc “B”.

...spreadsheets and models. Automate processes using VBA, macros, or Power Query to enhance efficiency. Analyze large datasets and create insightful reports and dashboards. Develop custom functions, pivot tables, and formulas to meet business needs. Clean, organize, and validate raw data for accurate reporting. Collaborate with stakeholders to understand their requirements and deliver solutions accordingly. Troubleshoot Excel-related issues and optimize existing workflows. Generate visualizations (charts/graphs) to communicate data trends effectively. Requirements: Proven experience as an Excel expert with a portfolio of past work or relevant projects. Proficiency in advanced Excel functions (e.g., VLOOKUP, INDEX-MATCH, nested formulas). Expertise in VBA for automation and ma...

...quickly retrieve contact information. 2. Data and Document Management & Import Requirement Analysis: Automatically import data from Excel and convert it into Word documents to make the data easier to read and organize. Technology Choices: Programming Language: Use Python with Pandas for processing Excel data, and python-docx or Word Interop API to generate Word documents. Automation Scripts: Implement VBA or Python scripts to automate the conversion process from Excel to Word, enabling batch processing of data and generating uniformly formatted documents. 3. Contact Integration & Tag Classification Requirement Analysis: Manually import contact data into Apple Contacts and automatically categorize them using tags. Technology Choices: Programming Language: For Apple Contact...

I need an Excel VBA or function that can combine multiple rows on a worksheet. There will be two variables (Column B and C) that need to be the same for the rows to combine. The data in the other columns should be concatenated into a single cell, delimited by a semicolon. Ideal skills for this project include: - Proficiency in Excel and VBA - Strong understanding of data manipulation - Ability to create efficient functions for data processing.

I need a programmer to use VBA programming to convert Latitude and Longitudes to UTM coordinates located in columns in Excel. These coordinates will then be used to insert Oil and Gas well symbols into a basemap in Autocad Map 3D. This programming is not needed in this project but rather to understand the end result. I will upload a workbook containing the spreadsheet I need converted. The Tab XYZ contains the Latitude and Longitude in Columns B and C and the UTMEasting and UTMNorthing will be in Columns D and E. A Unique Well Identifier (UWI) is in Column A and a Code to post the Oil and Gas Symbol is in Column F. This format will be consistent in all future workbooks. I tried Code from the Internet that gave an accurate UtmEasting to within a meter but the UTMNorthin...

I need a script for Excel that will color-code my data to help categorize it. SEE PDF ATTACHMENT for details. Ideal Skills: - Proficient in Excel, including VBA or other scripting languages - Detail-oriented, capable of developing a systematic color-coding scheme - Experience with data categorization in Excel Please note, the specific data to be categorized and the method for categorization will be discussed in further detail. I look forward to your bids. Thank you.

...varying datasets from a spreadsheet, and include specific customization options such as custom color schemes and different chart orientations. Key Responsibilities: - Develop an efficient and reusable Excel macro using VBA that can create Box and Whisker charts from a set of numerical data points. - Ensure the macro can handle varying datasets from a spreadsheet. - Incorporate specific customization options for the charts, including custom color schemes and different chart orientations. Ideal Skills: - Strong understanding of Excel's charting capabilities. - Extensive experience in VBA programming. - Passion for data visualization. - Ability to deliver high-quality work under tight deadlines. If you have the right skills and experience, I would love to hear from yo...

I need a straightforward PC app that calculates selling prices based on purchase costs and mark-on percentages. It should apply a selling tax, round prices to ...50p, and display the new mark-on %. The app should not be Excel-based but rather a standalone application with a simple GUI. Key Requirements: - PC-based application - Simple yet functional graphical user interface - Price calculations based on user input - Implementation of a mark-on percentage - Rounding prices to the nearest 50p - Displaying the new mark-on % Ideal Skills: - Proficiency in VBA, knowledge of its application outside Excel is a plus - Experience in developing PC applications with simple GUIs - Strong understanding of price calculation and mark-on percentage applications - Ability to create a standalone a...

Files are shared please do it as we discussed.

I'm experiencing a bug issue with my Excel database, specifically when attempting to log a new patient form. An error message appears every time I try to input a new patient. I need a professional with extensive experience in debugging VBA in Excel to help me resolve this issue. Ideal Skills: - Proficient in VBA and Excel - Experienced in troubleshooting and debugging - Familiar with database management in Excel Please provide your previous relevant experience when bidding. Thank you.

I'm seeking an experienced VBA developer to convert my existing 32-bit VBA v6 script into a 64-bit v7 compatible with Alphacam software. It is critical that the user interface elements of the current script are retained in the new version. Key Requirements: - Conversion of the existing 32-bit VBA script into a 64-bit version - Retention of all user interface elements within the script - Ensuring the new script works seamlessly with Alphacam Testing: The converted script will be tested by installing it into Alphacam and checking its functionality. Please note, there are no new features or improvements required for this project. The main objective is to ensure the script works correctly with 64-bit software. Ideal Skills: - Extensive experience with ...

...spreadsheets and models. Automate processes using VBA, macros, or Power Query to enhance efficiency. Analyze large datasets and create insightful reports and dashboards. Develop custom functions, pivot tables, and formulas to meet business needs. Clean, organize, and validate raw data for accurate reporting. Collaborate with stakeholders to understand their requirements and deliver solutions accordingly. Troubleshoot Excel-related issues and optimize existing workflows. Generate visualizations (charts/graphs) to communicate data trends effectively. Requirements: Proven experience as an Excel expert with a portfolio of past work or relevant projects. Proficiency in advanced Excel functions (e.g., VLOOKUP, INDEX-MATCH, nested formulas). Expertise in VBA for automation and ma...

I need a professional who can assist me in building an efficient database that can interact with Excel multiple times a second. The database will need to hand...permutations across 3-5 variables reliably. Key Aspects: - Database: Open to any type (SQL, NoSQL, In-Memory) - Excel Interactions: Preferably handled with Python, VBA or Power Query - Interaction Type: Primarily read queries, with potential for write operations Ideal Skills: - Proficiency in database management and design - Expertise in Excel and its interaction with databases - Strong programming skills, particularly in Python and VBA - Experience with handling large datasets Please provide evidence of your previous work with similar projects, along with a proposal detailing your approach and estimated timeline ...

Project Title: Efficient Business Process Automation for Enhanced Productivity Project Description: I specialize in designing and implementing automation solutions to streamline repetitive and time-consuming tasks, allowing businesses to focus on core activities and improve overall efficiency. Key Features: Automation of Routine Tasks: I automate various business processes such as data entry, scheduling, email handling, reporting, and more, saving time and reducing human error. Customized Workflows: Tailor-made workflows are created based on the unique needs of your business. From sales and marketing automation to administrative tasks, I ensure your processes run smoothly. Technology Stack: I utilize cutting-edge automation tools such as Python (Selenium, BeautifulSoup), P...

I'm in need of a skilled VBA programmer who can help me implement a color coding system in my Excel spreadsheet. The task involves: - Automating the color coding of specific ranges or data sets in my Excel workbook. - Using VBA to set the color coding based on a Pivot table. Ideal candidates should have extensive experience with Excel and VBA, particularly in relation to automating repetitive tasks and creating custom functions.

Description of the assignment We are looking for an Excel/VBA expert to help us create our project management tables/spreasheets under Excel by automating tasks and generating the corresponding diagrams. - Description of the project - Workstreams table with corresponding tasks - Gant and Sprint Planning - Reporting with metrics -etc.... Ideal freelancers would have extensive Excel experience, particularly in project management contexts, and be able to create sophisticated yet user-friendly, visually appealing spreadsheets.

I'm facing a problem with the barcodes generated by my ...with the barcodes generated by my MS Access database on sales order forms. They're not being recognized by our handheld barcode scanners. I need a solution to modify these barcodes so they're readable. - Current Situation: Barcodes on sales order forms generated via VBA within MS Access are not scannable. - Tools: We are using handheld barcode scanners. - Requirement: Modify existing barcode generation to ensure compatibility with our scanners. Ideal candidates for this project will have: - Proficiency in MS Access and VBA - Experience with barcode generation and scanning - Understanding of common barcode formats and their scannability We will also send you a test database, however the size ex...

I'm in need of a skilled professional to develop VBA templates for Microsoft Word 365. These templates will be primarily used for generating reports. Key Requirements: - Automation of Repetitive Tasks: The templates should be designed to streamline the report writing process by automating tasks that are frequently performed. - Formatting and Style Consistency: A major goal of these templates is to ensure that all reports maintain consistent formatting and style, which is crucial for professionalism and readability. Ideal Skills and Experience: - Proficiency in VBA programming - Extensive experience with Microsoft Word 365 - Previous work creating Word templates for report generation - Strong understanding of the principles of formatting and style consistency - Excellen...

I'm in need of an Excel expert with proficiency in VBA and macros. The primary tasks you'll be tackling include data analysis, reporting, and data manipulation on sales and inventory data. Key functions that the workbook should effectively perform includes: - Effective data analysis and reporting. Your prowess in Excel should ensure seamless interpretation and presentation of data. - Automation of data manipulation. Your skills should ease the process of handling large volumes of data, automatically organizing and adjusting it as necessary. - Specific calculations to provide inventory tracking and forecasting insights. Your expertise will help me make informed business decisions based on precise and timely data analysis. Proven experience handling similar projects would ...

I'm in need of a proficient Excel expert who can crea...spreadsheet by comparing a stock positions spreadsheet (which contains number of shares and dollar values) against a PDF file, which is a master list of stock names and identifiers. 2. Produce an XML file based on the comparison results. The macro should specifically compare stock identifiers between the two data sources. Ideal skills for this job include: - Extensive experience with Excel macros and VBA programming. - Ability to work with PDF files and convert them into usable data. - Knowledge of XML file creation. - Attention to detail to ensure accurate data comparison. Please note: The stock positions data will be provided in an Excel spreadsheet, while the master list of stock names and identifiers will be given...

Hi, I have completed several long-term VA projects for various clients, I can definitely do the same for you. I...account, communicated on a daily basis, did admin-related tasks, managed 3 ecom stores, and much more. I can do every single task you have mentioned here. I am here to build long-term relationships. Here is an overview of my skills. My English skills: Online English Tutor, fluent in both US and UK English Content writer Completed exams on freelancer Tech skills: Very good at Excel, know basic VBA too Basic understanding of HTML, CMD, Shopify, Google Merchant Center, WordPress Good with Word and PPT Tech-savvy to learn on the fly My qualifications: MBA in Finance Cleared all 3 CFA levels Bachelors in Accounts and Finance Soft skills: Punctual Organized Meet deadline...

I'm seeking an Excel VBA specialist to augment an existing Excel workbook with additional functionalities. Ideal Skills: - Proficiency in Excel VBA - Experience in creating user-friendly interfaces - Knowledge of automating tasks in Excel Please note, the existing Excel file is primarily used by employees within a company. Your enhancements should consider ease of use for this audience.

Seeking an experienced web developer for custom enhancements to our Shopify website. Key tasks include integrating a tier-based pricing system visible only to specific member levels, creating member-only pages, and embedding a custom app programmed in Excel VBA. It is essential that the freelancer has previous experience with Shopify platform customizations and can provide references of past work.

I'm seeking a seasoned Excel VBA programmer to help troubleshoot and rectify issues within my automated reporting VBA program. The program is generating runtime errors and producing incorrect outputs, which is hindering its efficiency. Key Responsibilities: - Debug and rectify runtime errors - Identify and correct instances of incorrect output - Optimize program for improved performance Ideal Skills and Experience: - Proficient in Excel VBA - Extensive experience with automated reporting programs - Strong problem-solving skills - Ability to work under deadline pressure

I am looking for an experienced professional who can assist with automating SAP for personal use, specifically focusing on inventory updates. Key Aspects: - The primary goal of this project is to automate SAP using Excel VBA macros. - Prior experience with SAP scripting and Excel VBA is crucial. - The automation will primarily focus on inventory updates, so understanding inventory management within SAP is beneficial.

I'm looking for a proficient VBA developer who can write a code for Microsoft Word. The code should facilitate the updating of existing data (specifically text) in a table via a command control button. Key Requirements: - The updates will be made using predefined text options. Ideal Skills: - Proficiency in VBA programming - Experience with Microsoft Word automation - Understanding of creating and linking command control buttons - Ability to create and manage predefined text options for updates The goal is to streamline the process of table updates in Word, improving efficiency and reducing the potential for manual errors.

...experience in 2D drafting within AutoCAD. - Automation Expert: Strong understanding and practical experience in using AutoCAD's automation tools (dynamic blocks, attributes, AutoLISP, VBA, etc.) to create intelligent and adaptable drawings. - Component-Based Design: Proven ability to work with component libraries and implement systems for efficient component placement and modification within drawings. - Meticulous Attention to Detail: Ability to produce accurate and error-free drawings that meet our high-quality standards. - Excellent Communication: Clear and proactive communication to understand project requirements, provide updates, and incorporate feedback effectively. - (Optional) Transformer/Electrical Knowledge: Familiarity with electrical engineering ...

I'm in need of an Excel expert with deep knowledge in VBA and Macro. Ideal Skills: - Proficient in Excel, particularly in VBA and Macro Small Job

I'm seeking a skilled VBA developer to create a macro for me. This macro should reorganize rows in a spreadsheet based on categories specified in a dropdown list in Column C. The exact column may change in the future. Each category should have a static header which says its name. Requirements: - The categories should be displayed in a custom order. - Each category should dynamically resize based on the number of rows assigned to it. - Each category should have a static header which says its name. Ideal Skills: - Proficiency in VBA and Excel - Experience with creating dynamic macros - Understanding of custom sorting methods

I need experienced Lisp programmer to create a Lisp file for an oil and gas geological mapping project using Autocad 2025 Map 3D. The project involves inserting multiple blocks which are oil and gas well symbols with an attribute which in this case is the unique well identifier (UWI) at specific coordinates. The coordinates are UTM Easting (x) and UTM Northing (y). I need to be able to browse to find and select the file that contains the x,y coordinate, attribute and block name. I also need to be able to specify or change the scale globally for all blocks before inserting the blocks. In the attached files the scale will be 500 for both x and y. Rotation will always be 0. The attached Excel file contains the x coordinate in column D, the y coordinate in column E, the UW...

I'm looking for an Excel VBA expert to develop a highly complex and detailed VBA macro for a personal project. Key Requirements: - Advanced Level VBA: The macro should be able to perform complex logic and integrate smoothly with other applications. - Material Requirement Planning: The macro should automate the process of planning and managing material requirements. - Excel Integration: The macro should operate within Excel. Ideal Skills: - Advanced Knowledge of VBA: Experience with complex VBA macros is essential. - Material Planning Expertise: A background in material requirement planning or supply chain management would be beneficial. - Excel Proficiency: A thorough understanding of Excel and how to integrate VBA with it is crucial.

I'm seeking a professional with advanced VBA expertise to automate the updating of sales data on my Excel dashboard. The specific metrics to be reflected include: - Monthly sales figures The ideal candidate will have extensive experience in Excel, VBA programming, and dashboard creation. Please note that there's potential for further work if this project meets my expectations. You must use the report attached and link it to the dashboard. The reports are updated monthly, so the VBA must show once the report is updated monthly, this will update the dashboard also. There is a password currently protecting the data being stored in the dashboard. Please ask for it once the task is accepted.

...Microsoft Word letter template tailored for formal business correspondence. The template should feature both a header and footer, as well as an entry form created using VBA. The form should give the possibility to users to automatically enter data in the letter and automatically insert pre-saved paragraphs and pictures in other word documents. It should adhere to a traditional and formal design style. The objective is to assist me and show me how to create the template based on a pre-existing model that I already have. Ideal skills and experience for the job include: - Proficiency in Microsoft Word - Strong Experience with VBA programming - Strong understanding of traditional and formal design principles, and Microsoft word formatting - Prior experience in designi...

I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!