Excel macro copy data columncông việc
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization us...
I need an expert in web scraping, either in Python or by utilizing Google Chrome extension, to extract text data from a particular website. Should be delivered within 3 hours. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
To give you a brief idea the data you are dealing with is for recipe ingredients and I need nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate fi...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...
I'm in search of an efficient Virtual Assistant (VA) to swiftly transfer over 100 product descriptions to my Wix Clothing and Apparel store. Key Responsibilities: - Copy product descriptions - Set product variations (i.e. color) - Define product sizes Project Requirements: - Must be completed within 24 hrs - Ability to accurately copy and paste from digital format - Proficiency in Wix store management - Familiarity in Clothing and Apparel product details - Excellent attention to detail This task will test your speed and diligence. If you have the necessary skills and can work quickly, feel free to bid. PREFER LOWEST RATE
I am looking for an expert in website speed optimization to improve the mobile page speed of my website. The main goal is to enhance user engagement. I believe an improved page speed will keep my visitors on the site longer, resulting in more interaction. Additionally, I need my blog pages laid out in a single column format. This should be optimized to ensure a seamless user experience across multiple devices. While there are no specific responsive elements advised on, the developer should ensure general responsiveness throughout the page, including any present text content, images, or embedded videos. Ideal Skills: - Proficiency in website speed optimization - Experience with responsive website design - Expertise in blog layout design Experience in SEO will be an added advanta...
I'm in need of an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past wo...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the requi...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
I'm in search of an efficient Virtual Assistant (VA) to swiftly transfer over 100 product descriptions to my Wix Clothing and Apparel store. Key Responsibilities: - Copy product descriptions - Set product variations (i.e. color) - Define product sizes Project Requirements: - Must be completed within 24 hrs - Ability to accurately copy and paste from digital format - Proficiency in Wix store management - Familiarity in Clothing and Apparel product details - Excellent attention to detail This task will test your speed and diligence. If you have the necessary skills and can work quickly, feel free to bid. PREFER LOWEST RATE
In need of a skilled native English writer who can help craft SEO-enhanced website content. The primary objective for this project is to boost our site's search engine ranking. Requirements: - Proven experience with creating engaging and effective website copy - Native English proficiency - Understanding of SEO principles and best practices - Ability to write content that is moderately technical, yet accessible to informed readers - Content should be entirely original, without resorting to AI-generated material We need a writer who can utilize their expertise in SEO and content creation to help our website reach a wider audience, while maintaining a level of professionalism and readability for our visitors.
I need someone to replace names and holidays in the calendar I'll send. In InDesign, we need to update the names for the year 2024/2025 from September 1, 2024, to September 1, 2025. It's a copy-paste job, or if you can do it faster, it's up to you. I need it to be error-free. The project is in Slovak, but I have no problem having someone from another country work on it if it's error-free. Payment will be made after inspection. Have a nice day :) You can find the calendar with current names and holidays at the following URL: Template is in format Indesign in attachment.
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliab...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from th...
...effectively, including tips for engagement and extension. Packaging and branding: Design attractive packaging for the activity boxes, including branding elements and clear labeling of contents and age recommendations. Deliverables: The freelancer will deliver a comprehensive package for each educational activity box, including activity materials, instructional guides, and packaging designs in soft copy . Timeline: The project timeline is flexible and can be negotiated based on the freelancer's availability and our business needs. Skills Required: We are seeking a freelancer with expertise in early childhood education, child development, curriculum design, or related fields. Experience in creating educational materials or activity kits for young children is highly desirable....
For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...
...easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any cheating, the application should randomly capture images and monitor video. Skills and Experience: * Strong Python programming skills * Experience with SQL Server * Knowledge in secure login mechanisms * Familiarity with browser disablement methodologies Shortlisted ap...
I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an ...
Hi, I need to link various data between sections in my current Perfex CRM installation. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I've attached an explanatory excel where you can see what data is to be shown in other sections of the CRM. (CRM ) Below you can see what data need to be sync in the Perfex CRM. 1. When creating a Lead-related Task, copy the data [Address] [City] [Description] 2. When creating a Proposal related to the Lead, copy the data [Network] In CRM I created a custom Network field (multiselect) for Leads and Customers and the same field within Proposals as well. When creating a proposal associated with a lead or custo...
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Exce...
Necesito un community manager que realice las siguientes funciones: 1. Diseño en canva de 12 post mensuales y 1 video en canva , para publicar en Instagram, Linkedin y Facebook a través de Metricool 2. Adaptación a formato story 3. Copy de 12 post 4. Interacción diaria 5. Blog mensual y subida a wordpress 6. Diseño y cambio de slider de wordpress 7. Newsletter mensual Solo valoraré propuestas de españoles, es requisito indispensable debido al idioma en el que se hará la gestión.
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be ...
I have a large volume of scanned images in PDF and JPG format that I need to be converted into text documents. The task involves typing out the content from these images into editable...text files. Key Requirements: - An experienced typist with a keen eye for detail to ensure accuracy in the conversion process. - Proficiency in English language to ensure the resulting text is coherent and grammatically correct. - Ability to handle a large volume of content efficiently and deliver within the agreed timeline. The ideal freelancer for this project would have prior experience in copy typing scanned documents and a track record of delivering accurate and timely results. Please be prepared to provide a quote based on the volume of work you anticipate, as the task involves more than 1...
I have a large volume of scanned images in PDF and JPG format that I need to be converted into text documents. The task involves typing out the content from these images into editable...text files. Key Requirements: - An experienced typist with a keen eye for detail to ensure accuracy in the conversion process. - Proficiency in English language to ensure the resulting text is coherent and grammatically correct. - Ability to handle a large volume of content efficiently and deliver within the agreed timeline. The ideal freelancer for this project would have prior experience in copy typing scanned documents and a track record of delivering accurate and timely results. Please be prepared to provide a quote based on the volume of work you anticipate, as the task involves more than 1...
I am seeking a proficient typist to convert my printed English documents into typed format. Nearly 50 to 100 pages need to be completed. - Tasks: The project i...need to be completed. - Tasks: The project involves transcribing printed pages into digital format. All printed documents are in English, and I expect the typed versions to replicate the content accurately. - Skills: A strong command of the English language is parameters. This project requires attention to detail, accuracy, speed, and fluent typing skills. - Experience: Previous experience in copy typing would be an advantage, and familiarization with English written materials should be proven. Bids are open for freelancers who can deliver a top-notch task. Your diligence and expertise are essential to this project&...
As discussed I have completed the template for Home Team Workbook.
I'm in need of an assistant who can help me make a copy of an online course. The course is more than 60 minutes long, and needs to be entirely recorded using Loom. Your main tasks will be to: - Using my loom account you will screen record all the videos in the course (over 30 of them) - You will download all the supporting documents and organise in a google file I'm not looking for any video editing, just a straightforward copying of the course. Familiarity with Loom and Google Docs is a big plus.
Descripción del Proyecto: Registro de Envíos: Seguimiento detallado de cada paquete, incluyendo número de seguimiento, descripción, fecha de recepción en Miami y estado actual. Dashboard de Control: Visualización clara y precisa de la cantidad de paquetes en bodega de Miami, en tránsito y en bodega/aduana. Base de Datos de Clientes: Gestión de información de clientes, incluyendo nombre, número de teléfono, dirección y saldo recargado de tarifas premium. Análisis de Rentabilidad: Generación de costos previstos para cada embarque, incluyendo costos de transporte, tarifas de aduana, impuestos, entre otros. Cálculo de la rentabilidad de cada embarque y visualización comp...
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizatio...
...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product s...
I am looking for a freelancer who can assist me with a copy typing task. The project involves less than 50 pages of handwritten notes that need to be accurately typed out. This is perfect for freelancers with strong attention to detail and skills in transcription. Prior experience with handwritten notes is a plus. Key features of your role: - Transcription of handwritten notes - Affinity for detail - Fast typing speed Looking forward to receiving bids from suitable freelancers.
I am seeking a proficient typist to convert my printed English documents into typed format. Nearly 50 to 100 pages need to be completed. - Tasks: The project i...need to be completed. - Tasks: The project involves transcribing printed pages into digital format. All printed documents are in English, and I expect the typed versions to replicate the content accurately. - Skills: A strong command of the English language is parameters. This project requires attention to detail, accuracy, speed, and fluent typing skills. - Experience: Previous experience in copy typing would be an advantage, and familiarization with English written materials should be proven. Bids are open for freelancers who can deliver a top-notch task. Your diligence and expertise are essential to this project&...
...Key Project Details: - The PDF invoices I frequently deal with come in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you�...
...system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by...
I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets
I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet
Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
Hi, We are looking for a freelancer to send individual emails from an Outlook account to the email list we provide. Email account, emails & names list & the content will be provided. Just need to copy paste & send them (no bulk emails only individual emails). Approximately 5000 emails to be sent. Please quote with you fees for 1000 emails. We will go with a lower bid as it is a very basic task.
I'm in need of a skilled copywriter who can help me craft an engaging advertisement for a residential property. Key Points: - The property is char...copywriter who can help me craft an engaging advertisement for a residential property. Key Points: - The property is characterized by a modern design and style, and I'd like that to be prominently featured in the ad. - The ad needs to be persuasive and compelling, aiming to attract potential buyers and showcase the home's unique features. Ideal Skills: - Prior experience in writing real estate copy, particularly for residential properties. - Ability to understand and communicate the essence of a property's design features effectively. - A strong portfolio demonstrating successful copywriting that has driv...
In need of a copy specialist with marketing experience who can refine copy for a LinkedIn/Facebook post, for a beta product launch. I'm trying to attract trial users, and the communications should be both inspiring and motivational. Essential Responsibilities: - Modify existing copy/create new copy with the goal to better position the product for beta launch to individual consumers - Make any necessary tweaks to website copy on home page, depending on user journey stage (before sign up, after sign up) Ideal Candidate: - a copy expert with experience in marketing. - Previous experience launching products and engaging B2C segment required - Proven ability to craft copy that's both inspirational and motivational
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.
...authority websites - Understanding of the education sector and the ability to tailor SEO strategies to this industry Key Deliverables: - A detailed SEO plan that addresses the improvement of keyword ranking, domain authority, and organic traffic - Implementation of high-quality backlinks on relevant, high-authority websites - Regular progress reports and adjustments to the SEO strategy based on data Ideal Skills: - Advanced SEO techniques - Domain Authority building - Backlinking strategies - Education sector knowledge Please provide examples of previous work in the education sector and your approach to achieving the outlined goals. Can I have a concrete plan for SEO, DA and DR () keywords for music teaching supplies elementary music education books
