Vba exel project jobs

...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!

I'm looking for an experienced Excel and VBA expert to help me update my Excel program. The purpose of this update is to match the output of getting a technical datasheet printed from a Notepad file. Key Tasks: - Revise the current Macros and VBA coding to improve functionality - Adjust the Data layout and formatting for optimal output The ideal candidate for this project should have: - A strong background in Excel, particularly with Macros and VBA - Experience with Data layout and formatting - Skills in Data extraction and organization - Proficiency in integrating Automated calculation into Excel from other data sources Your role will also involve incorporating specific features from the Notepad file into the Excel program, which includes: - Extracting ...

I'm looking for a skilled programmer to create a macro in Microsoft Word. The primary task of this macro will be to format documents, making my work more efficient and consistent. Ideal Skills: - Proficient in VBA (Visual Basic for Applications) for Word macro development. - Experience with Microsoft Word. - Strong understanding of document formatting principles. Please provide examples of similar projects you've completed. Thank you.

I'm seeking an Excel VBA expert to implement conditional formatting using rectangles in my spreadsheet. - Task: You will need to code a system where rectangles change color based on specific text in the cells. These need to change when the data is sorted, so they move with the sorted data. There will be up to 100 per sheet and d three sheets, so I am looking for simplified code that can handle this. I have a sample file already finished that does what I want. I just need the code simplified. - Ideal Skills: Advanced Excel, VBA coding, and experience in implementing conditional formatting. - Requirements: You should be able to understand and interpret the conditions I want to trigger the formatting. All the work that needs to be done is on sheet1 with the "COPY&q...

I need an experienced Excel and VBA professional to create an Excel Addin named 'Design Blank Menu'. This Addin should enhance the user interface of Excel by adding Design Sheets to the Excel Menu Bar. Key Requirements: - Expertise in Excel and VBA - Experience in developing Excel Addins - Ability to improve user interface of Excel The Addin should also automate tasks by integrating design sheets into the menu, making it easier for users to access these tools. Ideal Skills and Experience: - Strong knowledge of Excel functionalities - Proficient in VBA programming - Previous experience in Excel Addin development - Excellent understanding of user interface design principles.

I'm looking for a skilled VBA programmer who can help me automate a report in SAGE300. The process involves: - Accessing the Intelligence Reporting > Report Viewer > Receivable Reports > Customer Aged Trial Balance - Running the report and entering the necessary parameters - Saving the resulting Excel file in a specified folder NOTE: YOU MUST HAVE PROVEN EXPERIENCE IN SAGE300 VBA REPORT GENERATION This project requires basic automation of the steps provided, with no need for advanced data processing or intricate Excel formatting. I'm currently using SAGE300 2021 and the macro doesn't need detailed error handling or logging, just simple error messages will suffice. Ideal skills for this job include: - Proficiency in VBA programming - Ex...

I need a simple tool that can generate numeric-only item codes of a fixed length and store them in a Database in Excel. Requirements: - Macro VBA - The item codes should be numeric only. - They should be of a fixed length. - The length of each item code should be 4 digits. - they cannot be duplicated Ideal Skills: - Proficient in Excel. - Experience in database management. - Knowledge of numeric code generation. -

Description: We are looking for an experienced Excel VBA/macro developer to build an automated data import system for a master spreadsheet. This system will handle CSV imports from multiple sources, automate data matching, and perform calculations based on the data. Project Overview: We previously utilized separate macros to import data into spreadsheets, but now require an integrated solution that consolidates the functionality of two existing macros, while adding the ability to import data from two additional CSV reports. The project involves importing data related to sales quantities, stock deliveries, and stock counts into a master sheet, using buttons to initiate the process and applying specific data validation rules to prevent errors. Key Responsibilities: St...

