Excel vba code convert sql vba jobs

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.

Looking for an experienced developer to cr...track of all client interactions. - Invoicing: Our current accounting system is insufficient for our needs. We require a system in which we can easily generate invoices and track their payment statuses. - Lead management: A feature to manage potential leads would be crucial in maximizing our client acquisition efforts. We need to track prospects from initial contact,judge potential for success and convert them to clients. Experience & Skills: - Proven experience in developing comprehensive management systems - Skilled in developing user-friendly AirTable applications - Familiarity with the law firm workflow is a plus We're hoping to have this project completed within a month. Do get in touch if this seems like a perfect fit f...

I'm seeking a dedicated and skilled female sales agent to support my business. In this remote role, you'll be focused on lead generation within the retail sector. Key Responsibilities: - Lead generation: Your primary task will be to identify and develop leads within the retail industry. You'll need to proactively seek out potential business opportunities and convert them into qualified leads. Ideal Candidate: - Sales Experience: Prior experience in sales or lead generation, particularly in the retail sector, will be highly beneficial. - Communication Skills: You should possess excellent communication skills, particularly over the phone, as this role will involve cold calling. - Self-Motivation: Given the remote nature of this position, you should be self-driven and ...

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

...a proficient developer to design a functional asp.net / vb template which will be the foundations of an internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be possible to...

I am in need of a skilled illustrator to create a black and white comic in a cartoon style. This comic will serve as a pro...comic in a cartoon style. This comic will serve as a promotional tool for a documentary. Key Requirements: - Art Style: The artwork must be cartoonish - Purpose: The main goal of this comic is to promote the documentary - Complexity: The storyline should be simple and straightforward, easy to grasp for viewers Ideal Skills and Experience: - Proven experience in cartoon illustration - Ability to convert a documentary into a captivating comic - Understanding of effective narrative structure - Portfolio demonstrating similar projects is a big plus I am looking for someone who can translate the essence of the documentary into an engaging, visually appealing co...

I am looking for a seasoned Oracle Apex developer with a knack for artistic flair to develop a unique user interface for our new application. Specifically, your role will revolve around: • Leveraging SQL to create an aesthetically pleasing, functional user interface that aligns with Oracle APEX principles. • Leveraging your design prowess to develop an artistic, visually-engaging user interface. Your competencies should include: • Proven proficiency in Oracle APEX and SQL • A portfolio showcasing previous user interface designs, ideally within the Oracle APEX framework • A keen eye for artistic, visually pleasing design aesthetics • Superb problem-solving abilities while working within design constraints. Prior experience developing simila...

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cle...some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry a...

Hi, we need help compiling and running SDK example C code.

I am seeking an efficient freelancer who can convert my PDF drawing into a basic STL file focusing on shapes and structures. No intricate detailing required. The final output will be used for 3D printing purposes. - Key Duties: - Convert PDF drawing into a basic STL file - Retain the fundamental shapes and structures from the original drawing - Test the final STL file to ensure it is suited for 3D printing - Make sure to follow the correct sizes in the drawing. Ideal freelancer for this project would have extensive experience in 3D modeling, proficient in using software for creating STL files, and have a strong understanding of 3D printing requirements. Familiarity with PDF files conversions would also be a huge plus. Your portfolio showcasing similar projects would be appr...

We are looking for a professional with skill and experience in C programming language in embedded code for RF transceiver modules, particularly experienced with NTR09RSL8 and NTR09CSL8 868MHz LoRa RF Transceiver modules. Your task is to develop and test code to accurately depict their abilities and limitations, we expect the final work to be thoroughly tested, well-commented, and ready for deployment. Here below are the basic requirements; 1- SX1262 drivers should be used (from Semtech) 2- Test Code (for the flowchart/detailed requirements which will be provided to engaged candidate) should be tested in Nucleo-L432KC or Nucleo-L476RG 3- Deliverable is the Test Code Ideal Skills and Experience: - Proficiency in radio frequency transceiver modules particularly ...

...to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. This project is very large, so I would like to start with a very high-level review of my concept: Current job and price is for 1) The review of a 2-page outline of my development project, up to (6) PDF and/or Excel documents that are currently in use, and (1) Excel-Based production tracker that attempts t...

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

The Doordash driver app called Dasher requires a zip code for registration. Right now, in most states, a large portion of drivers are placed on a waiting list because there are more drivers than needed. I need to find several zip codes (5 - 10) for the Dasher application that, when entered, would prevent new drivers from being waitlisted (that is, they would be taken to the next page, and not to the page with a message that they have been added to the waitlist).

