Vba code to import data from sql to excel jobs

We are seeking a detail-oriented freelancer to assist with data entry tasks. Your primary responsibility will be to copy a list of information from a designated website into an Excel document, organized by country and state. The ideal candidate should have experience in data management and be proficient in Excel. Attention to detail is crucial to ensure accuracy in data entry. If you're reliable and can work independently, we would love to hear from you!

I am in the process of completing a logo design. I already have a pencil sketch of what ...pencil sketch of what I need and am looking for someone who can finish it up and provide finished files on SVG, PSD and PNG so I can edit later if I need to. Key details: - colors are red, blue, and white with black outline (see Texas, USA state colors). - pencil sketch I provide may be misunderstood so I would need someone who is willing to make as many adjustments as needed to come up with the final design. - other details will be discussed once project has been assigned Ideal Skills and Experience: - Proven experience in using Adobe Illustrator, Photoshop, and other graphic design software and creating logos. - Excellent communication skills to understand and impleme...

I'm in need of an Excel expert who can help me build a comprehensive workbook to capture end of shift data from multiple locations. Key categories to include: - Delays OS&D - Scanning/PLS Cube Outs - Equipment Issues - Driver Issues - Safety Crucial categories for reporting: - Delays OS&D Specifics for managing Delays OS&D: - I need to be able to list specific delays Ideal skills and experience: - Proficient in Excel - Data management experience - Ability to create user-friendly and efficient workbooks.

I need an expert in ASP.NET and SQL Server to assist with migrating my website and database from GoDaddy to a new host, Ionos.com. Need to scan for malware as well. Not sure of the number of tables but it's around 20. It's not a large dbase. Need SSL activate. Key Requirements: - Full migration of ASP.NET files and SQL Server database - Ensure all data is accurately transferred and the website functions seamlessly on the new host Skills and Experience: - Proven experience with ASP.NET - Extensive knowledge and experience with SQL Server - Familiarity with GoDaddy and Ionos hosting services - Strong troubleshooting skills to address any potential issues during migration

I'm seeking help with ICDL programming, specifically focusing on Excel, Word, and PowerPoint. Ideal Skills: - Proficient in Excel, Word, and PowerPoint. - Experienced in teaching or tutoring ICDL content. - Able to prepare for certification assessments. Key Tasks: - Assist with understanding and practical application of ICDL concepts. - Provide targeted help with Formulas and Functions in Excel. - Support with general use of Word and PowerPoint. - Prepare for certification.

...assistance with Microsoft Excel and PowerPoint. Microsoft Excel: - Data Entry & Formatting: I have a lot of data that needs to be entered and formatted correctly in Excel. - Creating Formulas & Functions: I need someone who is skilled in Excel to create appropriate formulas and functions to manage my data. - Data Analysis & Visualization: The project will require some data analysis and I would appreciate help visualizing the data using Excel tools. Microsoft PowerPoint: - Creating a Presentation: I need a PowerPoint presentation to accompany this project, so experience in creating engaging and clear presentations is a must. Ideal candidates should have: - Advanced skil...

E-Commerce page to copy the supplier's product and populate/refresh/update our company e-commerce page Requirements: - We are an associate to a company that sells home appliances online and have a site SIMILAR to this: - We have a web site on a platform SIMILAR to - The parent site is in Arabic but we want our site to be in Arabic and English (you may make suggestions for a solution!). Perhaps button to translate the names of the products but sometimes this may generate meaningless results!!! - We like our site to be able to update from our parent company website with little effort and technical knowledge. The changes happen often! New products are placed and old ones are removed several times a month or every few mo...

I need assistance with an Excel spreadsheet. The task involves adjusting column D to ensure all wrapped text is readable. - Number of Rows: The column contains between 100 and 500 rows. - Software: The file is in Microsoft Excel. - Specifics: Only column D needs to be adjusted, not the entire spreadsheet. Ideal skills for this project include proficiency in Microsoft Excel, attention to detail, and experience with data manipulation and formatting in spreadsheets.

...looking for a PHP expert to create a script or class that generates PDF/A-1a compliant files from the text stored in my database. The content of the PDF will primarily be text, with some logos and icons as images, as well as tables and bullet lists. Key Features: - The PDFs will generally include an index, with each entry linked to specific content via internal links. - The content is text, tables, lists, images (path to local images) to take from a database. - The images are and must be stored in folder on the server. - Proper data structure with titles, tags, labels, internal links, etc., to meet PDF/A-1a standards. - Validation of the generated PDFs for PDF/A-1a compliance. - Ability to append an existing PDF/A-1a docu...

I'm looking for an Excel expert to help me with a task related to tracking revenue. The primary focus will be on creating projections based on available market growth data. Key Responsibilities: - Analyze market growth data to create revenue projections - Use advanced Excel skills to apply necessary equations and techniques Ideal Skills: - Proficient in Excel, particularly with financial equations - Experience in revenue tracking and forecasting - Strong analytical skills to interpret market data