I need a skilled VBA programmer to create a macro that generates a timeline view in a PowerPoint template from data in Excel. The macro should be able to: - Create swimlanes for each stream and tasks - Update shapes based on ShapeID and data from "taskdata" -Once the shape postion manuallly changed the update menthod needs to update the shape position based on taskdata The timeline view will be primarily used for project management overview. The swimlanes should be organized according to the streams in the "taskdata" tab. Ideal skills for this project include: - Proficient in VBA programming - Experience with Excel and PowerPoint integration - Understanding of project management concepts - Ability to visualize data effectively Plea...

My project involves streamlining the SAP processes for increased efficiency. The focus is on automating the MB52 stock dump and the creation of purchase requisitions using ME51N. Currently, the most time-consuming aspect is the creation of purchase requisitions, and I need this automation to run daily. Skills and Experience: - Proficient in SAP scripting - Experienced in creating and integrating VBA Macros - Strong understanding of SAP processes, specifically MB52 and ME51N - Ideally has a track record of successful SAP process automation

I'm seeking a VBA expert to develop a code for my Excel spreadsheet. I need a searchable customer service record list. The code should allow me to input letter(s) and output all records related to those letters.

I'm looking for an Excel macro that can merge multiple Excel files into a single one and convert it into the required format. The merged file should include all data and sheets from the source files. The final output should also be in Excel format. I have provided you the required format with so...macro that can merge multiple Excel files into a single one and convert it into the required format. The merged file should include all data and sheets from the source files. The final output should also be in Excel format. I have provided you the required format with source file formats. Strict dead line is required to complete the work. Ideal Skills and Experience: - Proficient in Excel and VBA - Experience in creating macros for data processing - Attention to detail for accura...

I need a skilled VBA programmer to create a macro for me in Excel. The macro should solve a circular reference problem caused by formula dependencies in my spreadsheet. - Purpose: The macro should be able to balance two numbers anytime they change with a plug. Ideal candidates would have: - Extensive experience with Excel and VBA programming. - A strong understanding of formula dependencies and circular references. - Ability to create efficient and reliable macros.

I'm in need of an experienced VBA developer who can assist me in building a comprehensive inventory management system. Core Functions: - Adding new items to the inventory - Monitoring and tracking stock levels - Generating detailed reports on inventory status Key Features: - Notifications for low stock situations Ideal candidates should be proficient in VBA with a strong understanding of inventory management systems. Experience in developing similar systems in the past will be highly regarded. Please note that while the project does not currently include features such as barcode scanning or e-commerce integration, I am open to discussing these if they can add value to the project.

Looking for a dedicated VBA expert to help me automate tasks and help develop Excel buttons as part of a personalised toolbar. Scope is basic VBA but I need efficient code to automate about 5-7 processes. Will need to sign an NDA. Exploring rate of $10-20 p/h, total 30-40 hours

I'm looking for a VBA coder to help me with an Excel macro file. The file is primarily used to show the forecast and actual measurements of electricity power plants. Key Requirements: - The VBA code should perform trending analysis based on the provided forecasted electricity demand. - The data inputs for the analysis will be from an Excel spreadsheet containing the forecasted electricity demand. Ideal Skills: - Proficiency in VBA coding and Excel macros. - Experience in performing trending analysis. The successful freelancer will be able to help me better understand the trends in electricity demand and thus improve the forecasting accuracy.

I'm looking for a seasoned VBA professional who can help automate the process of report generation in Excel. While I haven't specified a particular type of report, it is crucial that the freelancer is able to work flexibly and create a solution that can be adapted for various report types. Key Responsibilities: - Design and implement a VBA macro in Excel to automate report generation. - Ensure the solution is user-friendly and can be adapted for different types of reports. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in automating report generation. - Ability to create flexible and adaptable solutions. - Excellent problem-solving skills.

I'm looking for an Excel expert to help me automate some tasks in my spreadsheet. Specifically, I need assistance with automating calculations, particularly statistical ones. Ideal Skills and Experience: - Proficient in Excel coding and VBA - Strong understanding of statistical calculations - Experience in automating tasks in Excel - Ability to streamline processes for efficiency