I need a skilled developer to convert my existing website into a streamlined Android and iOS app. Main features will include: - Login/Register Functionality: Allow users to create new accounts and login to existing ones. - Push Notifications: Enable real-time message alerts to keep users updated. The primary function of the app is information dissemination. My website serves as a platform that equips users with important information, and I want to increase accessibility and usability with a native app. Given the urgency of this project, I need someone who can expedite the process - the sooner, the better. Ideal candidates possess solid experience in Website-to-App conversions and can work within tight deadlines. A strong understanding of mobile UX/UI design and app development fo...

I'm searching for an experienced LinkedIn lead generation professional, adept at cultivating B2B connections within the technology industry. To be successful in this role, you will need: - Proven...lead generation, particularly within the technology sector - Demonstrate strong understanding of LinkedIn's features as a networking and lead generation tool - Ability to effectively target potential leads, with the understanding that the user did not specify a focus on job titles or roles Ideal candidates will have a track record of creating significant connection growth, generating leads that convert, and providing comprehensive reports on their process and success rates. Please provide examples in your proposal where you have done this in the past. Looking forward to a pote...

I have Python code on github and I just need to add a filter to it, something very simple. the code is ready just add a filter

NOTE: KINDLY PRESENT A DEMO OF THE PROJECT ALONG WIth THE BID. I'm looking for an experienced developer to create a custom Chrome extension for me. This extension will be a dark mode tool, allowing users to convert any webpage to dark mode and vice versa. Additionally, it should have the following features: - An auto mode that toggles automatically between light and dark mode from 7:00 PM to 7:00 AM - A page brightness toggler, allowing the user to adjust the brightness from 0% to 100% - An option to whitelist any web page and manage the whitelist - A one-time payment option - A designated area for logo positioning Ideal skills for this project include: - Proficiency in Chrome extension development - Experience with dark mode implementation - UI/UX design skills for the lo...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

...using Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There sho...

I'm looking for a developer with experience in Ionic to help me make some modifications to an APK source code. The modifications are as follows: - Add pay by card functionality - Integrate iOS and Android wallet payment - Remove geofence functionality Regarding the design, I'm looking for a minimalistic approach. The payment gateway of choice for the pay by card functionality is Stripe. Ideal skills and experience for the job would include: - Proficiency in Ionic - Experience in working with APK source code - Knowledge of payment gateway integration, specifically Stripe - A good eye for minimalistic design Your understanding and ability to implement these modifications efficiently and effectively will be greatly appreciated. Please feel free to reach out with an...

We're in search of a talented graphic designer who can take a photograph of the woman in this image and seamlessly transform it into a captivating logo. The style should be similar to the reference image provided. Drawn/cartoon similar to what's on the task involves creating a design that captures the essence of the subject while aligning with the style of a provided reference image. Attention to detail is crucial to ensure the final logo reflects the desired aesthetic and branding objectives. If you have a knack for creative design and can bring a fresh perspective to this project, we'd love to collaborate with you.

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

I have a set of print designs(10), currently in PNG format, that I need recreated in Adobe Illustrator. I'm looking for an experienced designer who can convert these files into fully editable source files. - The resulting files should be in Adobe Illustrator, allowing me full control over editing and customizing them in the future. - The quality and details of the recreated designs should match the original PNG images. - I need the final source files to be clean, well-organized, and easy to work with for future modifications. The ideal candidate for this project should have: - Proficient experience with Adobe Illustrator - Strong design skills to ensure the recreation matches the original designs - Ability to deliver clean, organized source files If you're confident ...

Please Sign Up or Login to see details.

I'm in need of an Android video downloader application. Although I haven't decided on the number of video hosting sites that it should su...application. Although I haven't decided on the number of video hosting sites that it should support, it will be good if it can support multiple sites. Key Features: - Android Compatible: The downloader app should be fully functional on Android devices. - Multiple Sites: The ability to download videos from multiple video hosting sites. - Video Conversion: The application should have the capacity to convert downloaded videos into different formats. Ideal Skills - Experience in Android app development. - Familiarity with video download and conversion libraries. - Knowledge of video hosting site APIs will be a plus. Looking for...

I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.

I need new features integrated into the existing PHP code. It's vital to note that your proficiency in PHP will be instrumental. I expect the freelancer to provide suggestions and potential improvements in creating a robust application.

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

I have a simple text-based PDF document that I need to convert to Word for editing purposes. The converted Word file should maintain the original formatting of the PDF. Requirements: - Convert a simple text-based PDF to Word for editing - Maintain the original formatting of the PDF in the Word document Ideal Skills: - Proficiency in PDF to Word conversion - Expertise in Microsoft Word - Attention to detail in maintaining original formatting Please note that the main purpose of this conversion is to ease the editing process, so it's of utmost importance that the formatting of the final Word document mirrors that of the original PDF accurately.

