How to sort sheets in excel 2016 jobs

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your b...

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

I'm in need of someone who can breathe new life into my supply chain material position excel sheets. Here are the specifics of what I'm after: - Improved Formatting: The overall layout and design of the sheets need a complete overhaul to enhance readability and aesthetics. - Clear Headings and Labels: Make vital information instantly noticeable by introducing clear and concise headings and labels. - Consistent Color Coding: Utilize color coding to clearly distinguish varying points and sections, ensuring coherence and ease in navigation. - Sheet Layout Redesign: I seek a thoughtful redesign that couples functionality and design effectiveness, making the excel sheets intuitive and user-friendly. - Conditional Fo...

I'm looking for a skilled freelancer to develop a customized net worth spreadsheet. This spreadsheet should enable me to meticulously track my financial progress across various categories. Key Requirements: - The spreadsheet should allow me to input and monitor: - Investments (especially individual stocks) - Debt - Savings - Income - Expenses - Other category for miscellaneous expenses or income - I require a simple, user-friendly design that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment track...

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/edit#gid=1503373653

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector...

...Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old Quotations: Users should be able to access and make changes to previous quotations. - User Management: The system will need to support 1 admin user with the abi...

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep unders...

I'm in need of a diligent and reliable virtual assistant to assist me with a range of tasks. Here's an overview of the key responsibilities and requirements: - Data Entry: The ideal candidate will be comfortable handling medium volume data entry tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledg...

I'm in need of a skilled Unity developer who can bring to life a 3D visualization of moving points. The purpose of this visualization is educational, aimed at explaining the concept of trajectory. Key requirements: - The visualization will involve moving points in 3D, following a trajectory that's dictated by data in an Excel file. - The movement of these points should be adjustable by the user in terms of speed. The ideal freelancer for this job would have: - Proficiency in Unity, with a strong background in 3D animations. - Experience in creating educational visualizations. - The ability to integrate data from an Excel file into the Unity project. Please note that while the visualization is primar...

...management, budget tracking, and document sharing. The primary function of this software will be to drive project efficiency by keeping all project details organized, deliver real-time budget oversight, and facilitate instant file exchanges. This tool is intended for use by my project managers and office administrators. Consequently, the ideal freelancer for this task should possess a strong proficiency in cloud-based software development, particularly those intended for construction project management. Your experience should also extend to designing user-friendly interfaces that cater to the needs of project management and administrative professionals. Web Application A cloud-based platform designed to streamline project management, financial trackin...

...delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into ...

...research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • D...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, henc...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the ...

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like F...

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be ...

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a skilled designer with experience in 3D Max and AutoCAD for an urgent architectural project. The main focus of this task is the detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural ...

I need an automation expert to streamline my data entry process on Google Sheets through app script. Key Requirements: - The automation is triggered when the number is input in the cell. - The data source for this automation will be online forms. - we have three google sheets. and the same scenario where we need to triggered a message via Twilio. Ideal Skills and Experience: - must be able to show the demo. - Proficiency in Google Sheets and App Script. - Experience in automating data entry processes. - Knowledge of Twilio and Whatsapp API is a plus.

I’m seeking a professional Virtual Assistant for 10-20 hours per week to assist with the following: - Calendar Organization: Coordinating personal and business events in Google Calendar. This requires excellent attention to detail and prompt updates to avoid schedule conflicts. - Event Planning: Must be able to plan and execute all details about various types of events. This will require excellent communication skills and adept use of Google Calendar. - Task Prioritization: Helping me sort through my daily tasks and prioritize them on Trello. The candidate needs strong decision-making and organizational skills to effectively categorize tasks based on their importance and urgency. Ideal candidates will have excellent time management s...

I'm looking for a Google Sheets expert to help me automate a process involving day by day data input process I'm seeking a freelancer who can streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google Sheets: You should have in-depth knowledge of Google Sheets and be able to manipulate data effectively. - Automation Skills: Experience in automating processes in Google Sheets is essential. Feel free to ask any questions, and please provide relevant examples of your past work. Thank you.

...belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Training": Each training is characterized by: name: The name of the training. description: A description of the training. start_date: The start date of the training. end_date: The end d...

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

...analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financial feasibility...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

LegalSearch aims to be an artificial intelligence-based application that enables effective search and analysis of legal decisions. This application aims to provide users with fast and accurate access to information in legal documents by using OpenAI's GPT integrated search engine. LegalSearch aims to be a valuable resource for legal professionals, students, and general users. Objectives and Benefits: Save time and effort with effective search of legal decisions and documents. Accelerate legal research processes and support decision-making. Facilitate users' access to accurate and up-to-date information in the legal field. Assist legal professionals in their analytical work to form stronger legal arguments. Ap...

...communications agency based in London, specialising in public affairs, policy analysis, media relations, and crises communications. We also organise events on behalf of European trade bodies including an annual awards ceremony for a leading sports nutrient association which takes place in London. We are looking for an experienced Event Organiser to provide essential administrative and logistical support for the team in the UK and EU either on a freelance or fixed term contract to deliver an awards ceremony in London in December 2024. You will need a positive, can-do attitude, and be able to flex your approach and make decisions at speed when required. You will perform well under pressure and possess great attention ...

...proficient translator to translate a set of approximately 100 documents (Safety Data Sheets for the cosmetics ingredients, appr. 3-4 pages long) from Japanese to English. The originals will be delivered in pdf and the translations should be delivered in Word files. The sample of three files for translation is attached, The ideal candidate should possess the following skills and experience: - Proven experience in translating technical documents from Japanese to English, - Strong command of both Japanese and English languages, - Attention to detail and ability to ensure precision in translation, - Previous experience in translating technical documents. The translation does not need to be certifie...

...data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data managem...

I require the expertise of a proficient Odoo ERP freelancer to assist in migrating data from an old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticulous, and possess a pr...

I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropri...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing

I'm in need of a professional who can create comprehensive financial reports for my business. This project requires someone with: - Proficiency in financial report writing - Understanding of financial data and its sources - Experience in writing income statements, balance sheets, and cash flow statements Please bid if you can deliver high-quality, accurate reports.

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

...structure in a tight timeline. Workshop documentation must be prepared in the following standard: - Sheets on a separate sheet - Each sheet is in a separate file with the .dxf extension, drawn at a scale of 1:1 in such a way that the points do not overlap and there are no gaps (polyline) - H profiles, square tubes, rectangular pipes on a separate sheet I am sending the sample documentation and a sample drawing of a shipping detail in PDF. You'll be provided with the necessary project requirements and it will be your responsibility to translate these into comprehensive fabrication drawings. These drawings are crucial for the construction process, so precision and attention to detail are a must. The ideal candidate should be...

I need a professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel...

I'm in urgent need of an experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a simila...

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.