Visual Basic Jobs

As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.

Power BI Data Link with MS Project I'm looking for a Power BI expert who can help me link my Power BI dashboard with multiple MS Project files. Key Requirements: - Create a link between Power BI and multiple MS Project files - Enable data extraction and integration from these multiple MS Project files Ideal Skills and Experience: - Proven experience in Power BI dashboard creation - Strong understanding of data analysis - Previous experience in linking Power BI with MS Project files

vb 2012 video and sound recorder. Auto record to file when motion/sound is detected. Auto save file if no motion/sound is detected for 5 seconds. exe File must be compact and small and not dependent on other dll or ocx. Auto detect existing cam and video device on PC. I should be able to compile it on my PC. Note there are a lot of samples on Chat GTP.

I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. ...

I need a skilled freelancer to convert several Excel spreadsheets into interactive PDF files, preserving the original Excel formatting. The converted PDF files should retain all functionality, including interactive components such as forms or clickable links. Ideal Skills: - Proficiency in Excel - Expertise in PDF conversion with interactive elements - Exceptional attention to detail to ensure formatting preservation Experience Required: - Extensive experience in converting Excel to interactive PDFs - Proven track record of working with similar projects from the past - Familiarity with handling complex Excel formatting.

I'm looking for a Power BI expert who can help me link my Power BI dashboard with multiple MS Project files. Key Requirements: - Create a link between Power BI and multiple MS Project files - Enable data extraction and integration from these multiple MS Project files Ideal Skills and Experience: - Proven experience in Power BI dashboard creation - Strong understanding of data analysis - Previous experience in linking Power BI with MS Project files

vb 2012 video and sound recorder. Auto record to file when motion/sound is detected. Auto save file if no motion/sound detected for 5 seconds. exe File must be compact and small and not dependent on other dll or ocx. Auto detect existing cam and video device on PC. Note there are a lot of samples on Chat GTP.

I require an experienced C# developer for a project centered around a Windows 10 and 11 application. This application will essentially intercepting the regular login process and displaying an MFA (multi-factor authentication) screen to the user. Key Details: - The application must support both Windows 10 and Windows 11 operating systems. It should be compatible and seamlessly function across both. - The MFA screen should have OTP functionality, meaning that it generates a one-time password for the user to enter as part of the authentication process. - Communication with our web-based Rest API should be established using API keys. This ensures secure and proper interaction with our backend system. Ideal Skills and Experience: - Proficiency in C# and experience with Windows application dev...

Business Evaluator updated 5-6-24 9:26 Freelancer – When responding back, respond to the questions below, otherwise you will not be considered for the project. Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input...

I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and experience f...

Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financial informatio...

I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.

I am looking for an experienced Excel tutor to provide me with in-person lessons focusing on basic formulas and functions. My Current Skill Level: I would rate myself as a beginner - I have minimal experience with Excel and would need a tutor who can help me understand the basics. Skills to Learn: My main goal is to grasp basic formulas and functions within Excel. I'm looking to build a strong foundation before moving onto more complex features. The ideal candidate for this job has: - Proven experience in tutoring or teaching beginners Excel - Strong understanding of basic formulas and functions in Excel - Excellent communication skills to effectively convey concepts to a novice - Availability for in-person sessions If you think you're the right fit for this proje...

I'm seeking an expert to develop a custom data dashboard focused on displaying my business's sales data. Ideally, this dashboard should represent the data through a visually engaging pie chart. Key Requirements: - Proficiency in data visualization tools - Strong understanding of pie chart data representation - Experience in incorporating total sales data into dashboards This project requires a professional who can effectively convert raw sales data into comprehensive visual representations. An understanding of sales analytics and data interpretation would be beneficial to the successful completion of this project.

Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for each empl...

I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a notificati...

I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.

I need an expert in Google Sheets to create a spreadsheet that will help me with data storage and organization, calculation and analysis, as well as collaboration and sharing. - You will be working with 1-5 sheets, and you should be able to help me set up the data in a logical and user-friendly way. - I would require some basic formulas to be implemented, so knowledge of formulas like SUM and AVERAGE is a must. - Lastly, I need to ensure that the sharing and collaboration aspects of the sheet are secure and work smoothly. - Previous experience with similar projects is a plus.

I'm looking for a Google Sheets expert to help with the following tasks: - Implementing formulas for summing and averaging data - Applying conditional logic for data analysis - Setting up conditional formatting for better data visualization - Creating data validation rules for accurate data input - Designing custom charts and graphs for enhanced data representation. The ideal candidate for this project should have a strong background in Google Sheets and data analytics. Experience with complex formula implementation and data visualization is a plus. Being detail-oriented is crucial, as accurate data handling is a key aspect of this project.

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or visually simple or ap...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and can demonstrate ...

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: Contact Name: ...

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY

I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsheets, particularly in the pr...

I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.

Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.

vb 2012 .net record video and sound. Autosave to file when motion/sound is detected. exe File must be compact and small and not dependent on other dll or ocx. Auto detect existing cam and video. Ability to read/write to a registry key.

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver a reliable automated solutio...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

Provide guidance and council for the development of my companies current forms, trackers, and databases - specifically the automation of processing and linking data from various inputs across multiple-departments within my construction company. We currently have multiple forms, trackers, and databases that have daily inputs from multiple field personnel and back-of-house departments. The workflow on my projects requires intricate and dynamic workflows that involve multiple individuals and departments. I am in the early stages of making "smart" tools for automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I wan...

Please Sign Up or Login to see details.

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the success of this projec...

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I'm urgently looking for a seasoned VB.NET developer who can add new functions to my software application. At this stage, I'm not specific about the functions I want to integrate, I need someone who can provide professional insight based on their experience. The ideal candidate will have: - Extensive experience in creating new software applications - Mastery in debugging and fixing existing VB.NET code - Outstanding ability in enhancing and optimizing performance of software applications While there's an urgency to this project, I need a developer who will not compromise on the quality and efficiency of the work. I look forward to working with you.

i need to replicate the following data by looking for info on WB or IMF websites, i need to first identify how to calculate the Cyclically adjusted (CAB) part, can someone help? the end product is that i have to present similar table (see attached), i need to give clear explanations as to where my data came from, how the adjustements are made the task i received: "One bank presented a chart below and claim that " DM fiscal policy is set to tighten markedly this year ” Can you please check IMF and world bank websites, or other sites, to see if you could replicate the data below. "

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen services. My business involves a multitude of services, and I need an within-the-business platform that allows for easy calculation based on user preference. Here are some specifics: - Carousel selection of services: your form should allow selection of various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal C...

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid with a specific plan on how you will tackle this iss...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel func...

I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.

I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has ...

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.

In the company we have a third-party application that we use to save documents in the cloud, this application is using the “save as” button in Microsoft Word. Users use the “save” button and save the documents to the local computer. This change will force my users to save information to the cloud through my application

I'm in need of a software tool that can convert PDF files to QIF, a type of financial transaction format. The tool should have the following features: - **Batch Conversion Capability:** The tool should be able to handle multiple PDF files at once, converting them into QIF format with ease. - **Automatic Categorization of Transactions:** I'd like the tool to automatically categorize transactions within the converted QIF files. This feature will save time and enhance the usability of the tool. Furthermore, the tool should adhere to specific formatting requirements for the converted QIF files, including: - **Date Format:** The converted QIF files should have the date format specified. - **Account Number Format:** The converted QIF files should have the account number format speci...