Running excel vba macro sql server jobs

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

As a seller of physical products, I'm in search of an expert to manage and optimize our online sales channels. Your role will involve overseeing our website, social media platforms, and e-commerce marketplace. Responsibilities: - Effective online channel management - Continuous optimization for increased sales Ideal Candidate: - Previous experie... Responsibilities: - Effective online channel management - Continuous optimization for increased sales Ideal Candidate: - Previous experience in online channel management - Knowledgeable in e-commerce, SEO, and social media - Proven track record in boosting online sales Thankfully, all product information, including images, specifications, and prices, is ready, so you can hit the ground running. I look forward to a successf...

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering ...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I'm in need of a Social Media Marketing professional to help with my Facebook, Instagram and WhatsApp accounts. My main goal is to generate leads and conversions, so I need someone with experience and proven results in this area. Key Responsibilities: - Develop and implement a comprehensive social media str...whenever a B2B product arrives and share it to all our wholesale customer. No WhatsApp groups will be encouraged. Conversations with B2B customers must be unique and specifically targeting their products. 3. Try creating 3 reels per week and post them (Videos will be send from us). 4. Also, 5 posts per week. 5. All the posts must be set in a way to get organic views and must be aesthetic. 6. Work on running ads on a very minimal budget. This needs to be monitored regula...

I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.

...additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - Prior experience building work order or similar task management apps. Ideal candidate has worked on projects requiring direct connection to SQL server for real-time da...

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

...assist me with a combination of SQL and Python tasks. - SQL: I need help with SQL in three specific areas: 1. **SQL Syntax:** Assistance with basic SQL commands, especially in working with subqueries. 2. **SQL Queries Optimization:** You should be able to optimize SQL queries for data retrieval accuracy. Your goal should be to ensure that the data collected is as accurate as possible. 3. **SQL Database Design:** You should be able to assist with database design, ensuring proper schema design and normalization. - Python: While the primary focus is SQL, some tasks may require basic Python knowledge. If you are proficient in both SQL and Python, even better. **Ideal Skills:** - Strong understanding of SQL...

I have been managing the PPC from 25th March 2024. I have created the PPC campaign and start running the advertisement over the Amazon platform and start generating the sales. In between we got out of stock which is why the campaigns stopped working and our sales got effected a bit but now I have created new campaigns and duplicate the previous campaigns so that new campaigns and the existing campaigns can work properly and we can generate good number of sales. Please accept this project and release the milestone of 90GBP as it's been over 1 month. Thanks.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...

I need an expert in electromagnetic and Particle-In-Cell (PIC) simulation to assist me in running simulations to optimize the performance of a 5-mW-Long Anode Pulse Magnetron. The goal is to study and enhance various performance aspects such as: - Efficiency - Output power - Stability of operation Your task will involve creating a CST file for the entire magnetron based on a paper I'll provide. This is crucial as the simulation outputs will serve as my study material for a higher course. Skills & Experience: - Proficiency in electromagnetic and PIC simulations - Prior experience with magnetron technology - Clear knowledge of CST simulation software (Creating & analyzing files) - Ideally, experience with high-power microwave devices. Finaly I want apply this on C...

I am seeking an experienced professional who can assist me in setting up my PlaySMS email server. This server will be responsible for sending certain information to my subscribers, and also forwarding messages the same to their emails. Key responsibilities: 1. Setting up playSMS with my third-party email service provider, Hostinger. 2. Ensuring the functionality to send relevant information to subscribers. 3. Implementing a solution to forward the SMS to subscribers' emails. Candidates should preferably have: * A strong background in configuring playSMS and email servers. * Experience with third-party email service providers, particularly Hostinger. * A good understanding of email and SMS forwarding capabilities. Looking forward to work with people who have a h...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

