Visual Basic Jobs

I need a comprehensive material master sheet for my finished products inventory. The sheet should be organized by product type and include the following details: - Product name and description - Stock quantity and location Ideal skills and experience: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in inventory management - Attention to detail and organizational skills

I need financial data on an Excel spreadsheet transformed into a pivot table. The pivot table should automatically organize the data. Requirements: - Analyze Inventory by New/Used, Age, Dollar Amounts - Group data by month. Ideal skills: - Proficiency in Excel - Expertise in creating pivot tables - Experience with financial data analysis

I'm looking for a VBA expert to create a script for a Word document that can handle multiple find and replace operations. There are more than 20 instances of find and replace needed, and they do not need to be case-sensitive. Requirements: - Expertise in writing VBA scripts, especially for Word - Ability to handle complex find and replace operations - Attention to detail to ensure accuracy The ideal candidate will provide a script that is efficient and easy to use.

Project Description: I am looking to develop an Excel-based VBA form system that integrates both invoice generation and a contract form into a single user-friendly platform. This system will streamline the process of creating, managing, and printing invoices and related contracts efficiently. Key Requirements: VBA User Form Interface: A clean, intuitive VBA form where users can input client details, purchase information, and other relevant data. Invoice and Contract Automation: Upon entering data, the system should automatically generate a professional invoice and a linked contract document within the same Excel workbook. Image Upload Capability: The form must allow uploading images on two fronts: An image related to the data (positioned on the right side of the form). An image of th...

I need assistance with an Excel file that automatically calculates data. After entering data, I want to print it onto a custom A4 form. Requirements: - Automatic calculations in Excel - Data entry (numerical, text, or mixed) - Print to A4 with a custom layout Ideal Skills: - Proficiency in Excel - Experience with custom printing layouts - Attention to detail

I need mixed data from txt and csv files converted and organized in Excel. Requirements: - Convert mixed data (text and numbers) from txt/csv to Excel - Segregate data into different columns - Maintain same column names as in source files Ideal Skills: - Proficiency in Excel - Experience with data conversion and manipulation - Attention to detail

I need a developer to code and create a merged Excel spreadsheet for nursing schedules. The data is currently in multiple Excel files. Note- the source data can also be pulled in JSON format via an API and merged with an excel template if this is easier to program or accommodate a dynamic workflow that updates changes on demand. Requirements: - Merge data into a single spreadsheet - Include: Employee names, Shifts and times, Departments or units - Identify gaps in coverage Ideal Skills and Experience: - Proficiency in Excel and data manipulation - Experience with coding for automation - Attention to detail - Background in scheduling systems is a plus

I need a macro for Outlook 365 that automates email management. The macro should be triggered from the right-click menu. The macro must perform the following actions with a single prompt: - Send a note to the email sender requesting to be removed from their mailing list. - Move the email to the junk folder. - Block the sender. Requirements: - Standard message template for the prompt - Familiarity with Outlook 365 and macro creation - Experience with VBA or similar scripting languages Ideal Skills: - Proficiency in Outlook 365 - Experience in creating and implementing Outlook macros - Knowledge of email management automation

I'm looking for a talented developer capable of crafting a tracking system using Excel (VBA) and Python, culminating in a desktop executable version of the existing program. Key Requirements: - The program should support data import/export capabilities and integrate with public APIs. - Prior experience with both VBA and Python is crucial for ensuring seamless integration and functionality. - A keen attention to detail and strong problem-solving skills are required to tackle any challenges that may arise during development. - A passion for programming and a talent for creating user-friendly applications would be highly appreciated. Ideal Skills: - Proficiency in Excel (VBA) and Python - Experience with developing desktop applications - Familiarity with public APIs - Strong attentio...

I need an Excel expert to help consolidate data from multiple spreadsheets into a single, summarized workfile. Key Requirements: - Revamp existing Excel workfile - Expertise in Formulas and Functions - Experience with data consolidation Ideal Skills: - Advanced Excel skills - Strong knowledge of formulas and functions - Experience in data consolidation from multiple sheets - Attention to detail Please provide relevant experience in your bids. Looking forward to your proposals!

I need a Queue Management System developed in MS Excel VBA. The system should allow visitors to register online with basic details and document upload. Visitor Registration: - Basic details: Name, Email, Phone Number - Document upload (PDF, DOCX) - Email confirmation with registration details and confirmation number Visitor Status Check: - Check current queue status and approximate wait time using email ID User Roles: - Admin, Team1, Team2 - Team1 sees all visitors in queue - Team2 views only their mapped visitors Core QMS Functions: - Call, recall, dispose, and hold tokens - Pass tokens to another user or team Ideal Skills and Experience: - Proficiency in Excel VBA - Experience with queue management systems - Strong understanding of user role management