I'm looking for an Excel expert to help me create a comprehensive inventory management spreadsheet for my business. Key Requirements: - Inclusion of all our supplier's items that we sell - Categorization of items by product type The ideal freelancer for this project should have extensive experience with Excel and inventory management systems. They should be able to create a user-friendly, efficient, and organized spreadsheet that meets these requirements.

...seeking a software developer to create a Windows-compatible solution for managing estimates, sales/purchase orders, and invoices for our dealer network. Key Requirements: - Create a user-friendly interface for managing estimates, sales orders, purchase orders, and invoices. - Design the software with a primary focus on generating estimates. - Incorporate customizable templates for the estimates, ensuring they can be tailored to specific needs. - Ensure compatibility with the Windows operating system. The ideal candidate will have: - Extensive experience in software development, particularly for Windows. - Proven skills in designing user-friendly interfaces. - Prior experience in developing software for managing sales and purchase orders, and invoices. - Ability to...

...experienced Solidworks professional to convert our STEP files into 2D drawings using our custom Solidworks templates. Key Requirements: - You will be working mostly with A, B, or C sized sheets, depending on the part size. - Each drawing should include a minimum of three views plus an isometric view, all fully dimensioned. - The project consists of approximately 300 parts, with an estimated average of 15 minutes per part. - Please use a drawing scale of 1:1, but no smaller than 1:2. Do not crowd pages. - All parts and dimensioning will be in inches. - It is crucial to employ the parallel dimensioning technique wherever possible. - The general tolerance is +/-.002", with shaft OD at +0.0/-.002" and bore ID at +.002/-0.0". - Surface finish details will need ...

I need assistance with a data entry task. The project involves transcribing text from printed hardcopies into a text file. Ideal Skills: - Fast and accurate typing skills - Attention to detail - Proficiency in creating and editing text files - Prior experience in data entry from printed materials Please ensure your proposal reflects your relevant experience and skills. Thank you.

...an expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard cre...

The task is to create a compiler that translates code written in a simple imperative language into virtual machine instructions. The language is characterized by a grammar that includes variable declarations, conditional statements, loops, procedure calls, arithmetic operations, and array operations. Requirements: Compilation and error handling: The compiler should detect errors such as: Duplicate variable declarations, Usage of undeclared variables, Errors related to procedures (e.g., unknown procedures). If there are no errors, the compiler should generate the virtual machine code. Code optimization: The resulting machine code should be optimized for size and speed. Special attention should be given to arithmetic operations, especially ...

I need assistance recovering my WhatsApp data from my Android mobile device. The data needs to be mapped to my original WhatsApp contacts. Unfortunately, a WhatsApp database file was not created on my device, so alternative methods of recovery may be necessary. Specifically, I need to recover: - Messages - Media files (photos, videos) Ideal skills for this job include: - Data recovery expertise, particularly with Android devices - Knowledge of how to recover and map data to WhatsApp contacts - Experience with local backup data retrieval - Understanding of WhatsApp data structure and storage Please note, I have previously backed up my data locally, but not to any cloud service.

I'm in need of an extensive search and collection of contacts - both service providers and community organizer...com/spreadsheets/d/1Hosoe1FDtvoJR_o1RIM9UuLRKMGdxYC2JbvVO3hzGV8/edit?usp=sharing For service providers, I require: - Their contact details - A comprehensive list and description of their service offerings in a structered table format to be able to import this into a database. For community organizers, I need: - Their contact details - Information on their events and activities - An overview of their membership benefits in a structered table format to be able to import this into a database. Ideal candidates for this project should have: - Strong research skills - Proficiency in data collection and organization - Familiarit...

The goal is to build a licensing system hosted on Godaddy along with setting up a database on GoDaddy hosting to store license information, developing a REST API to manage licenses (generate, validate, activate, deactivate), and integrating this API with an existing C# desktop application. Please check the below link for Godaddy API. Project steps: 1- please ensure you can get an API token into a c# software before your bid and send me a screenshot 2- Create a database in my Godaddy hosting 3- Implement detail into the Token for licensing We will be working remotely on my computer and also on your side aswell.

I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports wi...

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.