...programming, with expertise on Wiz5500. We already have a working firmware running on our custom PCB that uses the Wiz5500 to display a web page with basic interfaces. The project consists in modifying that firmware to integrate two new features : 1) After sending data from webpage to mcu, we cannot use the web browser refresh button because it re-sends the data again. We want to fix this by either re-directing automatically to the main webpage after sending data or some other way you can propose. 2) We want to synchronize the mcu with the local time. This can be done by synchronizing with the NTP server or some other way you can propose. We would like the webpage to keep working during the synchronization with NTP server but could accept a small downtime as...

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server ma...

I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Idea...

webscraping cdiscount using python and export it into excel

I am currently seeking a social media advertisement expert with an innovative mind. The main task will be running Facebook and Instagram ads targeted towards young adults between the ages of 18-29. The primary purpose of these ads will be to generate leads. - Preferred Skills: • Proven experience managing social media advertisement campaigns. • Demonstrable crafting of compelling messages that resonate with young adults • Ability to monitor and analyze campaign performance. Only apply if you have experience in outcome-based advertising and are familiar with the latest industry trends. This project will demand creativity and an analytical mindset for optimal results.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...

I need a skilled professional to create a tailored Discord server for our PC gaming community, focusing on first-person shooter (FPS) games. You should be experienced in Discord server setups and familiar with gaming communities. Your tasks will include: - Setting up different channels for various discussions - Integrating voice channels for live conversation - Implementing anti-nuke bots for server security - Configuring permissions for user roles - Adding a support bot that can manage member queries with specific commands Having experience in creating Discord servers for other gaming communities would be ideal, particularly if they have been related to FPS games. The server needs to be stable, engaging and conducive to positive interactions within the gaming...

I'm on the hunt for 2 or 3 talented PHP freelancers who are ready and willing to work with me for 10 to 20 days due to a sudden result of project overload. Here's what you'll be working on: - PHP Development: You'll be using your coding skills to build and modify web applications. - Web Development: Using PHP, you'll create user-facing elements to meet clie...that the data storage and retrieval systems are effective and efficient. You'll ideally be familiar with the Laravel and CodeIgniter frameworks and use them to execute the projects. While I’m open to all applicants, I am particularly looking for those at an intermediate level who have some experience in handling complex projects. If you're dedicated, detail-oriented, and ready to hit the grou...

...license keys for an Excel template product. Key responsibilities are: * Design and develop a License Key Generator using Python. * Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a d...

...my brand's presence and generate more sales. The primary objective involves increasing brand awareness and establishing brand credibility through effective strategies encompassing a nuanced understanding of both organic and paid forms of advertising. Key areas we'll be focusing on include: - Social media marketing strategy development - Crafting engaging content to increase brand visibility - Running paid campaigns to drive sales - Social media performance tracking and optimization Given the nature of the project, a solid background in social media marketing with a focus on advertising is essential. You should have a proven track record in driving sales and bolstering brand credibility via social media channels. Both a creative and analytical mindset is necessary to d...

I'm looking for an Excel file that contains a list of companies in Dubai, specifically from the Technology and Hospitality industries. The file should include the following information for each company: - Company name - Address - Phone number - Category of business Key requirements: - Data should be accurate and up-to-date - Companies must fall into the Technology or Hospitality industry

Seeking an experienced PL/SQL developer to assist with multiple tasks in my project. This includes: - Oracle database management - XML table manipulation - JSON parsing - Dynamic SQL operations - Development of PL/SQL objects - Utilization of collections and arrays in PL/SQL The project will also involve intricacies such as: - Error handling and exception management - Performance optimization - Crafting of database triggers and stored procedures - Harmonious integration with other systems - Performing data migration and transformation tasks Ideal freelancers for this project should be adept in PL/SQL and Oracle development, with particular skill in SQL*Plus and PL/SQL Developer tools.

I'm facing an issue with my PHP CURL function where I'm unable to connect to a remote server. This error is specifically coded as 'CURLE_SSL_CACERT (60)'. Key Points: - Need to resolve SSL certificate validation issue causing Error 60. - The project is running in my local development environment. Skills/Experience Required: - Strong experience with PHP and CURL. - Expertise in SSL certificate handling in PHP. - Familiarity with local development environments.