I need a fillable PDF form that can be transferred to an Excel spreadsheet. This form will help me track task assignments by employee and whether they are completed on time by staff on a monthly basis Requirements: - Transferable to Excel - Fields: assigned person, case name, case claim number, Task description(4 to 5 types via drop down menu), due date of task, date task actually done. I need the ability to enter all information except task completed date and be able to go back later and add completion date. - PDF format - No notification setup needed Ideal Skills: - Proficiency in creating fillable PDFs - Excel data integration experience - Attention to detail

I need a detailed Excel sheet for efficient billing and inventory management. Essential Functionalities: - Billing Generation - Inventory Tracking - Sales Analysis Additional Functionalities: - Recording Purchase, Bank, Cash, and Expense Records Data to be Captured: - Product Details - Customer Information - Transaction History Ideal Skills & Experience: - Proficiency in Excel - Experience in creating complex, multi-functional Excel sheets - Background in finance or inventory management is a plus

I'm looking for an Excel expert to create a master file to help generate quotes for cleaning and maintenance services. The file should also assist in selecting plans based on requested services and overall square footage. Key Requirements: - Automated calculations for both services and square footage -suggests given plans based on results - Output quotes in Excel format Ideal Skills and Experience: - Advanced Excel proficiency - Experience with automated calculations and creating quote generation templates - Attention to detail and ability to understand service-based pricing

I need spreadsheets to estimate construction costs. The purpose is for cost estimation. The costs to be estimated include: - Material costs - Labor costs - Equipment costs I need help defining categories and line items for each cost type. Ideal Skills and Experience: - Experience with construction cost estimation - Proficiency in spreadsheet software (Excel, Google Sheets) - Strong organizational skills - Attention to detail - Ability to simplify complex data

I need to create a label pattern with 5 lines of data and a Data Matrix QR Code using Brady Workstation software (i7100 printer) for fiber labeling. The QR code will encode the fiber path (origin <> destination) Requirements: - Generate a Data Matrix QR code on Brady Workstation Software - The encoded information will be provided in an Excel/CSV file - Label model: THT-67-427-1.5 Ideal Skills: - Experience with QR code generation - Proficiency in handling Excel/CSV files - Attention to detail and accuracy

I'm working on a Power BI report and need help ensuring that a specific table visual displays all correct records after a date slicer or other filters are applied. Current Setup: - Power BI Desktop report with multiple visuals. - A date slicer is used to filter data across the report. - Visuals include matrix, table, and charts. Problem: - One of the visuals is hiding rows that should still be visible after the date range or other filters are applied. I want this visual to continue showing all relevant records. Deliverables: - Implement DAX, filter DAX code changes to ensure the visual always shows the correct set of records. - Make sure other visuals and slicer interactions remain functional. Ideal Skills and Experience: - Proficient in DAX and Power BI. - Experience with trouble...

I run a small winery in Niagara-on-the-Lake and need a Power BI consultant to set up and maintain reporting dashboards. Key metrics to track include: - Sales revenue - Inventory levels - Customer demographics - Merchandise - Tastings - Operational insights and forecasting Data integration required with: - WineDirect - Commerce7 (migrating in November) - Excel/CSV exports Ideal candidate should be: - Ontario-based (remote is fine) - Available to start ASAP - Open to an ongoing retainer arrangement Experience with Power BI, data visualization, and integrating with POS systems is a plus.

I need a skilled Excel expert to create a sophisticated appointment scheduling spreadsheet for medical appointments. Currently, I manage appointments on a basic Excel sheet without formulas. Requirements: - Schedule medical appointments at future dates - Incorporate automated reminders - User-friendly interface Ideal Skills and Experience: - Proficiency in Excel, especially with formulas and automation - Experience in creating scheduling tools - Attention to detail and design for usability

1. Mengerjakan tugas tentang cryptocurrency (seperti Bitcoin, Ethereum, dsb)? 2. Atau tentang kriptografi (ilmu yang mempelajari enkripsi dan keamanan data)? 3. Atau ada instruksi atau soal tugas yang bisa kamu kirimkan? Kalau kamu bisa kirimkan detail tugasnya, aku bisa bantu lebih tepat.

