Need excel macro jobs
I need to automate the creation of tasks and subtasks in Microsoft Planner from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who c...
I am looking to automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this solution." This version of the message is clearer and more precise,...
In t...business analytics and data visualization to achieve multiple objectives: - Identifying key trends and patterns - Making data-driven decisions - Enhancing data presentation and communication The primary data sources for this project will be Excel spreadsheets, social media platforms, and analytical software, such as PowerBI and Tableau. The desired insights from this project are specifically: - Analyzing closing prices - Gaining a clear perspective of the stock market trends Ideal applicants for this job should be highly skilled in use of Excel, PowerBI, Tableau, and social media analytics. A keen understanding of revenue performance, stock market trends, and closing price analysis is also crucial. Proficiency in communicating data-based insights effectively is ...
I am in need of a proficient data scraper. The ideal candidate will mine and collate contact details, specifically email addresses, phone numbers, and business addresses. The targeted businesses should be choose through a defined criteria: location and industry. Your responsibility will not stop there. You will also need to compile the acquired data into a well-organised Excel spreadsheet - ensuring information is accurately represented and easy to navigate. A meticulous attention to detail is vital in this role, alongside experience in similar data scraping tasks. Skills: - Experience with data scraping - Proficiency in collating and organizing data - Excellent Excel skills - Attention to detail - Familiarity with Shopify and Zomato platforms This is not ...
I'm in immediate need of a Linux expert with advanced problem-solving skills to assist with multiple tasks involving CentOS. - The right professional should excel in troubleshooting and debugging, Linux server administration, and Linux programming. - As the tasks are of an advanced nature, a strong background in Linux systems, particularly in CentOS, is essential. - Prior experience with complex issues is a must. Your challenging role will involve locating and fixing faults, managing the Linux server, and coding in the Linux environment. - If you feel you fit this profile, please apply, detailing your previous similar experience. Your commitment to a streamlined and effective Linux operation will be welcomed here.
As a business owner, I'm in dire need of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal can...
I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find
I need a skilled Excel data analyst to work on sales data. Requirements: - Experience: Please include your previous experience with similar data analysis projects in your application to be considered. Please submit your bids along with a summary of your experience in this field. I will share the specific data once we are in contact.
I have a black and white Excel sheet that dosent look Professional ... I need it to be Colorful and attractive
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
I am looking for a skilled freelancer to analyze the sentiments of the reviews given by the customers in the data and make some useful conclusions. Read ML PROJECT GUIDELINES pdf for full details. Two dataset excel files are given. Project should be done in Sample submission colab notebook. An example project is also given for reference. Complete full project as in the notebook and guidelines. Requirements: - Analyze and categorize sentiments - Visualize the results - Cluster Zomato restaurants into different segments. Ideal skills: - Strong experience in machine learning - Proficiency in data analysis and visualization - Knowledge of sentiment analysis techniques - Familiarity with clustering algorithms
I need assistance with opening a Quickbooks file that was saved in 2009. The file contains important financial data which I urgently need to access. I am currently using Reckon Accounts 2013 Pro and did not keep the earlier versions of the Quicken software. Based in Australia, I have evidence that I own the company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. At minimum I need from you an Microsoft Excel or Libre Calc file of all of the data in its fi...
I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree thi...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont e...
I require both exterior and interior architectural 3D renderings for design development purposes. The renderings need to be detailed, inclusive of texturing, lighting effects, and even furniture and decor. - Freelancers that excel in photorealistic 3D modelling and architectural visualization are preferred. - Experience with a variety of 3D software and sophisticated texturing and lighting techniques is desirable. - The ability to effectively represent scale and layout, as well as a keen eye for interior design and detailing, would be beneficial in this project.
I am in need of a professional to convert a text-only PDF document into an Excel file. The converted document should not just be a direct replication, but should include some modifications to the formatting. The tasks are as follow: - Convert the text-only PDF to Excel. - Reorganize some data sections in the converted file. - Add or delete certain rows or columns as required. Proven experience in data organization, data entry and advanced knowledge of Excel is ideal for this project. Attention to detail is crucial as the final output needs to maintain content accuracy while adjusting the original format.
I'm in need of a creative graphic designer who can help me with designing materials for my product launch and portfolio showcase. Key Responsibilities: - Design a brand new website to promote my product/service - Design print materials to showcase my portfolio Ideal Skills and Experience: - Proficient in website and print design - Previous experience in promoting products/services - A portfolio showcasing previous design work - Understanding of consumer-focused design If this sounds like a project you'd excel at, please submit your bid along with relevant examples of your work. Ideally person should be able to work in illustrator understands that concepts of pixel base and vector base .. Has great knowledge of resolution adjustments. , 2 d drawings and banner cr...
More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.
More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.
I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column a...
I'm launching a project in the medicinal field and am in need of a competent and dedicated research assistant. You'll primarily be dealing with published literature and are expected to perform the following tasks: • Assist in literature reviews in a research topic • Screen search results ibased on a predefined criteria to select studies for inclusion in the review. • Extract data from selected studies using standardized forms and protocols. • Verify the accuracy and completeness of extracted data, resolving discrepancies through discussion with team members. • Summarize and synthesize findings from included studies, highlighting key results and trends. • Participate in team meetings, providing updates on progress, challenges, and insights gain...
...copying and pasting text data within a single Excel sheet, focusing on specific rows or columns. - Brief for This Job - Your primary task is to copy text from specific rows or columns and paste them responsibly where needed. This project will probably only take four hours of your time. (course number + date from + date to) copy paste beside every student name I need it for my database to be in this format video will be send to you to understand my requirement each freelancer will cover 200 course out of 1000 course so 5 freelancers will be hired maximum budget is 16$ for each freelancer do not contact me if your bid more than that submission within 24 hours from awarding the project (failure to submit will considered cancelation of the deal) I need it withi...
I need a dedicated and thorough researcher to help me compile a comprehensive list of local builders, plumbers, electricians, and roofers. Your main task involves finding their emails and Instagram accounts as we need these for marketing purposes. Key Requirements: - The service providers must be local to a specific city which will be provided to you. - The collected information should include the provider's full name, service type, and contact number. - The information should be appropriately organized into a Google Spreadsheet so that it's easy for me to analyze and use. Skills and Experience: - Experience in web research or data mining - Precision and attention to detail - Familiarity with Instagram and ability to find user profiles - Excellent organization...
Have operations based math problems that I need done for a work project. 3 problems that involve aggregate planning, inventory planning, subcontracting, production levels, economic order quantities ect. Strong excel knowledge required where you can run solver.
I'm seeking a talented visual effects artist to create a stunning character transformation scene for my film. Specifically, the scene involves a character eerily morphing into a dead body. Requirements: - Proficiency in c...Proficiency in creature animation, particularly in the realm of morphing effects. - Experience with macabre or horror-themed VFX would be an asset. - Capability to create convincing and visually striking transformation effects, in this case, human to corpse. - Ability to closely collaborate and discuss progress and revisions. This project presents a unique challenge and is ideal for those who excel at creature animation and have a knack for the unsettling and uncanny. Your creativity and distinctive flair will bring an integral scene in my film spectac...
I am in need of a skilled SQL coder to help me join the tables and build a health care report in Excel. The report will focus on patient demographics and medical procedures. Key requirements: - Expertise in SQL coding - Proficiency in Excel for report building - Experience in handling health care data - Ability to merge tables effectively The report should include: - Patient demographics such as age, gender, and location - Medical procedures data The ideal candidate should be detail-oriented, able to follow instructions, and have a background in health care data management. It is important that the report is well-structured, easily understandable and can be updated efficiently.
More details: Do you want the Excel program to convert purchase orders and local stock into separate TXT files? Yes Should the program automatically detect and apply specific parameters for each conversion, or will you provide the parameters? Mix of both Which specific parameters do you need for the TXT conversion of purchase orders? Each order should be a TXT
I am looking for a proficient data analyst who can assist me in providing data analysis using Excel. Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health. Medline has 313 products listed and CVS Health has 892. I need a comparison chart in any format (Excel or Word) that addresses: 1.) how many brand name products are under Medline. List then out. 2.) how many brand name products are under CVS Health. List them out. 3.) how many Medline specific products are under Medline. List them out. 4.) how many CVS branded products are under CVS Health. List them out. 5.) Which products does CVS health have that Medline does not? (Ex: reading glasses) 6.) Which products does Medline have that CV...
I am looking for a skilled and experienced Excel expert to create a detailed and comprehensive Excel spreadsheet which will serve as a trucking business operational tracker. Key Information to Include: - Revenue: Primarily from freight charges. - Expenses: comprising of fuel, maintenance, office expenses and rent. - Profit Margins: Determine the profit margins by deducing expenses from revenue. - Mileage and Fuel Costs: Tracking to determine efficiency and cost-effectiveness. Frequency: - The ideal candidate should create a sheet easy to update on a daily basis. Ideal Skills & Experience: - Proficiency in Excel - Astute attention to detail - Experience with financial and operational data tracking - Knowledge or experience in the trucking industry would be a ...
I am in need of an expert in Excel to create a system for managing my financial and inventory operations. With your specialized skills, I require a streamlined and seamless workflow for my business that includes the following: Accounting: - Managing both income and expenses in a clear and concise manner Invoicing: - Capabilities to create invoices directly within the sheet - Functionality for generating these invoices in a PDF format - A reliable system to track invoice payments Inventory Management: - A method to effectively track stock levels - A simple way to generate purchase orders as needed - A solution for generating sales reports for analysis The freelancer best suited for this project would have an extensive background in Excel, with a special focus on fin...
I would like a chrome (or chromium, edge extension (for my own use, not for sale, not uploading to the store). The extension should be able to retrieve keywords from a given text or excel file and perform one by one google search at a time (line by line). Google AD results will be extracted to a file (the URLs). Give a specific price! Don't ask how much my budget - I've already given my budget limit. That's the maximum.
بالمرفقات أنا بحاجة إلى شخص يمكنه إجراء بعض العمليات البسيطة على ملف Excel الحالي الخاص بي. تشمل المهام ما يلي: - تنظيم البيانات وتصنيفها - إضافة الصيغ والحسابات - اجرائات اخرى
...the species observed. Sighting areas: The system allows users to record the sighting area where the different bird species have been observed. Data analysis: The system should allow users to analyze sightings data, generating graphs showing the frequency of sightings of different species in different geographic areas. Data export: The system allows exporting bird sighting data either in PDF or EXCEL files. Administration of users and permissions: The system allows the administration of users and access permissions, to ensure that only authorized users can access the information stored in the system. Bird sounds: The system has an API that displays the sounds of the birds that have been registered in the system. These requirements can be modified according to the client's n...
Hi Kelvin Writer, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to un...
I need help developing a risk assessment in Excel for my clients. I had one developed for an Ergonomics assessment, now I need to amend this to include additional fields and scoring for Quickchangeover (QC). I need an expert to create a new worksheet, formulas, macros, etc. Review the attached Ergo assessment so you can see what was developed previously and what I need (directionally) the QC assessment to move toward. Are you interested? Read the ReadMe file and look at the docs. thank you.
I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are...
There is an excel file to modify according special rules
...websites with existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, some of the entry is in Japanese. some example of websites we will work with; https://docs.google.com/spreadsheets/d/1iNPQ4Jt2-EFgkaD91vl7e87Se-xG_kSA/edit#gid=185003365 Data from these, need to be joined with another file.
...harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI analytics with a solid understanding of data analysis, predictive modeling, and natural language processing. - Experience with Azure Databricks, Azure Data Factory, and Azure Data Lake storage. - Knowledge and experience in working with structured data. - Familiarity with ML and the Copilot tool. - Experience...
More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering
I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality
I am seeking an experienced and creative fashion designer who specializes in men's clothing, specifically focused on trendy casual wear. Your responsibilities and qualifications would ideally inclu...Excellent verbal and visual communication skills to effectively convey design concepts and ideas. 8. Time Management: Capable of working under tight deadlines and managing multiple projects simultaneously. 9. Fashion Education: A degree or diploma in fashion design or a related field is preferred, but not mandatory. 10. Passion for Fashion: A genuine passion for fashion and a drive to innovate and excel in the industry. Please apply with your resume, portfolio, and a cover letter highlighting your relevant experience and why you would be a great fit for Verve Clothing's bot...
...budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using Excel including complex formulas, calculations and data visualisation - Proven ability in formulating budget plans - Exceptional attent...
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
... 2- Download the information to excel and using chatgpt for excel modify the description of each fair so that the content is original (we will give access to the plugin for excel with enough credits and chatgpt 4). 3- by means of chatgpt for excel modify the date format 4- include a no follow link to the fair in question. 5- (very important) check that Chatgpt does not make mistakes in the description or dates (this happens very often) We will not release the milestone if we see mistakes. 5- Create a dynamic calendar for wordpress that removes the old dates and leave only the content from the date of the current day. You can also use a plugin if it exists. Very important: - Each calendar has between 300 and 1000 entries, we need 7 calendars. - ...
I'm in need of a skilled professional who can help me showcase live game data directly from an Excel spreadsheet on my WordPress website. Key Requirements: - Real-time data update: The data should be updated on the website as soon as changes are made in the Excel file. Ideal Skills: - Proficient in Excel: The freelancer should be well-versed in Excel in order to effectively parse and represent the data in a user-friendly manner. - WordPress Expertise: A solid understanding of WordPress is essential to ensure the data is displayed correctly on the website. - Experience with Real-time Data: Previous experience in displaying real-time data is a huge advantage. I don't have a specific plugin in mind for this task, so I'm open to suggestions...
...responsible for cold calling leads in our database, following up and closing new accounts. You will will be expected to make an average of 70 or more outbound calls per day. You need to take accurate notes, follow up promptly and keep track of your job is remote, and you will need a quality internet connection. Representing tinyB with politeness, professionalism and a sense of excitement Following up with and closing sales inquiries, quotes, and basic sales service as it pertains to business orders and events. Take accurate notes of your interactions Manage your time between cold calls and follow ups Work with Excel and Google Sheets Provide feedback to management and maintain the database according to the company’s guidelines WHO YOU ARE Honest and tr...
I need a proficient Python developer to create a stock and options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an...
