Vba code in excel jobs

I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can de...

I'm looking for an expert skilled in C# who can help me understand the source code of a DLL file. I'm particularly interested in an in-depth understanding of its algorithms. This task will require: - Strong knowledge and expertise in C# - Experience with DLL files - Fluency in explaining intricate algorithms The main aim isn't for debugging or enhancing functionality, but purely to comprehend how it works. Looking forward to your proposals!

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

We are seeking a highly skilled Full-Stack Developer to create a Telegram channels and groups directory website from scratch. This project requires you to develop both the UI/UX design and the backend code. You will not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Cha...

I have a C# MVC ASP.NET Code. currently when I put a breakpoint in the code it does not stop there. i want someone to make this code debuggable. if for any reason the code does not stop at breakpoint I have that means the job is not complete Time is only 1 day, if you need more than that or you cannot do then PLEASE DO NOT APPLY I need an experienced developer to help me debug some C# MVC ASP.NET code. The client hasn't clarified if the project is for personal or business use. However, since the specifics of the debugging needed are not specified, it's expected that the code is reviewed in its entirety. Required Skills and Experience: - Proficiency in C# - MVC Frameworks - ASP.NET Core - Debugging complex applic...

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

I am in need of a proficient web scraper or a cyber expert with a knack for website architecture. Your task will be to download or replicate an entire website's source code. Here’s what I need: - Comprehensive extraction of the whole source code - Clean and organized presentation of the copied code - Ensuring the process doesn't harm or disrupt the targeted site Ideal Candidate Possesses: - Extensive experience in web scraping - Detailed understanding of website structures - Adeptness in using scraping tools and software - Solid ethical hacking skills Upon successful extraction, no further assistance is required with understanding or modifying the code. However, your project deliverable should be clear, categorically orga...

I need an expert to download the full source code of a specific website I have in mind. The required programming languages are PHP and JavaScript. Once the source code is downloaded, I want to utilize it "as-is", meaning no modifications to the existing code are necessary. Ideal candidates: - Have extensive experience with PHP and JavaScript - Proficient in downloading and extracting website source codes - Will respect and follow all legal and ethical guidelines related to this task.

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

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 have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.

I require an experienced data cleaning s...an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track recor...

I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but pr...

I'm looking for a skilled professional to assist me with various cust...Inquiries: Please be prepared to manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - Familiarity wit...

...my website's performance, especially in terms of page loading speed and Google PageSpeed Insights score. My Laravel 10 blade code currently supports the following functionalities: - User authentication - Database integration - API integration The Core Web Vitals that need improvement are: - Excessive Dom - Largest Contentful Paint (LCP) - First Input Delay (FID) - Cumulative Layout Shift (CLS) - First Contentful Paint A critical aspect requiring attention is that the fixed menu across the site should not reload with every page change. Skills and experience required: - Proven track record in Laravel10 blade code performance enhancement - In-depth understanding and experience addressing Google PageSpeed and Core Web Vitals issues - Proficie...

Update Zerodha Dashboard Code as discussed!

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 emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

Data entry operator and my work very clear

I'm looking fo...for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples ...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

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

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

As a beginner in Go Lang, I'm in need of a proficient tutor who can guide me in manipulating a specific Go Lang sample code. My focus areas include: - Understanding Mutex and Go routines - Working with websockts - Grasping Control Structures - Comprehending Functions and Packages The task involves: - Live screen sharing and talking in englisch or German - Debugging the existing sample code - Adding valuable features - Enhancing the overall performance of the code Ideal candidate should have a deep understanding and experience in Go Lang, appreciate patience while tutoring, and have the ability to articulate complex concepts in a simple-to-understand manner. Efficiency, patience, and excellent communication, both verba...

I'm in urgent need of an efficient solution to print Barcodes and QR codes directly from an existing printer. This solution will aid in the swift management of my inventory, product tracking, and ticketing procedures. Key aspects: • Barcode/QR Code Generation: I need the ability to generate a wide range of barcodes and QR codes to meet different needs. • Printer Compatibility: As I already have a barcode printer, the solution should be compatible with my existing equipment. • Fast Turnaround: The project completion is needed ASAP. Quick delivery of the solution is of essence to my operation. Ideal skills for the job would be expertise in barcode generation, understanding of inventory and ticketing systems, and familiarity with various bar...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing th...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory manageme...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet resea...

