비쥬얼 베이직 Jobs

I'm in need of a Google Sheets expert to help me troubleshoot and enhance my current sheet. Key Tasks: - Fixing errors in existing formulas - Creating new, complex formulas The primary focus areas for these formulas are: - Data analysis and reporting - Project management Ideal candidates should be well-versed with Google Sheets, have a strong analytical background, and be able to create intricate formulas.

I'm in need of a dynamic excel sheet that will assist in managing the daily and weekly activities of our vehicles. This sheet should be able to track various aspects such as: - Maintenance schedules: Keep tabs on when each vehicle is due for maintenance. - Fuel usage: Monitor fuel consumption over time to identify any discrepancies or patterns. - Trip logs: Record details of each trip for future reference. The ideal freelancer for this project should be highly proficient in Excel and have experience in creating dynamic, interactive spreadsheets. They should also have an understanding of vehicle operations and be able to incorporate relevant features into the planner. Key features of this planner should include: - Automated scheduling: The sheet should be able to automatically sche...

I require an Excel expert who can help me create complex data lookup and reference formulas. Specifically, I need assistance with VLOOKUP and HLOOKUP.

I've converted my inventory book into an Excel spreadsheet. I'm looking for a freelancer who can upgrade this into a more sophisticated, user-friendly inventory system, with specific features and improvements. Key Features: - Automated stock updates: This will assist in keeping track of the inventory in real-time, without needing manual input. - Real-time analytics: I want to have insights and statistics about my inventory at my fingertips. - User access controls: I need to manage who can see and interact with different parts of the inventory. Interface Preference: - The upgraded system should have a spreadsheet-like interface. I am comfortable with Excel, and a familiar interface would make it easier for me to adapt to the new system. Areas for Improvement: - The most crucial...

I'm looking for a skilled developer who can work with Visual Basic and Crystal Reports for a project. Ideal Skills: - Proficiency in Visual Basic - Experience with Crystal Reports - Strong problem-solving skills - Ability to understand and implement complex requirements - Good communication skills

I need assistance with combining two Excel sheets. The task is to transfer values from column 2 of the source sheet to column 2 of sheet A. The values are a mix of numbers and text, and they are jumbled in the source sheet. Key Tasks: - Discussion on handling duplicate entries in column 2 of the source sheet - Converting all values to text in the destination sheet - Discussion on how to manage blank or missing values in column 2 of the source sheet Ideal Skills and Experience: - Proficiency in Excel - Excellent data management skills - Ability to discuss and devise solutions for data handling issues Please note that certain aspects of the project, such as how to handle duplicates and missing values, will require discussion.

I need assistance with combining two Excel sheets. The task is to transfer values from column 2 of the source sheet to column 2 of sheet A. The values are a mix of numbers and text, and they are jumbled in the source sheet. Key Tasks: - Discussion on handling duplicate entries in column 2 of the source sheet - Converting all values to text in the destination sheet - Discussion on how to manage blank or missing values in column 2 of the source sheet Ideal Skills and Experience: - Proficiency in Excel - Excellent data management skills - Ability to discuss and devise solutions for data handling issues Please note that certain aspects of the project, such as how to handle duplicates and missing values, will require discussion.

I am looking for a professional who can develop an algorithm for options trading. The algorithm should specifically implement grid orders with trailing stop loss. The ultimate goal is to automate my trading process while maximizing potential profits and minimizing risks. Key Requirements: - Extensive knowledge and experience in options trading - Proficient in algorithm development - Familiarity with grid trading strategies - Experience with implementing stop loss mechanisms - Ability to integrate with Profitmart broker via API Skills and Experience: - Strong background in financial markets - Proven track record in algorithmic trading - Excellent programming skills - Experience with Profitmart broker - Ability to deliver a user-friendly and efficient trading algorithm

I have two Excel sheets, A & B. My primary requirement is to delete all the email addresses from Sheet A that are not in Sheet B, along with the entire corresponding row. The ideal freelancer for this project should have: - Strong proficiency in Excel - Experience with data manipulation and cleanup - Attention to detail Note: Sheet A's headers can be adjusted, but those of Sheet B must remain unchanged.

