Vba paste data excel jobs
Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num
For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.
...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. E...
We're in need of a proficient programmer proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search i...
I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...
I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.
macro based excel project with auto copy data and paste in chrome through selinium
Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.
I'm in need of a proficient Data Entry operator who can efficiently handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Workloads will vary, as the work requirements are not on a fixed schedule or volume. Proficiency with data related software is highly advantageous. Excel knowledge is must. If worked on Tools like Zoho etc, it will be preferred.
I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.
I'm in need of an experienced and reliable data entry specialist to assist with a copy-and-paste task. I have myriad data from online resources which require efficient copying and pasting directly into a Word document. Skills & Requirements: - Proven experience in data entry work - Proficiency in Microsoft Word - Strong attention to detail - Quick and efficient in browsing online - Reliable and punctual with strong time management skills This job is perfect for someone who excels at straightforward, repetitive tasks and can do them flawlessly. Consistent work accuracy is a must to ensure the validity and usability of the final data stored.
I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ...
Is a task require basic Excel skills with four tasks in total need it in 5-6 hours
I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...
I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.
This is a simple copy and paste job. I have 28 standard web pages (Words and images) that I need copied into individual Word documents. They consist of headings, words and text. For each web page, you will create a new Word document. The file name will be the number supplied in a table. (For example Page 1, Page 2 etc) You will paste the page URL at the top of the page and the text and photos underneath. Links in the text must stay as links, so I can see where they lead to. Do NOT paste ony of the other navigation on the pages. For example, top navigation menu, side menus and footers. We would like this completed with one day. The bid you provide will be the fee that is accepted.
I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future...
I'm looking for an experienced Power BI professi...Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as a guide. Your expertise in Power BI and data visualization would ...
i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.
I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would ...
I am in need of an experienced Microsoft Excel expert who can create a specialized personnel cost budget template. This template should include: - Automatic calculations. - Cost categories for Salaries and Wages, along with Benefits and Bonuses. Experience in financial modeling and budgeting would be ideal to ensure accurate automatic calculations are set up. You will be creating this from scratch, so creativity and attention to detail are also required. Please provide samples of similar Excel projects you've completed in the past. Adequate knowledge of personnel finance management is a plus.
I am in need of data entry and web scraping experts who can assist me with a project. The tasks that need to be completed include both data entry into a spreadsheet and web scraping for specific information. The final data should be delivered in Excel format. I have a specific deadline for the project and it needs to be completed within a week. Ideal skills and experience for this job include: - Proficiency in data entry and web scraping techniques - Experience with spreadsheet software such as Excel - Knowledge of web scraping tools and techniques - Attention to detail and accuracy in data entry - Ability to meet tight deadlines and work efficiently If you have the necessary skills and experience, please submit your proposal.
I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.
I am looking for an Excel expert who can assist with implementing logical formulas and calculating percentage-based results for different strategies. There are three key strategies that require your attention: Strategy A, Strategy B, and Strategy C. Your tasks would include the following: - Implementing logical operations to enhance data organization. - Entering information pertinent to each strategy. - Calculating and displaying the percentage of each strategy. Ideally, you should have extensive experience in Excel calculations and logical operations. Proficiency in data analysis and reporting is also a plus. I am in need of an individual who can accurately interpret and implement my strategy-focused approach in Excel. Your output will provide a foun...
Core Functionalities 2.1 User Authentication and Manage...tracked. Task Removal: Admin can remove tasks from the system at any time. 2.3 Tracking and Rewards Visit Tracker: A tracker will be placed on external websites to track user visits and send data to the CRM system. Earnings Management: Specific earnings will be assigned to users upon task completion. Withdrawal Requests: Users can request to withdraw their earned amount once it exceeds a predetermined minimum balance. 2.4 Financial Reporting and Admin Panel Earnings Reports: Admin can view total earnings, user-wise earnings, and date-wise earnings. Export to Excel: Admin can export financial reports to Excel. Admin Dashboard: Admin can use a central dashboard to manage all aspects of the CRM add more require...
...need assistance with advanced Excel functions. My project focuses on two main areas: data analysis and usage of specific formulas. Tasks include: - Data Analysis: This entails financial analysis and data visualization. You'll be dealing primarily with fiscal data and you'll need to make the data meaningful and easier to understand. - Formulas and Functions: You'll be carrying out tasks that require an expert knowledge of VLOOKUP and IF functions. An ideal freelancer would be one who's proficient in Excel, specifically with experiences in handling VLOOKUP and IF functions, and someone who has a strong grip on financial analysis and data visualization. A keen eye for detail and ability to deliver accurate resu...
I'm in need of a data scraping expert to extract specific baseball statistics from a certain website. () - **The job will include:** Creating a file that can be executable on command. Could be excel or other that pulls the data required from website ( see file for details). I should be able to pull this data repeatedly over time with the fresh data of the day. - **Ideal skills and experience:** Candidates should have experience in web scraping, especially with sports data, proficiency in a programming language suitable for data scraping (such as Python) and a good understanding of baseball statistics. The website requires a login to get in. This task requires precision and an analytical mindset to ensure the accuracy and rele...
As a client deep within the Arts & Entertainment industry, I'm on the hunt for a seasoned professional. Whether it's a full-time, part-time, or freelance job you desi... or freelance job you desire, this could be your opportunity. Ideal Candidate: - Has significant experience or background in the Arts & Entertainment field. - Can demonstrate their expertise through their previous works and accomplishments. Application Requirements: - It is crucial to list your relevant experience. This shows me your readiness to take on the tasks at hand and your ability to excel in this field. Please note that skipping the type of job you're looking for won't affect the hiring process; what matters most is your capability to deliver, whether as a full-time employee,...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
...an expert in Excel to help me create a jobmatch system. This project involves listing various workfields like a hotel, restaurant, bar, coffeeshop, warehouse, detailsshop, and customer service, and their related job roles on an Excel sheet. The complex part of the project is, each job role needs to be evaluated for similarity with a focus on three major elements: - Hardskills, Softskills and qualifications - Experience and education - Personality traits Moreover, these elements should not bear equal weight but must be individually customized. The weight for each criterion in a jobmatch process should be custom-tailored. Chat GPT can be used to understand the weights for each workfield Ideal candidates will possess: - An in-depth understanding of data analysi...
I'm seeking a...business analyst, skilled in MS Visio, to convert my existing Excel diagram of a business process into the latest version of MS Visio. Specifically, your task will be: - Shifting flowcharts and swimlane diagrams from Excel to MS Visio - Implementing color formatting and thoughtful annotations to the converted diagrams - Ensuring all diagrams maintain a professional and corporate style throughout. The ideal fit for this project would be detail-oriented and have excellent knowledge in MS Visio and business process modelling. Their expertise should be evident in providing sleek, professional, and corporate-looking diagrams. Prior experience in working with similar projects is a significant advantage. NOTE: I will provide the excel file and candida...
I'm in need of a dedicated data entry specialist, who is adept in Data entry of commercial invoices. Key Responsibilities Include: * Accurately entering invoice data into Microsoft Excel spreadsheets. * Ensuring adherence to specific formatting requirements, details of which will be provided upon project commencement. A deep understanding of Microsoft Excel and precision in data entry is crucial for this role. Experience with processing invoices is highly desirable. Attention to detail and maintaining the integrity of confidential information are also essential for this project. Project Description: We have a pressing requirement for a meticulous and detail-oriented freelancer to assist us with data entry tasks. We possess over 15...
I'm seeking a skilled individual who can scrape text content from a PDF. A high level of attention to detail is needed as the data must be accurate. Key Project Requirements: - Excellent web scraping skills specifically around extracting text data from PDF files. - Ability to deliver scraped data in Excel format. - Efficient and accurate data extraction is a priority. Ideal Skills and Experience - Proven experience in web scraping, especially from PDFs. - Knowledge of saving data into Excel. - Capable of maintaining data accuracy. - Familiarity with captcha handling. I'm looking forward to your bid and answering any questions you might have about this project.
I am in need of a service that includes text data entry into Microsoft Excel. The specific requirements are as follows: - Expertise in text data entry. The data to be entered is purely textual, no numbers or alphanumeric data are involved. - The text data needs to be organized in Alphabetical order. A systematic and meticulous eye for detail is required to ensure accuracy and consistency in the arrangement of the text data. - You must have a thorough understanding and extensive experience working with Microsoft Excel. It is the platform where the text data will be entered, sorted, and stored. Accuracy, efficiency, and confidentiality are paramount in this project, hence, the ideal freelancer is a seasoned professional with ...
Seeking a detail-oriented freelancer to help with a data entry project. The ideal candidate should have: - Knowledge and experience entering text data from digital files into Excel. - Experience in Excel table formatting, ensuring the structured and organized presentation of data. - Skilled in data management, able to maintain integrity and accuracy of the information. - Attention to details to avoid mistakes during data entry. This project requires specific skills in Excel and keen attention to detail. Make sure you are comfortable with handling and managing digital files and you’re equipped with good typing speed and accuracy.
I require a meticulous professional to aid in text and numerical data entering into an Excel file. - Data Entry Scope: The workload involves entering 850 rows/5 columns of data into 1 workbook/28 sheets . This is a one-time assignment needing immediate attention. - Skill Set: The ideal candidate would have experience in data entry and a keen eye for detail to ensure accuracy. Proficiency in Excel is a necessity. Looking forward to a productive engagement.
I need an Excel whizz capable of effectively entering and organizing both numerical and textual data in my spread-sheet. You should have: - Proficiency in Excel, particularly with data entry and organization functions. - Exceptional attention to detail, ensuring no data is mismanaged. - A good understanding of organizing data chronologically. Your task will involve: - Inputting a mix of textual and numerical data in an Excel sheet. - Organizing this data chronologically. - Ensuring data accuracy and integrity. Your keen eye for order and structure alongside your Excel proficiency will be crucial to the successful completion of this project.
Data entry project requiring transcribing documents into Excel spreadsheets. Ideal candidate should have experience in accurately transcribing a large number of documents. Preferred format for the transcriptions is Excel Spreadsheet. Project involves transcribing more than 20 documents.
...have attached my excel doc I created but am having trouble getting the results in require. I am looking to implement formulas and pivot tables to an existing Excel document for more sophisticated data analysis. The primary focus is on electrical energy usage. The ideal candidate will have strong skills in Excel with a special ability to effectively use pivot tables and understand energy consumption data. Expected Deliverables • Add formulas, including but not limited to pivot tables. • Design pivot tables to analyse patterns in electricity usage. Skills and Experience Required • In-depth understanding of Excel formulas and pivot tables. • Experience in working with energy consumption data is a plus. I look forw...
...around Data Analysis, specifically focusing on Financial Data. Your responsibility will be to write a Python script on the dataset provided. Key responsibilities: - Reading from Excel or other data files and process them into Python data objects (such as a dictionary) - Write the code to process data as fast as you can - Interpret complex customer data, analyze results using statistical techniques - Develop and implement data collection systems and other strategies for predictive analysis - Assuring the quality of the data used for analysis is optimal - Building algorithms and developing automated processes - Test and QA the software you write and assist with integration if required Ideal Skills and Experience: - Proven ex...
I'm in need of an adept designer to create a basic site plan for my residential driveway. The drawing will include a copy and paste of an existing plan with text addition of dimensions and materials . This is for an initial chat with my local building planning dept. Ideal freelancers for this project are experienced in architectural design and site planning, this is small initial job but may lead to more work as the planning process progresses.
I'm in need of an expert in Power BI who can create daily updated reports sourced from both Excel spreadsheets and SQL databases. A successful freelancer should be resourceful in presenting the data using specific visualization tools like bar charts and line graphs. Ideally, I would want to work with someone who has a good understanding of data analysis and can deliver accurate reports promptly. Key responsibilities: - Source data from Excel Spreadsheets and SQL databases - Create bar chart and line graph data visualizations - Ensure the Power BI report is updated daily Preferred skills: - Proficiency in Power BI - Experience with SQL and Excel - Strong problem-solving skills - Excellent time management skills - Ability to work ind...
I urgently need a skilled data analyst to conduct crucial sales forecasting for Toyota Corolla. You will be tasked to anticipate our future sales, which will directly influence our business strategy. Requirements: - Proficient in Excel and other data tools - Extensive experience in data analysis and sales forecasting - Familiarity with automotive sector is a plus Although the level of detail in the forecast wasn't specified, it would be beneficial to cover a broad scope and drill down as needed. This project needs to be completed ASAP, showcasing your ability to work efficiently under pressure will be positively regarded. Looking forward to working with dedicated and proficient freelancers.
...equipment. - Understanding of electrical-actuated diaphragm valves and electronic monitoring systems. - Expertise in system safety analysis methods like FTA and RBD. - Ability to interpret probability and risk data related to system failures. - Skills to document and present findings clearly and effectively. Software Required: - Arbre-Analyste: For conducting FTA and RBD. (Open Source: ) - Basic Design: For schematic representation and design modifications. (Canva / any) - Statistical Analysis Tools: To process failure data and probability calculations. Use MS Excel. This project involves a comprehensive safety assessment and improvement plan for the critical cooling and emergency shut-off systems of an EDPM in an oil refinery. The goal is to minimize risks, enhan...
...a Microsoft Excel wizard who is skilled in Visual Basic for Applications (VBA). Your primary tasks will include: - Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files) - An excel spreadsheet placed in a folder will be able to... Macro 1 Will list all the files in the current directly in column A Macro 2 Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found) Macro 3 Will open and find the string listed in column A and replace it with the new string listed in Column D Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating m...
... delete/deny/no collect If $ not showing, add/accept/yes collect Extract and collect data for use in MS Excel 2016 YOU: Use SOURCE initial scrape pages, any of these 5 URL/links: Provide me with SAMPLE/EXAMPLE data, ***before anyone is awarded ***Too many candidates (here and other websites) are telling me they CAN DO IT, then hours or days later, telling me no, they cannot do it. ***SAMPLES / EXAMPLE DATA (25-50 records) delivered as PROOF, will be given highest considerations to awarding work/contract
I require an in-depth report on my internship at Anita International, a clothing manufacturing company in Noida. Your task will involve crafting a document that effectively summarizes my experience. The report should primarily cover: - Company and industry overviews - Work experience and the process flow within the organisation, best represented via a flow chart - The learning outcomes...understandings during the course of the internship, along with any noteworthy findings or observations and my subsequent recommendations. Finally, ensure a comprehensive conclusion is part of the report. I'm particularly seeking freelancers with excellent research and report-writing skills, knowledge of process flow diagrams, and a basic understanding of finance. Can use AI tools and cut copy pas...
I need information from previous violent incident data collected from various schools analysed. I will supply the data on an excel data will include instances of both physical violence and verbal aggression between students and staff. The data needs to be compared and contrasted to identify any trends or patterns. Excel pivot tables or similar would be ideal for this simple project for those who are good with manipulating data. Ideal freelancers for this project will have solid analytical skills. Accuracy, thoroughness, and the ability to perceive patterns in data sets are crucial skills for this task.
