Example macro excel automatically fill information workbookpekerjaan

I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of

This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If ...

I need a trained professional to compose a formal legal letter. The objective of this letter concerns: - Requesting specific information from a business. (Please see info below) - Expressing my role as a conference attendee at this institution, indicating I have occasional interaction with them. The freelancer should be savvy in legal communication, specifically in drafting letters for information retrieval. Familiarity with conference related legalities would be an advantage. The tone should be professional, respectful but assertive and the communication should be clear that it’s from a qualified lawyer. Please see attached screen shots of communication below. For context the “team member” is my ex girlfriend who is making totally false and made up clai...

I need a trained professional to compose a formal legal letter. The objective of this letter concerns: - Requesting specific information from a business. (Please see info below) - Expressing my role as a conference attendee at this institution, indicating I have occasional interaction with them. The freelancer should be savvy in legal communication, specifically in drafting letters for information retrieval. Familiarity with conference related legalities would be an advantage. The tone should be professional, respectful but assertive and the communication should be clear that it’s from a qualified lawyer. Please see attached screen shots of communication below. For context the “team member” is my ex girlfriend who is making totally false and made up clai...

Sila Dafter atau Log masuk untuk melihat butiran.

I'm in need of a talented UI/UX designer to develop a seamless and visually ...Approach:** Understand and cater to the specific needs and preferences of professionals in a specific industry. - **Information Accessibility:** Ensure that the website is designed to provide a smooth and intuitive experience for users seeking information and resources. - **Visual Appeal:** Incorporate a bright and bold color scheme to add vibrancy and make the content engaging. -**Having 7 to 8 pages having some level of animation. I'm looking for a proficient designer with experience in creating user-friendly and visually appealing websites. The ideal candidate should be able to understand and design for a professional audience. Experience with bright color schemes and information...

I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a good fit for you.

I need an Excel expert to create an advanced sheet for employee management. This sheet would primarily serve two types of employees, sales and telecallers, and perform multiple significant tasks. Key Features: - The sheet should calculate sales data and commissions. - It must track daily leads assigned to the sales team. - It needs to generate reports on business shared between telecaller and sales teams. Design Requirements: - The design should be simple and minimalistic. - It must have color-coded cells for easy interpretation and usage. As the Excel version was not specified, the sheet should ideally be compatible with multiple versions to ensure smooth operation. Ideal Skillset: - Advanced knowledge of Excel. - Experience in creating sophisticated Excel...

Following are the requirements of task to be fulfilled. 1- Task is to visit the address physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If Renal group does not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name and Contact)

I'm in need of an experienced app designer to create the UI for a rebranded version of an existing app, tentatively named "Psmilin". This app is designed to gamify information gathering and I'm looking for an engaging design that will cater to children, teenagers, and adults alike. Key Requirements: - You should be able to design mobile app screens that will be engaging and intuitive for all age groups. The app will include features such as a leaderboard, badges, achievements, and progress tracking. - The design should be able to seamlessly blend gamification elements with the core purpose of information gathering. - You will be provided with a screenshot of the current app, and I need you to use that as a starting point for the new design. Skills and E...

I'm looking for a solution to automatically populate PDF templates with sequential numbers starting from '1'. The objective is to automate the assignment of these numerical identifiers onto the document, which will significantly improve the efficiency of the overall process. Key Requirements: - The implementation should cater to numerical sequential numbers (1, 2, 3, etc.). - Numbers should start from '1'. - There should be an option to reset the numbering sequence at the start of each new document. Ideal Skills and Experience: - Proficiency in PDF editing and formatting - Prior experience in automating tasks in PDF documents - Ability to develop a user-friendly solution that can be easily implemented.

I'm in need of a creative and interactive website for my business. The main aim of this site is to educate visitors about what my business is all about. Key Requirements: - The site should be captivating and engaging. - It must effectively showcase my business in a way that the visitors can understand and connect with. - I'm looking for a unique and creative de...website stand out from the crowd. Ideal Freelancer: - Experience in creating informative websites. - Strong portfolio in interactive and creative web design. - A good understanding of the modern web design trends. - Proven track record in designing websites that educate the audience effectively. Please include your experience in your application. I'm looking forward to seeing your proposals. FOR EXAMPLE...

I'm looking for an AI expert to create a tool that can automatically convert Tamil news content into engaging, short video summaries. The goal is to capture the audience's attention through visually appealing and informative videos. This tool needs to provide: - High Customization: The videos should not be cookie-cutter; they need to be unique and engaging. - Unique Animations: I want the videos to stand out with original, creative animations. Ideal Skills: - AI & Machine Learning: You should have a strong background in AI, particularly in natural language processing and video creation. - Video Editing: Knowledge in video editing software to create visually appealing and engaging content. - Tamil Language Proficiency: Fluency in Tamil is a must for this project.

