How to extract data from different sheets in excel jobs

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and ...

i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.

Add macros in existing Excel file

I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.

I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and atte...

I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experie...

I need to have a python script prepare for Zerodha's Kite API platform to broadcast same orders from one account to mutiple accounts. The final work would looks like this See the video and let me know if you can create this ? I have python codes for login, Orders and etc. Products Requirement. – Copy Trade (decoded) Overview : Copy trades from one account to another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL...

I ha...tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability ...

The developer must be able to create an app that can ... 1. open a video of a wrestling match. 2. app will be able to "mark" various spots within the wrestling match that will interest an evaluator. 3. the marks are created by clicking on a button where the evaluator must go to review. 4. The app will create a score using Google Sheets. We are seeking a skilled video editor to mark several training videos using a custom screen. The marked areas will not only serve copyright protection interests but also provide necessary instructions to aid in understanding video content. Key tasks include: An ideal candidate would have noteworthy experience editing training videos and a solid understanding of copyright protection. A flair fo...

I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with se...

I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating striking visuals, this project is for you.

This project aims to automate the order confirmation process for transactions using Pipedream, a workflow automation platform. Data Source: API request Project Steps: Data Capture: Upon receiving a API request, Pipedream will extract the following information: Order number Customer name Email address Order date Mobile number Pickup address Drop address Google Sheet Integration: The captured data will be automatically stored in a designated Google Sheet for record-keeping and future reference. Multi-Channel User Confirmation: SMS Notification: Pipedream will trigger an SMS confirmation using and , notifying the customer about their order details. WhatsApp Notification (Official API): will be integrated to send a WhatsApp

I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - ...

I would like to hire a professional to extract and organize Amazon Seller details using web scraping techniques. After you find the company name on Amazon, i need you to scrape the web for their contact information since Amazon wont disclose it on Specifically, this project involves: - Extracting Amazon seller information from the website -Use that Amazon seller information to scrape the web for email and contact details - Organizing the data in an Excel spreadsheet The main goal of this exercise is to generate leads from this data. Ideal Skills: - Proficient in web scraping techniques - Ability to handle and manipulate data in Excel - Experience in lead genera...

For the new version of an existing application, we have 4 XD projects with different scenarios with desktop and mobile version that need to be transformed into XHTML. Here are some details: - we want responsive pages - no javascript except if it comes from bootstrap - please note that the top bar is almost always the same, it must be the same XHTML code - there is a breadcrumb trail that changes color as you progress Desktop version : The 1st project () and 2nd project () are almost the same except for the beginning. The 1st is an account creation. The 2nd is when the user already has an account. for the 1st XD project : - page 1 ignore this - page 2 account

I'm in urgent need of skilled VHDL/Quartus professionals from Pakistan for a project. I will clarify the specifics once a mutual understanding and agreement is reached. Ideal skills for the job include: - Proficiency in VHDL/Quartus - Ability to design, troubleshoot and optimize digital circuits - Ability to work independently or with minimal supervision - Excellent communication skills to effectively explain intricate concepts or problems Experience level can range from beginner to expert. The expectation, however, is the ability to deliver quality work within the stipulated time-frame.

need someone who can improve a linked profile from all aspects to make it more professional and visible

More details: Is this project for business or personal use? This question was skipped by the user What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can'...

We are seeking a meticulous freelancer to assist us in a data extraction and verification project within the aerospace and airplane domain. The primary task involves extracting and separating text from an Excel sheet column, ensuring precision as automated methods have proven insufficient. The extracted paragraphs must align accurately with the content of the original PDF files provided. Additionally, the freelancer will be responsible for populating other Excel sheet columns with relevant information derived from keywords associated with the content. Key Tasks: Text Extraction and Separation: The freelancer will meticulously extract and separate text from an Excel sheet column, ensuring only relevant paragraphs pert...

As requested by direct message, this is the quote for conversion of Smart Money Concepts indicator from TradingView to NT8.

Good day, We please need a Freelancer to create a WebM video from an existing and purchased Premiere Pro template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have...

Good day, We please need a Freelancer to create a WebM video from an existing and purchased Premiere Pro template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot

I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.

I am seeking a skilled graphic designer who can recreate the checklists, cheat sheets, and infographics found on a in .eps and .ai vector formats. This will include about 50 selected items. Just text and layout. No challenging graphics recreation. Your work will involve: - Helping me finalize the selection of items based on a few that I have already identified. - Feasibly reproducing the exact designs in .eps and .ai vector formats. I’d like the ability to customise the colors easily after delivery. Ideal candidates should have proficiency in creating vector graphics, a keen eye for detail in replication work, and be ready to collaborate on the selection process. It’s critical that the created vectors are near exact replicas o...

...file needs to be an exact replica of the photo, with high detail and must be fully editable. Key requirements include: - Expertise in graphic design and using Adobe Illustrator - Ability to convert a photo into an AI file that is an exact replica with high detail - Attention to detail and precision is a must to maintain the quality of the photo in the AI file - Experience in providing editable AI files is highly preferred, as the file will be used for future editing. XX PLEASE SHOW THE SCREENSHOT OF AI WITH EDITABLE ALL LAYERS XX Please provide examples of similar projects you have completed in the past, and a brief overview of your experience with this type of work. The project deadline is {insert deadline here}. If you have ...