My team (7 people) need an Excel expert to troubleshoot and resolve a persistent data feed issue with FactSet. We are sharing a large spreadsheet on a shared drive that's not reliably operating due to frequent loss of connection - and sometimes locked screen. Key Requirements: - Diagnose and fix the loss of connection issue, which occurs multiple times a day. - Ensure the data feed operates smoothly and reliably. Ideal Skills and Experience: - Expertise in Excel, especially with data feeds. - Experience with FactSet and shared drive configurations. - Strong problem-solving skills and attention to detail. - Ability to provide a long-term solution to prevent future disruptions.

I need an expert to automate data entry in Excel. Currently, the data is being input manually, and I want to streamline this process. Key Requirements: - Develop Excel functions or scripts to automate data entry tasks. - Ensure accuracy and reliability in data processing. - Create a user-friendly interface for ease of use. Ideal Skills and Experience: - Proficiency in Excel, including advanced functions and automation tools. - Experience with VBA or similar scripting languages. - Strong attention to detail and problem-solving skills. - Ability to deliver within budget constraints.

I need a VB script tool to validate Excel files and perform column-to-column mapping. The tool should handle: Validation Types: - Data consistency checks - Range value checks - Format checks Mapping Functionality: - Column to column mapping Additionally, the tool should be able to remove passwords from files. Ideal Skills and Experience: - Proficiency in VB scripting - Experience with Excel file manipulation - Knowledge in data validation techniques - Ability to explain the tool's functionality Please provide a brief explanation of how the tool works.

I'm looking for an advanced Excel VBA developer to help with several tasks, including debugging existing code, creating new code, and optimizing performance. The current projects involve: - Data analysis - Automation The existing code is partially working, so your expertise will be crucial in identifying and fixing the issues. Ideal skills and experience: - Advanced proficiency in Excel and VBA - Strong problem-solving skills - Experience with data analysis and automation in Excel - Ability to write clean, efficient, and well-documented code If you have a proven track record in similar projects and can deliver high-quality work within budget, I would love to hear from you.

I need an Excel expert to assist with an advanced school project. The instructions are in Slovenian. Key Tasks: - Data entry and organization - Formulas and calculations - Creating charts and graphs Requirements: - Proficiency in Excel - Ability to follow specific formatting and style guidelines - Fluent in Slovenian is a plus Ideal Skills and Experience: - Advanced Excel skills - Experience with complex data manipulation - Attention to detail and accuracy Please provide examples of similar work done. Looking forward to your bids!

I'm looking for assistance with managing a mixed dataset in Excel. Key Tasks: - Data Entry: Inputting data from various sources into Excel. - Data Cleaning: Ensuring accuracy and consistency of the dataset. - Data Split/Merge: Organizing the data by splitting or merging as necessary. - Dashboard Creation: Developing a user-friendly dashboard to visualize the cleaned and organized data. Ideal Skills: - Proficiency in Excel, especially with data manipulation. - Experience in creating dashboards. - Detail-oriented with a strong focus on data accuracy. - Familiarity with handling mixed data types

I need an Excel spreadsheet to track project tasks. The spreadsheet should calculate workdays and calendar days for several tasks on the same row in different columns, and accommodate up to 60 rows. In addition, I need the ability to track task dependencies. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience with task tracking and project management in Excel - Ability to create complex formulas and manage task dependencies

I'm looking for a skilled professional to help automate a mix of data (text and numeric in mixed formats) from Excel to labels in InDesign. The Excel data is updated daily. Requirements: - Set up an automated process to pull data from Excel and update InDesign labels. - Handle mixed date formats and various data types. - Ensure the automation can accommodate daily updates without manual intervention. Ideal Skills & Experience: - Proficiency in Excel and InDesign. - Experience with data automation and scripting. - Attention to detail and problem-solving skills.

I need an experienced Excel VBA developer to help manage tasks, create reports, and compile lists of items. The primary focus will be on automating various tasks to streamline my workflow. Key Requirements: - Automate data entry, data processing, and email notifications. - Generate and manage reports based on inventory data. Ideal Skills and Experience: - Proficiency in Excel and VBA. - Experience in task automation and report generation. - Strong background in handling inventory data. Please provide samples of previous work and an estimated timeline.

I need a freelancer to automate the conversion of Autoquotes files into Excel and populate Excel with PO and invoice data. Requirements: - Convert Autoquotes Excel files and format for import: - Remove inactive lines - Add net cost column (calculated as unit next cost x quantity) - Summarize to one line Ideal skills and experience: - Proficiency in Excel - Experience with data manipulation and file conversion - Attention to detail Looking for someone who can deliver accurate and well-organized data.

