Excel macro sort data existing sheets jobs
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
...Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools a...
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...
...copy that just sort of outlines the idea, just an AI generated sample cobbled together in photoshop, but for functionality I’m open to changes of course! If you could provide a quote and also a timeline for completion that would be great. If you have any questions, let me know. -------------------------------------------------------------- Skills and Experience: - Expertise in both iOS and Android app development - Understanding of UX/UI design principles - Prior experience in developing art or lifestyle apps would be a plus. Your proposal should include relevant app development examples, especially any related to coloring or artistic designs. I appreciate attention to detail and creativity in this project. Attached is a rough sample made with AI and photoshop to s...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logica...
...working on patent prototypes is a plus. Scope: First 10 hours: - Review existing design and analysis - Conduct initial thermodynamic analysis, heat transfer, and 3kW power calculations - Identify key components and materials Second 10 hours: - Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and press...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...
I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture from the area...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
...thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfe...
Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...
I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I'm eager to hear from you.
As an experienced data entry professional with three years of remote work experience, I am seeking new data entry opportunities from home. My expertise primarily lies in entering customer information, a task I have performed with precision and efficiency in the past. Key Requirements: - Data Entry: Primarily focused on entering customer information. - Software Proficiency: Proficient with Google Sheets. Ideal Skills: - Exceptional attention to detail. - Strong organizational and time management skills. - Previous experience working remotely. - Familiarity with other tools or software for data entry tasks is a plus.
...developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge softwar...
I'll provide you a link to one webpage where the HTML is available that I need to be made responsive across all devices. This means that the layout and content on the site should adjust automatically to the screen size of the device being used. Show me what you did including the new CSS and I should be able to update more pages myself using what you did as a guide. I do not want anything to look much different on a computer/PC screen than it does now. Just make it also work on cellphones, tablets, etc. I'll test your work on the website and ask a few friends to test on their devices then pay you. But I may need more help later which I'll also pay you using Freelancer if needed. Thank you
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.
...provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Front-end Framework: React.js with and State Management + Typescript Styling: Tailwind CSS Back-end Framework: Node.js with Database: MongoDB Goals: Build a cryptocurrency gambling website from PSD + Figma designs and requirements provided and discussed (google docs/sheets). Must be fully secure and fully tested with no bugs or issues. Experience Needed: - Previous experience with Full Nodes ("Bitcoin Core" for Bitcoin and "Geth" or others for Ethereum) + understanding smart contracts - Previous experience making Desktop/Mobile responsive websites - Previous experience accurately converting a PSD design to a fully responsive website using MERN s...
... The photo app will have the following main functionalities: - Setting up a photo shoot job - Selection of a suitable photo shoot date - Selection of additional photo shoot services - Short-term storage of photos - Allowing the real estate agent to download the resulting photos via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts the resul...
I need a desktop software designed to help me collate an...popular New King James Version (NKJV) Bible verses and collation (into Excel or Google Sheets). The output must be in the NKJV and adhere to a strict protocol - The quotation - Source in a specified format (e.g. 2 Kings 3:2-5 - Maximum 55 words Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. We are happy to answer relevant questions for clarification. Ideal Skills: - Native English - Familiarity with the Christian Bible - both Old and New testaments - and various translations - Experience with Bible verse collation or similar projects would be a plus - Familiarity with Excel...
...English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the requir...
As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Efficiency and a keen eye...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. T...
...18 different organizations. You will be looking at the organization's income statements, balance sheets, and cash flow statements from the past year. Your expertise in financial analysis would be a big asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex financial data This job will require thorough analysis and a keen eye fo...
I have an existing WordPress website that needs further development. I'm looking for a skilled WordPress developer to take my website to the next level. The website is already built and fully functional, but now I need to enhance its features and usability. Key requirements: - Review the current website to understand its structure and functionality - Implement additional features and modifications as needed - Ensure that the website is user-friendly and responsive across devices - Potentially integrate e-commerce functionality if not already present Ideal candidate: - Proven experience in WordPress website development - Familiarity with e-commerce plugins and modules - Strong understanding of website design and usability - Excellent communication skills and ability to take...
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...
Start your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites...the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 ...
...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to I...
I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.
I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit usin...
I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.
...critics can create their own web pages within the main site, where they can upload movie posters along with comprehensive metadata about the movies. The homepage will showcase various top critics and their recommendations. General users can browse through these critics, select their preferred ones, and navigate to their individual pages. On a critic's page, users can view movie recommendations and sort movies by various criteria, such as year or genre. ### Project Problem Statement **Project Problem Statement: Development of a Movie Critique and Review Platform** **Objective:** To develop a web-based platform that allows users, specifically movie critics, to publish and manage their own movie critiques, reviews, and recommendations, while providing general users with an ...
...Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • La...
I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English
...generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, i...
...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...
We are a software development company that has developed password management solution. As part of our service offerings, we provide a browser extension that allows users to manage their passwords securely and conveniently. Currently, this browser extension is based on the outdated Manifest V2. The existing extension is based on Angular 1. It is working for Firefox, Chrome and the new Edge browser. To ensure compatibility with the latest browser standards, we are looking for an experienced freelancer to perform the migration of our browser extension to the latest Manifest V3. Project scope: • Analysis of the current implementation of the browser extension • Migration of the extension from Manifest V2 to Manifest V3, taking into account the current functionality a...
I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.