It is a busy spell for me, and I haven’t got the time to complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (...

CSS Code writing for the 1 page website of this clinet

I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.

Please Sign Up or Login to see details.

I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!

I'm looking for a proficient ...a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to long term Please fee...

I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.

...developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - E...

I need a Python expert to refactor my code with a focus on rewriting main code. The primary task will involve reorganizing the core functionality modules into classes and modules according to Object-Oriented Programming (OOP) principles. Key requirements: - Extensive experience with Python and OOP - Proven track record in code refactoring - Ability to improve code readability by reorganizing code structure - Attention to detail in understanding core functionality modules - Communication skills (English or French) Your goal will be to enhance the code by reorganizing the code structure into classes and modules. The project will be formed in 2 parts, a first part with a small part of the code and a ...

I'm looking fo...create a mobile-friendly, product showcase website for my export-import business. The primary aim of this site is to display our product catalog, which includes a range of items from agricultural products to furniture and handicrafts. Key Features: - The website should be able to efficiently categorize our diverse product range. - Each product should be accompanied by high-quality images and detailed descriptions to provide potential clients with comprehensive product information. Ideal Skills and Experience: - Proven experience in developing mobile-friendly websites. - Strong portfolio showcasing e-commerce or product display websites. - Ability to create visually appealing and easy-to-navigate web interfaces....

I need a skilled HTML coder who can help me enhance the functionality of my HTML code by adding interactive elements. Specifically, I need to incorporate a few columns into my resume maker HTML code. Ideal skills and experience for the job: - Proficiency in HTML coding - Experience with adding interactive elements in HTML - Ability to understand and modify existing code - Attention to detail

I need a Revit model or Telka Structural Designer model of an existing timber frame based on survey data. The model only needs to include basic structural elements. The survey data is in PDF format, and the focus should be on the main beams and columns of the timber frame. Ideal Skills: - Proficiency in Revit - Ability to interpret survey data - Attention to detail Please include samples of similar work in your proposal.

I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments

I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.

I need an experienced photo editor to remove a person from a moderately detailed background in a photo. The primary objective after removing the person is to fill the background naturally, so it looks seamless. Ideal Skills: - Proficiency in photo editing software (e.g., Adobe Photoshop) - Experience with background replacement and photo retouching - Attention to detail - Ability to create a natural-looking image The project needs to be completed within a month.

Hallo abdul i need halp can you right the code

I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of da...

I'm looking for a proficient Python developer who ...developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free ...

...of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating intera...

I'm looking for an experienced Xamarin developer who can remotely run existing macOS-compatible code on a Mac for testing and debugging. Key Requirements: - Proficiency in Xamarin and macOS development - Experience with remote code execution - Strong debugging and testing skills Ideal candidates would be able to help not only in executing the code but also in identifying potential issues and providing solutions. The ultimate goal is to ensure the code is ready for deployment. Please let me know your experience with similar projects.

Emerging Market Bond Data Extraction Project overview Extraction of trading data for sovereign bonds from specified countries over the last 30 trading days, replicating the structure of an example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of trans...

I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.

I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded correctly.

I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas

I'm seeking a skilled programmer to write an Arduino code for a BQ25887 USB charging IC. The code should manage the initiation of charging for two Lion batteries, ensure cell balancing, and support 5V 3A charging from any standard adapter. I am using a MIKROE Balancer 5 click. () Key Requirements: - Charging condition: Need to charge two separate single cell battery of 2000mah via USB charging of around 5V 3A. - For each individual cell, the max charging voltage should be 4.2V and the maximum charging current for each battery should be 1A. - The code should allow for automatic initiation of the charging process. - Enable cell balancing to maintain cell voltage equality. - Implement fault recovery (e.g., reduce current, stop charging)....

**Please read the full project description carefully before bidding.** I am seeking a freelancer to compile content from a 28-page PDF into editable PowerPoint, Word, and LaTeX documents. The PDF can be easily converted to text and equations using appropriate tools. While the exact font matching is not required, the text and equations must be accurate, editable, and properly formatted. ### **Scope of Work:** 1. **Conversion:** - Extract content from the PDF, converting text and equations into editable formats. - Ensure all equations are rendered correctly in PowerPoint, Word, and LaTeX. 2. **Deliverables:** - Editable PowerPoint slides with properly formatted equations. - A Word document with all content rendered accurately, including equa...

...Programmer 1. I have a Dotnet source code for a program which needs to be completed if there are any missing pieces. 2. You'll be responsible for programming the database, which will be SQL Server. 3. Finally, the completed program will need to be uploaded on a server, where you will also run it. The code might need improvement in the following aspects: - Functionality/features - User interface - Error handling and debugging Part II: Apps Developer I need skilled apps developers to create Android and iPhone apps based on the aforementioned program. Ideal skills and experience for the job includes: - Proficiency in Dotnet programming - Extensive experience with database SQL and MySQL Servers - Strong skills in Android and iPhone...

I'm looking to have my current website, , completely rebuilt on Webflow. The goal is to replicate all existing elements and sections from the WordPress/Elementor setup, which has proven to be unstable. Key Requirements: - Exact duplication: All elements and sections of the current website should be recreated on Webflow. - Animations and Interactions: The new site should incorporate both animations and interactions. These will include hover effects, scroll-based animations, and parallax. - Performance: The redesign aims to improve stability and performance, with a particular focus on loading speed. Ideal Skills and Experience: - Extensive experience with Webflow - Strong understanding of website animations and interactions - Proven track record of...