Visual Basic per App Jobs

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.

We are seeking a highly skilled and experienced AutoCAD freelancer to automate the creation of drawings for our distribution transformers. This includes assembly drawings, fabrication drawings, and potentially other related documentation. Our transformers are built using a modular system of components. Your primary goal will be to develop an AutoCAD-based system that allows us to: - Easily insert and arrange components from a predefined library into the main transformer design. - Easily insert new components to the predefined library. - Automatically generate accurate and detailed assembly drawings showing the placement and connections of all components. - Produce fabrication drawings with the necessary dimensions and specifications for manufacturing individual parts (We will pro...

I'm seeking an Excel expert to assist with data analysis, automate tasks with macros, and create compelling charts or dashboards. Key Responsibilities: - Help gather data - Standardize formats for the data Ideal Skills: - Proficiency in Excel, especially in data analysis, automation with macros, and creating charts or dashboards. - Experience in data collection and data cleaning, particularly in standardizing formats.

I'm seeking an Excel expert to create a financial tracking spreadsheet for me. The spreadsheet should be designed to track invoicing and payments. Key Features: - Invoicing and Payments Tracking: The spreadsheet should have sections dedicated to tracking incoming and outgoing funds. - Automatic Invoice Generation: A key feature of this spreadsheet will be its ability to automatically generate invoices. Ideal Skills: - Proficiency in Excel: The freelancer should be highly skilled in Excel, with experience in creating complex spreadsheets. - Knowledge of Financial Tracking: Experience in developing financial tracking tools is a plus. - Automation Skills: The freelancer should have the ability to integrate automation features into the spreadsheet.

I'm looking for a skilled Microsoft Word expert who can help me develop a macro to automate repetitive tasks in a document. Ideal Skills: - Proficient in Microsoft Word, especially in macro development. - Experience with document formatting. - Ability to create user-friendly templates. Your job will include: - Developing a macro tailored to my specific needs. - Ensuring the macro streamlines the formatting process and enhances efficiency. Please note, this project is focused on macro development and document formatting. Your expertise in creating templates and other related tasks will be highly appreciated and could increase the scope of our work together.

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 need a proficient Excel macros expert to help me create a customized CSV file from my Excel workbook. Key Requirements: - The CSV file needs to be tailored for import into another system. - The data to be included in the CSV file will be selected columns from the Excel sheet, not all of them. Ideal Skills: - Extensive experience with Excel macros. - Previous experience in creating CSV files for system imports.

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 and organizing data - Integr...

I'm in need of a skilled Excel macro developer who can create a macro for analyzing our sales data and generating various reports. The primary focus will be on breaking down sales by product. Ideal Skills and Experience: - Proficient in Excel and macro development - Experience with data analysis and reporting - Familiar with sales data interpretation - Capable of creating comprehensive product-wise sales breakdown reports.

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" buttons. ...

I need an experienced Excel professional to adapt a complex financial model originally designed for PC to seamlessly function on Excel for Microsoft 365 on Mac. Key requirements include: - Converting Active X controls, Macros, and Slider bars from the PC version. - Ensuring the overall functionality of the worksheet is maintained. Ideal candidates should have: - Extensive experience with both PC and Mac versions of Excel. - Proficiency in handling Active X controls, Macros, and Slider bars. - Strong background in financial modeling. Your task is crucial for my financial forecasting and planning, so attention to detail and technical expertise are paramount.

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 - Experience with SAGE300 - Abil...

I'm in need of a skilled Excel macro developer who can create a macro for analyzing our sales data and generating various reports. The primary focus will be on breaking down sales by product. Ideal Skills and Experience: - Proficient in Excel and macro development - Experience with data analysis and reporting - Familiar with sales data interpretation - Capable of creating comprehensive product-wise sales breakdown reports.

I'm looking for an expert in Excel automation to streamline my work in progress runsheet. Currently, the data is manually entered, and I need the following tasks to be automated: - Data entry - Calculations - Report generation The automation needs to handle high complexity with multiple conditions.

I need assistance in automating my Excel tasks with macros, specifically for my sales and marketing processes. Key Tasks: - Create an automation system that will streamline repetitive tasks, making my sales and marketing processes more efficient. Ideal Skills: - Proficiency in Excel and experience with macro creation - Understanding of sales and marketing processes - Ability to create an efficient automation system

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 Please note that the version of Excel a...

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

Tengo 2 Libros de Excel (en una dirección específica): uno de los excel es una tabla grande con mucha informacion sale de un software (LibroSoft) y el otro libro tiene varias tablas con diferentes categorias pero tienen campos asociados sale de otro software (LibroBeton), cada libro tiene un campo clave necesito algun scrip o app de excel o vba que pueda leer ambos libros, comparar la informacion unifircarla con estos campos que pueda comprar los campos que deberian ser iguales en cada software y adicional pueda generar un reporte con los campos personalizados y una estructura en otro excel o PDF.

I'm looking for an Excel expert to create a spreadsheet for me. This Excel file should allow me to input sales data and specify which manager a sales agent works for. Key Features: - A searchable list for selecting the manager, making it easy to find and select the appropriate person. - No need for the manager's details to auto-populate, just the manager's name will suffice. - No input validation necessary, providing me flexibility in the data entry process. Ideal Skills: - Proficient in Excel, with experience in creating dynamic spreadsheets. - Ability to create searchable lists within Excel. This project requires an individual who can deliver a simple yet effective Excel solution for managing sales data.