...allows users to upload DWG (AutoCAD Drawing) files and receive JSON-formatted data containing information about every layer, including x and y axis data. 2. *User Requirements:* - The software should provide a user-friendly interface for uploading DWG files. - Upon file upload, the software should process the DWG files and extract data from each layer. - Users should have the option to specify the output format (JSON). - The software should ensure compatibility with various DWG file versions. 3. *Functional Requirements:* - Extraction of Layer Data: - The software must parse each uploaded DWG file and extract information about every layer data, like height width distance between two layers. ...

...freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You wi...

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm seeking a skilled Java developer to create a (Web Scraper and Analyzer) for my project. 1- i need it to work on eclipse 2- i need the program written in a (GENERIC code) 3- you must use data structure 4- i need you to simplify the code for me as you can 5- i need to ask you simple Questions like what data structure did you use, why this data structure not other, and lastly i need the Pros and Cons for the selected data structure.

I'm seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation processes, an...

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Das...

...streaming app using Flutter. Our aim is to provide users with a seamless entertainment experience, offering a wide range of content including novels, series, and movies. Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development e...

I am looking for a skilled freelancer to assist me with online data entry from scanned documents. The documents I have mainly contain text. Key Responsibilities: - Accurately transcribe text from scanned documents into an online format - Ensure data is entered with high accuracy and attention to detail Ideal Candidate: - Proficient in data entry and transcription - Has experience with converting scanned documents to digital text - Pays attention to detail and is accurate in their work

- I am in need of a website that displays the concerts from jazz venues in the Netherlands and Belgium. - I will scrape the websites of the jazz venues myself and will upload the data to a Google Sheets file. See file here: - I have designed the website myself in Figma. PDFs of design attached hereto. - Preferably based on Wordpress, but open to other suggestions. - Scales nicely on mobile devices (i have only designed for a desktop frame) and works in different browsers; - Website contains one web page: the home page and a concert popup overlaying most of the screen when activated. - No third party paid licences should be required to run the website. - Google analytics and mailchimp integration

...on numerical data analysis from Key Responsibilities: - using futu openapi to collect real-time data (Hong Kong market : Warrants, CBBCs, Inline Warrants, Options, Futures) to Analyze and interpret complex numerical data - visualize the data into graph example : Hang Seng Index CBBC real time Bull 16.26 Bear32.41 today real time transaction amount (million) Total Qty Bull 1711.55 Bear 2667.41 Total issuance ratio Bull39 % Bear61 % proportion of transactions is Bull 33 % Bear 67 % Worthless Bull Worthless Bear 17800 - 18028 Waiting Worthless Bull 17201 Bear 18038 Points to Worthless Bull 545 Bear 292 Hang Seng Index, 17730, futures 17683 Distance from the ...

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciate...

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

I'm in need of a skilled web scraper to extract tabular data from a specific website. The task is a one-time project as the data is needed for a one-off analysis. I Need a webscraper to download all data i have credentials for this (but this link will not open other than my laptop . we will discuss all inside data is aroung40GB. you can message for further details Key Requirements: - Data Extraction: The primary goal of this project is to extract tabular data from a website. You will need to develop a custom scraper that can accurately and efficiently extract this data. - Data Formatting: The extracted data should be clean, well-formatted, an...

In this project, I need an experienced 3D design artist who can take a 2D design and transform it into a high-detail 3D model, with fine details and intricate designs. The model will be used for 3D modelling specifically. Desirable experience should include: - Proficiency in 3D modelling and design - Proven ability to generate high-detail models based on 2D designs - Expertise in using Blender software for optimal results The finished 3D model should be fully optimized for use in Blender. Showcasing examples of previous similar projects will significantly improve your chances of winning this project. Be ready to impress with your skills!

Hi I think i have a bad from my email address. I host at "hobohost" so maybe that's the problem. Need to fix the issue to make my emails deliverable to all email clients.

...accounting for payouts) is done through Google Sheets. I'd like to explore the potential of Airtable (and possibly other platforms) as a replacement. Objective 1 Consolidated Spreadsheet/Database. I currently use a spreadsheet (Google Sheets) for each photographer when assigning jobs. This requires excessive data movement and tracking. If feasible, I'd like to construct a spreadsheet/database where all the data is consolidated. Access by users (photographers) will be confined to the jobs they are assigned. Ideally, a more centralized and manageable solution can be put in place for assigning, tracking, and making payments on jobs. Objective 2 Automate the Job Creation Process as Much as Possible We complete ...

I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is cle...

I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick tur...

I'm on the lookout for someone proficient in using PowerShell scripting in conjunction with Power BI for a personal project of mine. The primary function of this project revolves around data extraction and analysis. Specific Responsibilities: - Extract data from local files - Analyze this extracted data using Power BI Ideal Skills and Experience: - Extensive knowledge and skills in PowerShell scripting - Proficiency with data extraction and analysis with Power BI - Experience working with local files is quite crucial for this job. This is a brief summary. More specifics will be shared upon commencement. I urge you to only bid if you are confident in your PowerShell and Power BI abilities.

I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)