I need email IDs and mobile numbers extracted from an Excel sheet. The data should be validated and provided in a CSV file. Key Requirements: - Extracts data from the entire Excel sheet. - Validates both email IDs and mobile numbers. - Deliver in CSV format. Ideal Skills: - Proficiency in Excel and data extraction. - Experience with data validation. - Familiarity with CSV file format.

Vennligst Registrer deg eller Logg inn for å se detaljer.

I need an Excel database to streamline my manual expense tracking. Currently, I input everything manually, and it's not fun. Requirements: - Standardized parameters (e.g., codes for expense categories, project codes, vendor names) - Automated feed to a clean, organized sheet Ideal Skills and Experience: - Proficient in Excel - Experience with database creation and automation - Detail-oriented and organized Looking for someone who can create a user-friendly system to simplify my expense tracking process.

I need a solution to fetch live tick-by-tick data using the Upstox API and display it in Excel. The data should automatically update. Requirements: - Input selection from Excel for indices or stocks (Nifty 50, Sensex, Bank Nifty, and various stocks). - Expiry date filtering. - Display parameters: - Price data: Open, High, Close, LTP - Volume metrics: Volume, Total OI, Total COI - Market indicators: Greeks, IV, OI, COI Ideal Skills and Experience: - Proficiency with Upstox API - Strong Excel skills, especially with live data integration - Experience in financial data handling and stock market knowledge

I need a simple, functional Excel dashboard to track contracts. Requirements: - Replicate the attached image layout. - Sections: Contract Count, Open Tasks, Pending/Expiring Contracts, Contract Amount vs Budget (Bar Chart), Donut Charts (Status, Type, Department), Contract Table (Title, Number, Vendor, Start Date, End Date, Value, Status, Notes). Formulas: - Auto-calculate: Remaining days (DATEDIF, TODAY), Expiry alerts (IF), Value usage. - Conditional formatting for deadlines/status. Interactivity: - Drop-downs and filters. - Clickable notes/links. Visuals Add-Ons: - Required: Contract Remaining Period graph, Value Consumption Rate graph. - Add more if helpful. Design: - Basic formatting (junior-style). - Editable inputs, protected formulas. - Easy to update/expand. Deliverables: -...

I need a straightforward yet functional Excel dashboard to track contracts. Key Features: - Layout with basic formatting: - Sections: Title, Number, Vendor, Start/End Dates, Value, Status, Notes - Essential Formulas: - Auto-calculate remaining days, expiry alerts, value usage - Use functions like TODAY, DATEDIF, IF, etc. - Conditional formatting for deadlines - Interactivity: - Drop-downs and filters for easy navigation - Clickable notes or links - Visuals: - Interpret data and create suitable graphs, including: - Contract Remaining Period graph - Value Consumption Rate graph - Additional relevant visuals as needed - Design: - Editable inputs with protected formulas - Easy to update or expand Deliverables: - No backdoors or hidden scripts - .xlsx file with ...

I need an Excel expert to assist with data entry tasks. This is a daily task involving data entry, formatting, and report creation. Key Requirements: - Entry of progress / budget / Actual Cost data - Formatting data into tables - Creating reports Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Ability to work on a daily basis

I need to integrate 2-5 spreadsheets. Ideal skills and experience: - Proficiency in data integration tools - Experience with spreadsheets (Excel, Google Sheets, etc.) - Attention to detail and accuracy - Ability to work within budget constraints

I need a data analyst to generate comprehensive reports from operational data. The data is currently in Excel/CSV format. Key Requirements: - Analyze operational data - Generate insightful reports - Data is in Excel/CSV format Ideal Skills and Experience: - Proficiency in Excel/CSV - Experience with data analysis and report generation - Strong analytical skills - Familiarity with data visualization tools is a plus Please provide samples of previous work and relevant experience.

I'm seeking a reliable, permanent driver to serve as my personal chauffeur. The driver will primarily operate a car and should be comfortable working with a flexible schedule. Key Requirements: - Experience as a personal chauffeur - Valid driver's license and clean driving record - Punctual and reliable - Discretion and professionalism - Ability to adapt to a flexible schedule Ideal Skills and Experience: - Prior experience as a chauffeur or in a similar role - Familiarity with local roads and traffic patterns - Excellent time management and communication skills If you have a background in driving and can commit to a flexible schedule, please bid on this project.

