Using vba to automate excel jobs
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - ...
...looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work...
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
...architecture decisions for your team. It is your responsibility to drive projects forward, mentor junior team members, ensure alignment with the company’s overall architectural direction, and contribute to continuous improvement initiatives. By delivering innovative and reliable software, you will contribute to the success of our organization and make a meaningful impact to thousands of customers and millions of users. What you’ll do ● Lead and develop high-quality working software, with a solid design and architecture that is consistent with our overall company-wide approach ● Provide technical guidance and mentorship to less experienced team members ● Partner with Architecture and Engineering Director t...
I'm in need of a talented developer to create a robust and user-friendly ERP system tailored for my school. The system should incorporate a range of school-specific features and ensure that it can handle the significant amount of students enrolled (500 or more). Key Features: - **Student Attendance Tracking**: An essential feature that will allow efficient monitoring of student attendance. It should be easily navigable and facilitate real-time updates. - **Gradebook and Report Card Generation**: A feature that will automate the grading process, enabling teachers to input grades and generate student report cards efficiently. - **Parent Communication Portal**: A secure platform through which parents can access important information about their children's acade...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements ca...
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
...looking for someone to build a basic Shopify app that will eventually be integrated with an API that we're developing (may need hep on this, but it's a separate project). We'll need the freelancers to ultimately sign an NDA and IP agreement. There are several important elements we need built, though we are not yet fixed on a development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or si...
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
...365 Suite (MS Forms, PowerApps, Power Automate, SharePoint Online). • Drupal 10 Services: The Drupal 10 project should include features like custom theme development, content management system, user registration and login, search functionality, and issue troubleshooting. - Theme Development: The custom theme should adhere strictly to our corporate branding guidelines and styleguides. • Microsoft 365 Services: The professional should also have expertise in MS Forms, PowerApps, Power Automate, SharePoint Online, and related M365 knowledge and competencies to ensure smooth operation of the systems. In total, this project will involve approximately 400 man-days of work, with 200 man-days dedicated to Drupal 10 services and the remaining 20...
...if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided tw...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
I'm in need of a software programmer who is proficient in Python, Java, and C++ to develop a small-scale software program primarily aimed at automating a specific task. The task itself is relatively simple, but the automation of it is critical to increase efficiency. Key aspects of the project: - The software program must be designed to automate a specific task. It's crucial that the programmer fully understands the task at hand to ensure a seamless integration of automation. - The scope of the project is small-scale, so the focus is on developing a functional, efficient automation solution. - Proficiency in Python, Java, and C++ is non-negotiable. The software is expected to be developed using these languages. Ideal skills and...
I'm in need of a NASAL MASK design whose primary focus is to be both user-friendly and effective in treating sleep apnea. Key Requirements: - Detailed Design with Dimensions: I require a comprehensive design with precise measurements and specifications. This is crucial as the mask should fit comfortably and effectively for the user. - Adjustable Straps: The design must include adjustable straps. This is essential as it will allow the user to customize the fit, ensuring comfort and effectiveness during use. Ideal Skills: - Proficiency in Solidworks: The design should be created using Solidworks, so proficiency in this software is a must. - Experience in Medical Equipment Design: Experience in designing medical equipment, particularly for sleep apnea treatment, w...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, writing, and submission of grant pro...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to...
I require an proficient developer to create a script that can send out automated emails through Gmail. This task should be accomplished with an appropriate scripting language for Gmail's environment. Key Requirements: - Send out notification emails. - The notifications will be for scheduled reminders and service status updates. - Targeted audiences are all users and selected groups. Relevant skills include proficiency in JavaScript (as Gmail Scripts commonly employs this language) and familiarity with Gmail's API. Knowledge of handling scheduled tasks and interaction with user databases is also beneficial. In short, I'm looking for a coding and Gmail expert who can automate the process of sending important reminders and status updates to our users. T...
I am in need of someone with expertise in updating tasks in a digital planner. I would need the freelancer to: - Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so on. I specifically require these tasks to be automated using Power Automate. The ideal freelancer will have experience in digital task management, Power Automate and task automation. This should allow for a smooth update of tasks in my planner without the need for manual input.
...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...
...management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar sol...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a c...
More details: What is the intended purpose of the device? Power automation What specific functions or tasks should the device be able to automate? power grid line control Do you have any specific requirements or features in mind for the power grid line control functionality? Real-time monitoring, Remote control. Develop a hardware prototype for detecting illegal electrical current tapping and automatically shutting off power to prevent hazards.
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to c...
...looking to create a WhatsApp CRM that incorporates a variety of features to improve our customer relations and team management. Key Features: - Scheduling Surveys: The system should support date availability checks, scheduling and booking confirmation via WhatsApp to our staff. Their responses should organise them into yes and no groups. This will help us automate repetitive tasks and sharing of information to groups of people. - CRM Management: I am an agent to film ans supply extras for background. This requires searching for certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send their profile to...
...script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of...
...set up a robust CI/CD pipeline to automate software delivery on the AWS platform. This project is specifically focused on AWS, and ideally, you should have experience with the following: - AWS EKS: The ability to create, manage and optimize a Kubernetes cluster on AWS EKS. - Argocd: Proficiency in configuring and deploying applications to Kubernetes using Argocd. - CI/CD Best Practices: Strong understanding of industry best practices for CI/CD, including infrastructure as code and automated testing. - Monitoring and Logging: Experience with setting up highly advanced monitoring and logging for CI/CD pipelines, ensuring real-time monitoring and comprehensive logging capabilities. Your role will be to design and implement a robust system th...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and findings based ...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
My primary goal is to create a specialized automation software for Facebook. I'm looking for freelancers who have demonstrated experience in this area. Key Requirements: - Automation Skills: I need someone with a proven track record in creating automation software for Facebook. The tool should be able to automate various tasks on the platform efficiently. - Experience: Please provide examples of your past work in automating tasks on Facebook or other similar platforms.
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
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,...
Hi, As discussed in meeting , We are going with Phase 1
I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.
I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.
Hello, I just need a quick solution to send Whatsapp message using twilio API. In my twilio account, I have already [Whatsapp Business Account ID], [Meta Business Manager ID], [WhatsApp number] That is it. Thank you for your time and look forward to working with you.
I'm looking for a detail-oriented researcher to help me gather information on EU and UK investment figures. Requirements: (1.) The no. of people (and total and average volumes (in EUR)) making personal investments each year in the UK (and separately in the EU) by category - stocks, bonds, crypto, on-line investment platforms (and sub-category real estate platforms - debt and equity), crowdfunding platforms, gold, REITS/real estate funds, savings accounts (banks), current accounts (banks), and "other" (2.) Numbers of households (or people if easier) earning between 50,000 and 100,000 or around those numbers." The numbers can come first - I need these urgently - charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particu...
I'm looking for a skilled freelancer who can develop a program for the Click PLC to control a Variable Frequency Drive (VFD) hoist. Key tasks would include: - Implementing a start/stop control which can be manually triggered. - The program needs to possess speed control, allowing adjustments in the hoist's operating speed. - Including direction control within the program functionality would be vital as well. An understanding of PLC programming and specific proficiency with Click PLCs is crucial for this project. Previous experience with VFDs, industrial automation, and manual switch controls would give any potential freelancers a significant advantage.
I'm looking for a skille...frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - Set up the system to run the download process on a monthly basis optimizely on html frotend with a download button Format of the csv: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Strong understanding of CSV data formatting - Ability to create a system for scheduled, monthly data retrieval If you're abl...