Main Features: BGA Data Monitoring: The application displays data related to BGA tests in a table format. Table columns include: OrderNumber: The test order number. LIS_REG_NO: The registration number in the Laboratory Information System (LIS). RETRIEVED_FLG: Data retrieval status (possibly "1" or "0" to indicate a specific status). OrderItemName: The name of the test item, such as "BGA NOVA". OrderDateTime: The date and time the order was created. Additional Information: At the bottom, the application displays: Data refresh interval, e.g., "Refreshing Grid: 4s". Current date, row count in the table, and error status (e.g., "Error: No Error"). Control: A "Matikan Alert" button (translated as "Turn Off Alert") is avail...

I need a custom Google Sheets formula that can help me identify the locations of exact word matches within a given text. and copy the text in a row accordingly

I'm seeking a proficient Excel expert to develop a comprehensive spreadsheet for me. This will have separate sheets for each semester, allowing me to log and visualize my classes from both the past and the future. Key Features: - Input fields for Class Name and Code, Grade, and Credits for each course - A summary section that totals all credits earned - Additional creative features that enhance the usability of the spreadsheet - Creative problem-solving skills to suggest and implement additional beneficial features Ideal Skills: - Advanced Excel proficiency with demonstrated experience in creating complex spreadsheets - Strong understanding of educational tracking systems Please bid if you can deliver an efficient and user-friendly tool that will help me keep track of my academic j...

I have some VBA code that is intended for data manipulation, but it's currently producing incorrect data output or calculations. The data this code is working with involves mixed data types. I'm looking for a freelancer with strong VBA skills who can troubleshoot this code and fix the issues. Ideally, you should be able to: - Understand and modify existing VBA code - Diagnose and fix issues related to data output and calculations - Work with mixed data types Experience with data manipulation and troubleshooting VBA code is necessary. Please include relevant examples of your past work in your bid. Will send a copy of my code and an explanation of what I am trying to accomplish upon selection of a freelancer.

I'm looking for assistance with managing some publication data in Excel. I have two sheets of data that I need help with. Ideal Skills and Experience: - Proficiency in Excel - Experience with data management - Attention to detail I need to see if the PMID that is on Sheet 2 is on Sheet 1 and I need to see if the PMID on Sheet 1 is on Sheet 2. A simple lookup should do the job

I'm looking for assistance with managing some publication data in Excel. I have two sheets of data that I need help with. Ideal Skills and Experience: - Proficiency in Excel - Experience with data management - Attention to detail I need to see if the PMID that is on Sheet 2 is on Sheet 1 and I need to see if the PMID on Sheet 1 is on Sheet 2. A simple lookup should do the job

I'm looking for assistance with managing some publication data in Excel. I have two sheets of data that I need help with. Ideal Skills and Experience: - Proficiency in Excel - Experience with data management - Attention to detail I need to see if the PMID that is on Sheet 2 is on Sheet 1 and I need to see if the PMID on Sheet 1 is on Sheet 2. A simple lookup should do the job

I have a complex Excel file that functions like an application and I need it converted into a fully-fledged web application. This app, using VBA, gathers data from our web-based CRM system and utilizes it to schedule projects. The key requirements for this project include: - **Data Gathering from CRM:** The application must seamlessly pull live data from our CRM system. This is a critical aspect of the project. - **Project Scheduling:** The app should replicate the project scheduling capabilities of the current Excel file. - **Automated Updates:** One of the major frustrations with the current system is the need for manual refreshes. The new application should update automatically, eliminating this need. Ideal candidates for this project should have extensive experience in web applicatio...

I'm looking for a freelancer skilled in Excel to help consolidate market data from 20-25 spreadsheets. Each spreadsheet has 6 tabs, but all are uniform in format. The task involves: - Manually consolidating the data into one tab of a new Excel file - Sorting the data by specific dates Please note, all source spreadsheets follow the same consistent format. The ideal candidate for this task should possess: - Strong proficiency in Microsoft Excel - Excellent attention to detail - Ability to adhere to timelines This project is perfect for someone who enjoys data work and is looking for a straightforward task.

I'm looking for a skilled software developer to implement a PC utility tool specifically designed for system optimization. This tool should include various features to enhance the performance of the computer. Key Responsibilities: - Develop a utility tool that optimizes system performance - Implement features like a registry cleaner, disk defragmenter, and a performance monitor Ideal Skills: - Proficiency in PC application development - Previous experience with utility tool development - Strong understanding of system optimization techniques Please provide examples of similar projects you've completed. Bids without relevant portfolio pieces will be ignored.