I am looking for a seasoned PowerPoint designer who can create a slideshow that focuses on emphasising our company's Unique Selling Proposition (USP). The presentation should be tailored towards a sales pitch, seeking to convince and convert potential clients or stakeholders by vividly showcasing what sets our company and its products/services apart in the market. Key project details are as follows: • PowerPoint Design: The PowerPoint design should be strikingly professional, but also intuitive and easy to follow. • Illustrations: The project requires detailed and realistic illustrations. These must accurately represent the company's USP and should help to engage the audience effectively. • Key Message: The main takeaway message is our Unique Selling Prop...

I'm looking for an expert to help monetize my YouTube channel, which primarily features vlogs targeted at an adult audience. Key responsibilities include: - Implementing strategies to attract more views and subscribers - Creating an effective monetization strategy - Monitoring analytics and adjusting strategies as necessary Ide...strategy - Monitoring analytics and adjusting strategies as necessary Ideal candidates should have: - Proven experience in monetizing YouTube channels - Familiarity with vlog-style content - Strong understanding of analytics and algorithm tweaks - Ability to engage with an adult demographic effectively This is an ideal position for someone with a creative mindset who understands how to convert views into revenue. Let's increase my chann...

Please Sign Up or Login to see details.

I'm looking for a skilled Angular developer to build the frontend of a web application for small businesses. It is a low code framework, in which the user defines the components of his webpage (Data fields, filters, columns, Actions, Editor..) and a page containing the grid and others will be dynamically rendered according to its definition class.. Other details to be discussed. This app should feature: - Drag and Drop Functionality: You should be adept at creating user-friendly drag-and-drop interfaces. - Form Builder: A key element of this app is a customizable form builder, aligned with user needs and integrations. In terms of aesthetics and functionality, an interactive design approach is sought after. Skills and Experience: - Proficiency in Angular, and understanding of...

I am looking for a proficient typist who can handle copy typing projects from PDF format, specifically text-only copies. This task ideally suits beginners who exhibit accuracy, speed, and efficiency in their work. Key Tasks: - Convert a PDF (with text only) into a word document. - Keep the layout of the text simple without the need for detailed formatting. Skills and Experience: - Fast, efficient, and accurate typing skills. - Experience in data entry, specifically from PDF to Word conversions. - Attention to accuracy and detail. - Ability to follow clear instructions regarding layout and formatting. The final document should be a flawlessly typed-text with a simple layout and delivered in PDF format. Please keep in mind that neatness and accuracy are paramount for this job.

I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.

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

I'm in need of a talented developer proficient in VB6 application conversion to both iOS and Android platforms. The main task will involve modernizing a data analysis VB6 application, bringing it to a mobile platform while preserving its core functions and unique aspects. Key tasks: - Convert VB6 application to a hybrid mobile app for both iOS and Android. - Please make an educated suggestion about what should be preserved since I didn't indicate specific features from the original VB6 app. - The application's primary purpose is data analysis, which needs to shine in the mobile version. Ideal skills: - Proficient in VB6 and mobile app development. - Good understanding of data analysis applications. - Nice to have: a portfolio of similar completed projects.

I need a well-structured informational website built. ...need a well-structured informational website built. Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you've complet...

I'm seeking a meticulous data entry professional who can convert physical documents filled with text data into an Excel spreadsheet. Key Requirements: - Conversion of physical text data documents into an Excel spreadsheet - High level of accuracy and attention to detail to ensure the data is entered correctly - Ability to maintain data confidentiality - Must be able to meet deadlines Ideal Skills: - Proficient in data entry and managing data using Excel - Excellent attention to detail to ensure the accuracy of the entered data - Previous experience in handling sensitive or confidential information - Ability to meet deadlines and ensure timely delivery of the project - Strong communication skills to provide updates on the progress of the project

...option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u, --url: Specify the target URL. -o, --output: Specify

...currently dealing with an issue where an existing Java code for a data processing function isn't working as expected, but I'm uncertain as to what's causing the problem. Skills and Requirements: 1. Expertise in Java: The job requires a proficient understanding of Java programming to understand and diagnose the existing code. 2. Experience in troubleshooting and debugging: As I am unsure of what's causing the problem, the freelancer needs to be competent in identifying and rectifying coding errors. 3. Understanding of Data Processing Applications: As the main issue with the code lies in its data processing function, an understanding of this will be beneficial in diagnosing and remedying the situation. Your job will be to inspect the Java ...