I am seeking a talented developer to create a bulk phone number checker that is compatible with Whatssap. The core purpose of...to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Lookin...

I'm in need of a skilled developer who can convert my existing PHP backend code (for a fully functioning Social Networking website and mobile app) to Python. This Python code should be fully functional and ready to be deployed. Key Requirements: - Conversion from PHP to Python: The existing PHP code is the backbone of the current system. The successful freelancer will be responsible for translating this into Python, ensuring the functionality remains intact. - Understanding of Social Networking Platforms: As the original code is for a social networking site, familiarity with this type of platform is crucial. Ideal Skill Set: - Proficient in PHP and Python - Prior experience with code conversion

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

I'm seeking a Python expert specialized in Visual Studio Code.

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

As the owner of a bustling website, I am seeking a freelancer capable of setting up Code Canyon mobile apps on my platform. Unfortunately, the questions about the specific apps and objective weren't answered, but my overall goal is enhancing my website to better serve and engage my users. Ideal candidate should possess: - Proficiency in integrating Code Canyon mobile apps to websites. - Proven success in related projects. Expectations for the project: - Seamless integration of mobile apps, ensuring optimal compatibility between apps and website. - Proactive communication about the progress of the project. - Ability to foresee potential issues and provide appropriate solutions. This could lead to future collaborations, given the successful completion ...

I'm in need of a diligent professional to handle the daily update of our inventory data. The primary purpose of this task will be to generate purchase orders based on the stock levels at any given time. The data for this update will be sourced from various channels, which include supplier invoices, our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data ...

As an experienced Laravel Developer myself, I am now in need of someone with greater experience to come in and optimize my code for efficiency, particularly in the areas of database queries and load times. Your skills and experience: • You have at least 5 years of experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency &bull...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - St...

Our program is hydrodynamic modelling of a body of water. It uses hdf5 to store values in a database We use fortran 08. It keeps giving an error of "Fail modulehdf5" and segmentation error. incompressible/compressible fluids (can be) woth reynolds turbulence modelling, Fvm via projection methon nd to measure the second derivative, using upward differencing method. the term eill be fpund was the u, v, p, reynold stress tensors, rectangular grid. The code is attached

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information prot...

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I purchased a source code from codester for a mobile application and I'm looking for an experienced app developer to add some new features. Key modifications include: - Integrating a payment gateway into the app - Incorporating the Facebook SDK for enhanced social media functionality The ideal candidate should have: - Extensive experience in mobile app development for both iOS and Android - Previous work on integrating payment gateways and social media SDKs

Different Website & App Projects Bid ONLY if you have Experience with Coding! ==> Begin your Bid with "OK" Bid for your price in hour!

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ...

...JavaScript code editing and design. Key Project Details: - Code Editing: The primary focus is on enhancing the JavaScript code on my Shopify site. This might involve fixing bugs, adding new features, or improving performance. Your expertise in JavaScript is crucial. - Design: Additionally, I'm looking for a professional who can also assist with design aspects. While the primary focus is on code editing, having a good eye for design in the context of Shopify can be a valuable asset. Ideal Skills: - Strong Proficiency in JavaScript: As this is the core of the project, you should have a solid understanding of JavaScript. - Shopify Experience: Prior experience working on Shopify sites is highly preferable, specifically with the Debut t...

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 am seeking a Python expert to assist in deploying my Python code online for use in a web browser

...which currently translates MATLAB code to X10, to also support C++ as a target language. Key Modifications: - *Update Syntax Translation Rules*: The modification requires a deep understanding of both MATLAB and C++ syntax. The existing rules for translation from MATLAB to X10 need to be adjusted to C++. - *Add Support for C++ Specific Libraries*: The modified application should be able to integrate commonly used C++ libraries seamlessly. Accuracy and Time: - *Accuracy is Key*: The conversion of MATLAB code to C++ needs to be precise. While I'm open to additional development time, the primary goal is to ensure the accuracy of the conversion. - *No Specific Library Requirements*: Though the modification needs to support C++ libraries, I have no specific libraries i...