I want to list a product using sp-api in VBA. You must have your own credentials for development

I'm seeking a seasoned professional in Microsoft Access to help with the creation of data entry, search and navigation forms, as well as summary, detailed and dashboard reports. Key Responsibilities: - Design and implement user-friendly data entry, search and navigation forms. - Create comprehensive summary reports, intricate detailed reports, and interactive dashboards. Ideal Skills: - Proficiency in Microsoft Access with a focus on form and report creation. - Experience in designing user-friendly and efficient database interfaces. - Expertise in constructing intricate and insightful reports. Your work will greatly enhance the usability of our database and the clarity of our reports. Please attach samples of your previous Microsoft Access work in your proposal.

I'm looking for a skilled Excel Add-In developer to create a tool that automates various tasks in Excel. Key Features: - Automation of tasks such as data import/export, report generation, and data validation. Requirements: - The Add-In needs to interact with external databases. Ideal Skills: - Proficiency in Excel Add-In development - Experience with database connections - Strong understanding of task automation within Excel Experience in developing similar tools will be highly regarded. Please include examples of your previous work in your proposal.

As a small retail store owner, I'm looking for an Excel expert who can help streamline my product labelling process. Currently, I'm using an application that creates a single label at a time, which is consuming a lot of my time. I need a custom Excel sheet that can generate labels with a barcode, product name, and price from my invoice Excel. The sheet should create labels for all different products from the invoice, in the specified quantity. Key requirements: - Proficiency in Excel, with experience in creating custom sheets for specific tasks. - Understanding of retail labelling requirements. - Ability to incorporate barcodes into the Excel sheet. - Experience in creating label formats of custom sizes. Please note, I will not require additional information on the labels apa...

I need an Excel specialist to refine my existing payroll template. The task involves adjusting formulas, formatting cells and adding new functionalities to improve efficiency and usability. Please bid only if you have experience with Excel.

I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation

I'm in need of an Excel spreadsheet designed for analyzing operational metrics. The primary functionality of this spreadsheet should be to allow me to input price data and subsequently identify the cheapest option by the kilogram. This project is perfect for someone with a strong background in excel

I'm looking for a Visual Basic 6 expert who can help me with a simple program. I have a data File from a music program that I think is coded with Visual Basic 6. (File attached) It contains a playlist that I think is a object saved to the file. Your task is to code a visual basic 6 program that opens the file and loads it to a sblist object, and displays the playlist. There should also be a button that saves the list in same format as the original file. No other functions is needed, since I will use your code for other project. Thanks in advance!

I need a proficient excel/google sheets expert to create an interactive sales performance dashboard for me. The dashboard should be able to: - Filter data, design important fields - Reflect important KPIs - Allow multiple users to edit without losing formulas, i prefer google sheets as multiple people need to enter data without loosing formulas. The dashboard will initially be used in google sheets, with an aim to eventually upload data to visual software such as Tableau or PowerBI. (not in this scope) Key Requirements: - Must include a sorting option for date range and geographic regions - Should reflect performance KPIs in interactive graphs/tables etc Please review the sample data I have shared. Prior experience with dashboard creation and performance KPI metrics preferred.

I'm looking for a talented freelancer to create a Power Automate flow for renaming my PDF files stored on OneDrive. The new names should be sourced from a specific column in an Excel sheet. Key requirements: - Develop a Power Automate flow that correctly identifies each PDF file and matches it with its corresponding row in the Excel sheet - Apply the new naming conventions as specified in the Excel sheet Ideal candidates will have: - Strong expertise in Power Automate and Excel integration - Proven experience in automating file management processes If you're efficient, detail-oriented, and can ensure seamless operation of the flow, I'd love to hear from you!

I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge

My Windows program, which reads from an MYSQL database, works flawlessly on my computer. However, after transferring the program files to another computer, I encounter a problem. Even though I've installed MYSQL on the new machine, there seems to be a setup issue. - The issue: The program fails to connect to the database on the new computer(?), displaying a 'ODBC driver manager - data source name not found and no default diver specified' error. - MySQL version: The new computer is running 'MySQL 8.x'. I require an expert to connect to the new computer and assist in diagnosing and resolving the connection issue. Your skills should include: - Proficiency in MYSQL setup and troubleshooting. - Experience with Windows operating systems. - Ability to clearly communica...