I'm looking for a developer to create an airdrop script specifically for Solana SPL. The main aim of this script is to distribute tokens to a specific, pre-selected group of Solana SPL addresses/wallet. The script/app able to read the list of addresses/wallet from txt or Excel . The distribution needs to be fully automated, without requiring any manual intervention. The amount of tokens need to be specific or random from 100 to 1000 etc. Also be able to adjust the Sol sending fees. Key requirements: - The script should be designed to distribute tokens to only a specific, pre-selected group of Solona SPL users, not all users. - It should be fully automated, meaning the distribution process should not involve manual intervention. Ideal skills and experience: - Proficiency in de...

New freelancer welcome, I'm in need of a virtual assistant to help with my project , quick copy-paste job. My need video clip copy and pasts Excel sheet. I will give video link just need copy time clip. Ideal Candidate: - Proficiency in copy-pasting tasks - Ability to complete the task within a few hours - Experience in virtual assistance would be a plus. Looking forward to working with you! More discus with freelancer chat. Need strong freelance. Thanks

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understandi...

...design should be in various shades of navy blue. Your Expertise: - Proficient in graphic design, with a keen eye for minimalist vintage aesthetics. - Experience in creating bespoke artworks for clothing. - Ability to work from photographs to capture the desired feel and style. Specific Instructions for use of attached photos: - I need vector art to give to a t shirt maker - This design should fill the ENTIRE back of the t shirts - the shirts will be cream or pale yellow - I'd like the graphic to be in all shades of navy blue...ideally with a "washed out / vintage look" to it (like it's been through the washer forever) - The centerpiece of the design should the Stotesbury Cup trophy - an ACTUAL PHOTOGRAPH of this tropy is attached under file "Stotesbury ...

...someone with extensive knowledge and proficiency in automation and HR system development, providing innovative solutions to recruiting issues. Key Features Needed: - Automatic Job Posting: Automating job postings is crucial. This will minimise manual errors and save time, making our hiring process more efficient and effective. - Auto-responding to Candidates: The system must be capable of automatically responding to candidates, ensuring they receive timely correspondence, contributing to a positive candidate experience. - Powerful Job Submission Form: The form should include the job title, job description, and required qualifications. The precise presentation of these details is critical for attracting the right candidates. Freelancers who have earlier implemented a similar sys...

...and they're releasing a big update (v5.0) in a month or two that makes it a lot faster & stable to use, so I think it's a good choice. For the first site, you'll need to create a simple version of the site (maybe in Figma), more than a wireframe but less than the final version, as we don't have all the information / content from them yet, but we can at least get started. We will use ai generated images and content as filler and just do our best to come up with a "rough draft", and then fill it in as we get more content from them. For now, these are the pages we need: Home Products (we have two with specs for now) Industries Blog About us Contact Us I've built plenty of sites in the past and could build this myself but I want ...

I'm seeking a highly skilled market researcher to conduct an in-depth analysis of emerging technologies within the technology industry. Your main responsibilities will be: To find the tools that I need, fill up all the details that I will supply in a spreadsheet and deliver. The ideal freelancer for this project would have: - Proven experience in market research, specifically within the technology industry. - An understanding of critical emerging technologies trends. - Excellent data analysis skills. - Experience using common market research tools and databases. In order for me to know that you read the requirement, please begin your proposal with "Perfect" This project will provide valuable insights into potential opportunities in the emerging technologies marke...

I'm looking to enhance the functionality of my website by integrating a taxi booking form. More specifically, the form’s main purpose should be to calculate fares based on the distance between points A and B. A unique element that is crucial for this project's success is the introduction of editable fare fields. These fields shouldn't only be automatically adjusted by the system but should also allow for manual input by users. This hybrid approach should provide flexibility and user convenience. For the user interface of these fields, I envision a text field solution, where users directly input their estimated fare. Ideal candidates for this project should: - Have extensive web development experience along with an understanding of fare calculation mechanisms. ...

Develop a Google Apps Script that automates task management and extension tracking based on predefined conditions. The script interacts with a Google Sheet containing task information and sends data to designated webhooks for automated notifications. It also auto-extends deadlines when required Project Objectives: Webhook Automation: Trigger webhooks to send data to specific endpoints based on conditions such as due dates and task status. Auto-Extension: Automatically add extensions to task deadlines when conditions are met, providing flexibility for users. Error Handling and Logging: Ensure robust handling of date parsing and add logging for tracking script execution and diagnosing issues Key Components Google Sheet Structure: The spreadsheet contains task-related data, i...

I'm looking for a data entry operator who can assist me with cleaning, verifying and entering a small volume of data from handwritten documents. - The task involves verifying data for accuracy, identifying and correcting errors, and entering the information into an Excel or CSV file. - The data volume is small, around 1,000 records, making it an ideal project for someone who is detail-oriented and meticulous. Ideal candidates should have: - Experience in data entry and data cleansing tasks - Proficiency in using Excel or CSV files - High level of attention to detail - Ability to work with handwritten documents If you possess these skills and are interested in working on this engaging project, please submit your proposal.