I'm experiencing an issue where the is not being called correctly when passed through Varnish in my Magento 2 setup. This is affecting the loading and functionality of my website. This is a plesk server running without apache ie nginx only. In addition to the default nginx server block a custom block has been created which vanish is pointing at. However, nginx is showing a 404 for and no images are generated in media/catalog/product/cache Key requirements: - Proficiency in Magento 2, Nginx, and Varnish - Strong experience troubleshooting and debugging server configurations - Ability to deliver prompt and reliable solutions The successful candidate should be able to resolve the issue promptly, ensuring that the website is loading correctly and all fe...

I am looking for an experienced professional to install a SIP trunk server on a Linux system. As part of the project, you should also set up access to the live voice stream with the primary purpose of real-time transcription. Key Requirements: - Install and configure a SIP trunk server on a Linux system. - Enable access to a live voice stream for real-time transcription. Ideal Candidate: - Proficient in Linux server administration. - Experienced in SIP trunk server installation. - Familiar with real-time transcription processes. - Skilled in setting up live voice stream access. - Strong problem-solving and troubleshooting abilities.

I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.

I'm looking f...marketing campaigns on Facebook and Instagram - Optimize the campaigns to drive conversions and increase sales, with a strong focus on promoting my new arrivals - Regularly analyze campaign performance, making adjustments to ensure maximum ROI Ideal Skills and Experience: - Proven track record of delivering results through performance marketing, particularly with Shopify stores - Expertise in running successful campaigns on Facebook and Instagram - Understanding of e-commerce sales funnels and the ability to optimize them for conversions - Strong knowledge of the latest trends and best practices in performance marketing If you're a results-driven professional with a passion for e-commerce and a knack for driving sales through performance marketing, I'...

...can assist me with various tasks in Microsoft Excel and content writing. The ideal candidate should be proficient in Python and C programming languages. In Excel, I require help with: - Data entry and organization: Assisting me in organizing existing data and entering new data into specific format. - Formulas and calculations: Creating formulas and performing calculations on the data. - Power point: Making power point presentation. - Programming: Automating specific tasks using Python and C programming. In terms of content writing, I need support with: - Copy paste: Help me in copy paste some data. - Story: Writing a story. - Resume: Writing a professional resume. The ideal candidate for this project should have a good understanding of Excel and programming, p...

...emphasis on securing various applications. The scope of work includes web applications, mobile applications, and desktop applications. Key Responsibilities: - Identify and correct various security vulnerabilities specifically: cross-site scripting (XSS), SQL injection, and session hijacking. - Devise strategies to enhance the security of all our applications. - Regularly conduct security checks to identify potential threats. Ideal skills: - Proven experience in securing different application platforms. - In-depth understanding of XSS, SQL injection, and session hi-jacking. - Comprehensive knowledge of network security and data protection. I need someone who is adept in application security to safeguard our digital assets. Your expertise will play a fundamental role in...

I'm looking for an expert in Excel who can assist me with data analysis and spreadsheet design. The main objective of this project is to create compelling data visualizations. Key Tasks: - Analytical reviewing and summarizing of data - Design of clear and comprehensive Excel spreadsheets Objective: - Creating simple charts and bar graphs for data visualization The ideal freelancer for this project should exhibit solid skills and previous experience with data insights extraction, spreadsheet design, and data formatting. Familiarity with basic data visualizations such as charts and bar graphs is essential.

I'm urgently seeking seasoned recruiters with a proven track record in sourcing senior-level candidates specifically in the travel industry. Key Requirements: - Strong experience in senior-level recruitment - Proficiency in sourcing, screening, and onboarding top-tier travel industry professionals - Ability to work under pressure and meet tight deadlines Ideal ca...pressure and meet tight deadlines Ideal candidates should have: - Excellent communication and negotiation skills - A deep understanding of the travel industry and its specific recruitment challenges - A network of potential candidates in senior roles within the travel sector - Proven success in delivering high-quality candidates at a fast pace If you have the expertise and can hit the ground running, I'd lo...