As a middle-class family person, I'm keen on enhancing my English writing skills through online learning. I'm looking for a professional language tutor with a strong background in teaching English writing. The ideal candidate should be patient, understand the nuances of teaching non-native speakers, and can provide structured lessons tailored to my learning pace and style. I would appreciate a tutor who can make the learning process engaging and interactive.

I'm seeking a professional who can set up a system that fully automates the updating of my investment portfolio Excel sheet with the daily NAV values from a specific website. Currently, I access the NAV values through manual browsing. This project requires: - Creating an automation system that fetches the daily NAV values from the website without any manual intervention on my part. - Updating my Excel sheet with the fetched data. The ideal freelancer for this project should have extensive experience with web scraping, Excel automation and ideally has worked with investment portfolio data before. The aim is to have a seamless process where my Excel sheet is always up-to-date with the latest NAV values. Please note that the specific format of the daily NAV value on the website has no...

I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.

I'm looking for a Google Sheets expert to help me automate data entry using checkboxes on a mobile device. Specifically, I need assistance with: - Using checkboxes as buttons for data manipulation (add, delete, edit) on a sheet - Implementing the onEdit function to trigger these actions when checkboxes are edited This project requires a deep understanding of Google Sheets scripting and experience with data entry automation. If you're proficient in creating scripts that can streamline this process for me, I'd love to hear from you!

I need a skilled programmer with expertise in SQL and Microsoft Access to maintain an existing program if needed design, develop, and maintain SQL database structures and queries for a desktop application. Key Features: - Custom Reports: The application should be able to generate custom reports based on data analysis and requirements. Ideal Skills: - Proficiency in SQL and Microsoft Access: The programmer should have extensive experience working with these technologies, particularly in designing and maintaining database structures and queries. - Application Development: The ability to design and develop a desktop application is crucial for this project. - Data Analysis and Reporting: Skills in data analysis and generating reports are necessary to create the required custom reports. ...

I'm in need of a customizable Excel template specifically designed for project management. This template should allow a user to input a project name and its go-live date, and in response, automatically populate all related deadlines, legal references, and resources. Please note, I will populate the actual document with the data, but require a fully functional template with adjustable formulas. Key Requirements: - The template must include deadline formulas that populate fields based on the proximity of the go-live date, taking into account: - The year (i.e., the year prior, odd years, etc.) - The number of days (i.e., 45 days prior to go-live, 60 days prior to go-live, etc.) - The month and/or day of the week (i.e., first Friday in August prior to go-live, second Thursday in Ju...

The following software does NOT work with the latest version of Windows 11 version 24h2 and is no longer in active development. Previously for Windows 10 there was a workaround to add to the root folder to make the software work again, however in the latest version of windows (Windows 11 24h2) this workaround no longer works. I have included a link to the software and file also here: HS SOFTWARE: DLL FIX: sometimes chrome will block the download, but this contains nothing harmful. I am looking for someone who can make this work in this version of windows. I do not have access to the source code of this application.

I am looking for a proficient Excel expert to design an Audit Tracker for me. This tracker will manage and monitor up to 50 separate audits. The tool should be capable of tracking both corrective and preventative actions as statistics. It should also present a live stats dashboard that displays the progress of all audits, current outstanding audits, and their respective progress. Key requirements: - The tracker should be able to identify and reflect audit trends for the year as audits are added. - The dashboard should include visuals primarily in the form of bar charts. - Additional information to be displayed on the dashboard includes: audit completion rate, monthly audit trends, and audit compliance scores. Ideal skills for this project: - Advanced Excel skills, including knowledge of ...

I'm seeking a proficient software developer with experience in creating color matching software specifically tailored for product manufacturing and quality control in the paints and coatings industry. Key Features Required: - Color accuracy analysis: The software should be able to assess the precision of color matches. - Automated quality checks: The software should incorporate quality control measures to assess the color consistency throughout the production process. - Custom color palettes: I need the ability to create and save unique color sets for specific projects. - Create color formulas from scratch: The software should have the capability to generate original color formulas based on given parameters. Ideal skills and experience for the job include: - Proficiency in software...

I need an Excel expert to create monthly reports for my crockery and cutlery inventory. Sales Report: - Should include total revenue. Inventory Report: - Should include sold items and quantities. Sold Items Breakdown: - By category (e.g., crockery, cutlery). The ideal freelancer for this project would have extensive experience in Excel and data analysis, with the ability to create clear, concise reports. Familiarity with inventory management and sales reporting would be a plus.