I am seeking a reliable and meticulous individual to assist with completing online surveys. This role involves using specific provided information to accurately fill out survey forms on various topics. Responsibilities: Log in and access online surveys using provided credentials. Accurately enter pre-provided details into surveys. Maintain strict confidentiality and integrity of all information. Meet daily and weekly survey completion targets. Address and report any issues encountered during the survey completion process. Requirements: Stable internet connection and access to a computer. Strong attention to detail and ability to follow complex instructions. Prior experience in data entry or survey completion is preferred. Understanding of confidentiality and data pr...

...solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the “same number of...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(coun...

Sila Dafter atau Log masuk untuk melihat butiran.

I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.

...- **Real-time Inventory Sync:** The integration should ensure that the inventory levels displayed on my Shopify store are always up-to-date with those from my supplier, Supplier A. This will help prevent overselling and ensure accurate stock levels are visible to our customers. - **Automated Order Fulfillment:** When a customer places an order on my Shopify store, I need the integration to automatically notify Supplier A of the order details and initiate the fulfillment process. This will help streamline the order processing and reduce manual intervention. **Requirements:** - Experience with Shopify API and integration. - Proficiency in developing real-time synchronization systems. - Prior experience in automated order fulfillment processes. - Ability to obtain API access from ...

Sila Dafter atau Log masuk untuk melihat butiran.

...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...

...around the use of the Super Trend and the Exponential Moving Average (EMA). Key features that the strategy must incorporate include: - Application of EMA for defining trend direction - Integration of Super Trend for possible entries and exits - Implementation of profit-taking mechanism; I would like to place a condition where once a certain percentage of profit is hit, all trades should be automatically closed. Although there's an option for selecting other indicators like MACD, RSI, or the Stochastic Oscillator, I only want the Super Trend and EMA to be featured in my model strategy. Hence, skilled freelancers should have deep knowledge and experience in crafting custom strategies on TradingView, especially involving these two indicators. A background in trading and an un...

...create QR code images from uploaded CSV files containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data ...

I'm looking for a skilled professional to design and develop an automatic umbrella that integrates with a backpack. The primary goal of this system is to provide protection from rain, with no need for hands-on operation. Key Features: - **Automatic Opening and Closing:** The umbrella should deploy and retract automatically, triggered by a manual button located on the backpack. - **Seamless Integration:** The design should ensure the umbrella fits the backpack seamlessly, with a compact and lightweight design for easy portability. Ideal candidate should have: - **Experience with Wearable Technology:** A background in developing wearable gadgets would be highly beneficial. - **Mechanical Engineering Skills:** Proficiency in designing mechanical systems, especially for compact,...

I'm looking for a tool that can automate the process of listing Amazon products onto my eBay account. Me and other sellers, got a HUGE issue with posting the items manual and I WOULD like to be able to have something to make my job easier. Key Features: - Automatically import products from Amazon to eBay Ideal Skills: - Proficiency in Amazon and eBay APIs - Previous experience in developing automated listing tools - Strong understanding of inventory management systems Budget is £100, please don't bid if you can't do it for this price. The app reference for this job is: I want literally a tool with this options.

...losers information, fostering an engaging user experience reminiscent of Binance's intuitive dashboard design. 3. Dynamic MYCOIN Price Management: • Admins have the flexibility to adjust the price of MYCOIN (pump price) in real-time to reflect market conditions and strategic objectives, ensuring price transparency and responsiveness. 4. Reward Distribution: • Admins can distribute rewards in MYCOIN to users directly from the backend, incentivizing user participation and loyalty within the platform. 5. Integrated Investment System: • A comprehensive investment system is integrated, allowing users to invest in MYCOIN and other supported cryptocurrencies. Users can track their investment structure and status through the user dashboard. 6. Automated Reward Mechani...

I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python

I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...business. The ideal candidate will be able to seamlessly navigate and offer insights on Marketing, Sales, and Operational strategies. Key Requirements: - A solid track record of success in business consulting, particularly in the areas of marketing, sales, and operations. - Strong understanding of strategic planning and tactical execution. - Ability to synthesize and present information effectively, with both a macro (general overview) and micro (detailed, step-by-step) view. - Proven experience in delivering high-quality, actionable insights that drive business growth. You should be comfortable offering a blend of strategic and tactical advice, as my needs will encompass both. Your role will be to provide guidance that is both broad-reaching and detailed, combining a ...

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft E...

I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.

Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?

I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...

...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...

...and processes within my business. The software should be able to automate data entry and report generation. Key requirements: - Data Entry Automation: The program should be able to automate data entry tasks effectively. It should be able to process data from various sources and input them accurately. - Report Generation: The automation program should also be capable of generating reports automatically. The reports should be detailed and insightful, using the data retrieved from the data entry process. The automation program will need to use CSV files and databases as data sources. The program should be able to extract data from these sources efficiently and manage it effectively for the tasks assigned. Ideal Skills & Experience: - Proficiency in automation programming - E...

I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.