I'm seeking an Excel expert to automate my asset tracker for event media management. Requirements: - Make asset statuses dynamic (changeable). - Implement color coding for easy visual management. - Enable automatic content in tab movement based on status changes. Ideal Skills: - Proficient in Excel, especially in automation and dynamic features. - Experience with color coding and tab management in spreadsheets. - Attention to detail and ability to create user-friendly systems. Please provide examples of similar work done.

Busco um desenvolvedor com experiência comprovada em Excel VBA e Python para criar uma planilha automatizada de viabilidade econômica voltada ao setor imobiliário. O objetivo é facilitar a análise de novos empreendimentos, com projeções financeiras, simulações de cenários e geração de relatórios. Escopo do projeto: Entrada de dados do empreendimento (terreno, área construída, custos, vendas, cronograma etc.) Cálculo automático de indicadores: VGV, TIR, VPL, payback, ROI, entre outros Simulação de cenários (pessimista, realista, otimista) Automatizações com VBA (formulários, botões, filtros, geração de relat&...

I'm looking for a comprehensive vehicle status list to be organized on an Excel spreadsheet. The details should include: - Make and Model - VIN Number - Odometer Reading - Monthly Service (color-specific) - Service Record Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience with data entry and organization Please ensure the spreadsheet is clear, organized, and easy to update.

I'm seeking an experienced VB programmer to complete my project of cephalometric analysis, which is currently 80% done. Key Tasks: - Implement real-time data entry feature - Add a reporting module with: - Tabular reports - Export functionality to Excel/PDF Ideal Skills & Experience: - Proficiency in Visual Basic and MySQL Database - Experience with reporting modules - Strong background in real-time data processing - Familiarity with Excel/PDF export functionalities Looking for someone who can efficiently add these features and help bring my project to completion. Please include samples of your previous work.

I need an experienced Excel specialist to revise my sales forecast spreadsheets. Requirements: - Update product sales data with new sales figures. - Adjust past data for accuracy. Ideal Skills: - Advanced Excel proficiency, especially in data handling and formula correction. - Attention to detail for accurate data adjustments. - Experience with sales forecast spreadsheets is a plus.

In cell A1, enter "Number of customers without any mortgages" and calculate the number of customers without any mortgage accounts in cell B1. Hint: You will want to utilize the count command in cell B1. Formula to use =COUNTIF(Sheet1!I:I,0) In cell A2, enter "Number of customers without any car loans" and calculate the number of customers without any car loans in cell B2. Hint: you will want to utilize the count command in cell B2. Calculate the percentage of in C2 based on the 50 customers. In cell A3, enter "Number of customers without any investment accounts" and calculate the number of customers without any investment accounts in cell B3. Hint: you will want to utilize the count command in cell B3. Calculate the percentage of in C3 based on the 50 custome...

I need two Excel templates: one for staffing details and another for service user details. Staffing Details Template should include: - Employee names and roles - Shift schedules and availability - Contact information and certification status - Key dates and documents review dates Service User Details Template should include relevant service user information. Ideal skills and experience: - Proficient in Excel - Experience in creating organized and user-friendly templates - Attention to detail and accuracy

I need engaging promotional content for my pastries to boost brand awareness. This content will be shared on social media and through email marketing. Ideal Skills & Experience: - Creative copywriting - Experience in food photography - Social media marketing expertise - Graphic design skills for eye-catching visuals Please share your portfolio and relevant experience.

Title: Join Our Global Vision: Partner With Akademos University & Share in the Profits! Description: Are you a passionate developer with a vision for global education? Do you want to be part of something revolutionary? Akademos Global University is looking for a talented developer to join us in building a transformative online university that will change the landscape of education across the globe. What We Offer: 0.01% annual profit share from Akademos Global University once it begins generating revenue. Opportunity to grow with the university, as we expand across continents (UAE, Netherlands, Canada, and more). A chance to work on cutting-edge technology and be part of a global initiative. Flexible work hours, as you’ll be a key partner in the development of a groundbreak...

I'm developing an Excel-based system for managing pickleball tournament scores and team positions. I've completed the scoring computations but need an expert to enhance the system. Key tasks include: - Enhancing the scoring system - Implementing real-time ranking updates Ideal skills and experience: - Advanced Excel proficiency - Experience with tournament data management - Strong automation and formula skills Looking for someone who can finish the remaining tasks efficiently.