Its urgent...I'm preparing for a finance interview and need an advanced Excel sheet that I can use to demonstrate my skills. The Excel sheet should be able to handle budget and forecasting data, and it should include the following features: - Pivot tables and charts: These should be used to summarize and analyze the data efficiently. - Advanced formulas and functions: I need the sheet to incorporate complex calculations to showcase my understanding of Excel. - Data visualization and dashboards: The sheet should be able to present the data visually, making it easier to understand and interpret. The ideal freelancer for this project should have extensive experience in creating sophisticated Excel spreadsheets, particularly for the finance sector. They should be able to create a sheet ...

I'm seeking a skilled Excel expert to troubleshoot and repair my complex Excel workbook. The issues primarily pertain to intricate multi-step formulas affecting the entire workbook. Post-repair, I would appreciate a detailed walkthrough of the fixes implemented. Ideal Skills and Experience: - Proficient in Microsoft Excel, particularly complex multi-step formulas - Strong troubleshooting and problem-solving skills - Excellent communication skills for clear explanations

I need an Excel-based master file to allocate components/parts to various work orders. The file should indicate which work orders have sufficient stock and which ones are short. Key requirements: - The master file should be in Excel - It should include automated functions using formulas (no macros required) - It should focus on the allocation of components/parts Ideal skills and experience: - Proficiency in Excel, particularly with creating and using formulas - Experience in supply chain management or inventory control - Ability to create user-friendly, organized files for tracking purposes.

I need a Power Automate flow created that will monitor an Excel sheet for license expiry dates and send out notification emails when a license is nearing its expiry date The flow should be triggered by: - The expiry date on the license, which will be located in column H of the Excel sheet. The flow will use: - The expiry date column (H) to identify the licenses that are nearing their expiry date. When a license expiry date is detected, the flow should: - Send a notification email. With the name in column B The ideal freelancer for this project should have: - Proficiency in Microsoft Power Automate and Excel. - Experience in creating automated email notifications from Excel data. - Understanding of license management and expiry tracking.

I'm in need of an Excel expert to create a dashboard that links information from 2-4 external workbooks. The external workbooks contain data related to tracking our key performance indicators (KPIs), specifically focusing on operational efficiency. Key Requirements: - Link 2-4 external workbooks to a central Excel dashboard - The external workbooks contain data on production output and employee productivity Ideal Skills: - Proficient in Excel, particularly in creating dashboards and linking workbooks - Experience with KPI tracking and understanding of operational efficiency metrics - Attention to detail to ensure accuracy in data representation and tracking This project will enable us to effectively monitor our operational efficiency, providing us with insights necessary for making...

I'm looking for an expert in Excel who can help me build a comprehensive spreadsheet to track my business expenses from multiple sources including bank accounts, credit cards, and receipts. Key Features: - Daily updates: The spreadsheet should be designed to accommodate daily expense tracking. - Duplicate charge detection: The system should help identify duplicate charges automatically. - Note-taking: I need to be able to record notes directly in the spreadsheet. - Categorization: All expenses need to be categorized so I can sort and see total costs for different categories over different time periods (time periods should be customizable). Ideal Skills: - Proficiency in Excel: You should be extremely comfortable with Excel and be able to create complex formulas and functions. - Att...

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizació...

I'm looking for a PowerShell script that can open Microsoft Teams and make a call to a specific account. The script should log into Teams automatically using credentials stored within the script. If Teams is already connected, it should bypass the need for credentials. Key Requirements: - The script should create a CSV file with details of the call after each attempt. Ideal Skills: - Proficient in PowerShell scripting - Experience with Microsoft Teams automation - Knowledge of creating and manipulating CSV files in PowerShell. Please note, the credentials for the Teams account will be stored in the script.

I'm seeking an Excel expert to create a comprehensive budgeting and forecasting tool. The tool will need to accommodate: - Expense & Revenue tracking - Expense & Revenue forecasting using drivers The data will be manually entered, so the interface needs to be user-friendly, with clear instructions for inputting data. The ideal candidate will have: - Extensive experience with Excel, particularly with creating complex spreadsheets for budgeting and forecasting - A strong understanding of budgeting and planning - Proficiency in creating and implementing Excel macros The end goal is a robust, easy-to-use Excel file that will help me keep track of my finances and forecast future expenses and revenues.