Date vba excel sqlJobs

Solve excel problem using excel solver

Jeg skal lave en prissammenligningsside. Jeg har samlet alle priser hos en forhandler og skal nu have fundet de samme produkter hos andre forhandlere. Jeg har lavet et excel ark hvor jeg liste alle URLs til den primære forhandler. Det er så jeres opgave at gå ind og finde det tilsvarende produkt hos de andre forhandlere og indsætte links i Excel arket. For at produkterne er de samme skal I tjekke at billedet er ens. Hvis I ikke kan finde det pågældende produkt skal der bare skrives 0 i cellen. Se vedhæftede fil for hvordan templaten ser ud. Det drejer sig cirka om 1000 produkter og 10 forhandlere, der skal tjekkes

Jeg har vedvarende arbejde relateret til vores tidligere projekt ' Looking for a user-interface for Excel'

Take excel spreadsheet & upload via talend to REST service. Might have to work via multiple sheets. Rory to pass on details.

We are looking for a detail-oriented individual to transfer data from over 2000 estimates into an Excel workbook / pricing database. The estimates and the Excel workbook are already formatted, so the main task will be to accurately input the data. This job requires strong data entry skills and attention to detail. The ideal candidate should be proficient in using Excel and have a good understanding of spreadsheets. We are looking for someone who can complete this task efficiently and accurately within 2 weeks. This will be executed in milestones to ensure the task is completed accurately and thoroughly.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...

I'm in need of a skilled...for a general audience. The primary goal of the content is to educate the readers, so a strong ability to simplify complex information is key. Key requirements: - Expertise in content writing, with a knack for simplifying complex topics - Understanding of audience engagement and ability to create compelling content that keeps readers interested - Strong research skills to ensure accurate, up-to-date information - SEO knowledge to optimize content for search engines while maintaining a natural flow Ideal candidates will have prior experience in writing for general audiences, and can provide samples that demonstrate their ability to simplify complex concepts. A background in journalism or educational writing may also be beneficial. Looking forward to ...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I'm looking for a Selenium expert with strong experience in Python/Java to develop comprehensive and effective Selenium tests for our web application. Key Requirements: - Proficient in Python/Java: Ideal candidate should ha...Attention to Detail: Ability to meticulously craft test cases and identify and report bugs is crucial. Your responsibilities will include: - Collaborating closely with our development team to understand the application structure. - Developing a suite of selenium tests to validate the application's functionality and performance. - Executing and maintaining these tests, ensuring they remain up-to-date as the application evolves. If you're a detail-oriented Selenium expert who excels at Python programming and has a passion for ensuring quality, I...

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

...Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on outstanding customer balances. o Receipts: Report on customer rece...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...

...and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving skills - Good understanding of website architecture and aesthetics - Ability to manage priorities and work in a fast-paced environment - Excellent communication skills This is a long-term project, so I'm looking for someone who is dedicated and can work well also in a...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...

I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an a...of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fin...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on ...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm in need of a diligent and proactive virtual assistant. Your main responsibilities will include daily calendar management and tracking tasks in Notion. Key Duties: - **Daily Calendar Management**: Keep my calendar up-to-date and organized. - **Task Tracking**: Use a provided Notion template to monitor my progress on tasks. - **Reminder Services**: Proactively send me reminders for upcoming events and deadlines. Ideal candidates should have: - **Experience as a Virtual Assistant**: Proven ability to handle similar tasks. - **Familiarity with Notion**: Ability to navigate and use templates in Notion efficiently. - **Strong Organizational Skills**: Capable of keeping my schedule in order. - **Excellent Communication Skills**: A proactive approach to reminders is crucial.

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves...recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on developing completion scopes for software...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database t...

I'm looking for a professional, modern and elegant logo design for my business, City Nest Living. I'm open to any colour scheme, so ...dated or overly traditional design elements. - Elegant: I want the logo to have a touch of sophistication and refinement. It should be stylish and classy, without being too flashy. - The company name must be included in the logo Ideal skills and experience: - A strong portfolio with a history of successful logo designs, particularly for professional services or real estate businesses. - Up-to-date knowledge of design trends, particularly in the field of branding and logo design. - Excellent communication skills to understand and incorporate my vision into the design. - Ability to work efficiently and deliver high-quality work within a re...

...their infants - Ensure the curriculum is tailored to a vocational training audience, with a practical and hands-on approach. Ideal Candidate: - Proven experience in developing vocational training curricula, preferably in the healthcare or wellness sector - Sound knowledge of post natal care, basic nursing, and massage therapy - Excellent research skills to keep the course content up-to-date and relevant - Strong communication skills to create engaging and informative course materials - Understanding of adult learning principles and how to apply them in curriculum development. I'm looking for a candidate who can not only create the curriculum, but also provide guidance on how to effectively deliver the content in a vocational training setting. If you have exper...

...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...

...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm looking for a talented abstract artist based IN BELGIUM or FRANCE, !!! to create a unique pen and ink traditional hand made drawing for me ( fits inside A4). the concept is on the photos more explanation done via dm's Key Requirements: - You must be based in Belgium, as I prefer to receive the final drawing via post. - Proficient in pen and ink drawings (hand drawn...receive the final drawing via post. - Proficient in pen and ink drawings (hand drawn, traditional), with a strong portfolio in the abstract style. - Should have a deep understanding of fantasy themes, with a particular focus on 'Lord of the Rings'. If you think you have the skills and creativity to bring this vision to life, please don't hesitate to apply. Thank you. deadline: one week from the ...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

More details: What is the primary purpose of the swiping functionality/screen in your app? Event browsing What content should be displayed on each swipe card? Event name and photo, Event description and date, Event location, Host photo How should the swiping functionality work? Swipe left to dislike, swipe right to like, Swipe up to view more details, swipe down to return to previous card Add swipe screen to menu on existing app, populate with dummy data, that calls backend api

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Salmiya, Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For...computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you would be required to be on site and repeat communication from staff and content from the exam in a way that the candidate may read your lips. The exam is taking place at a professional testing center in Salmiya, Kuwait. Date: Thursday, 30 May, 2024 Time: 9:30 AM to 1:00 PM We provide full training, and this assignment...

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand profess...virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through ...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...'Legal Connect' that will serve as a bridge for effective communication between lawyers and their clients. Crucial Task Details: * The app needs to be dynamic and accessible from iOS, Android, as well as Web platforms - a wide reach is essential. * Key features that need to be integrated include: secure document sharing, intuitive appointment scheduling, seamless case tracking, ensuring up-to-date case details at everyone's fingertips. * The project has a strict deadline and needs to be completed and ready for use within a month. Desired Skills & Experience: * Proven expertise in cross-platform app development * Strong understanding of secure file sharing protocols * Proficiency in tracking systems * Experience in developing scheduling tools * Record o...