Excel pull data from another worksheet jobs

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...

...proposition pitch deck. Here's what I'm looking for: - Background Design: The current backdrop looks bland. I want it changed to a professional and minimalistic design that can make the presentation more appealing without diverting too much attention away from the content. - Layout: The slide layout needs improvement. It looks cluttered and unorganized at the moment. It'd be great to have it arranged in a clear, straightforward manner to accentuate the important points and make it easy for the audience to follow from one point to another. Please import icons or logos to improve the presentation. Leave spaces where you think it would help to have my photo or other content. - Formatting: The text, graphs, and flow charts appear messy. I need them to ...

...Custom WordPress Plugin Project Overview: Custom WordPress plugin required to allow a user to view data from a database table in a user friendly way. PHP Version: 8.2 and above Number of Shortcodes: 1 (we will be inserting the shortcode into various pages & posts to display the plugin functionality. Overview of plugin functionality: The purpose of this script is to retrieve a list of matching records from the db table & display this data in a clean and user friendly way. Process Flow: - Use shortcode attributes on the page/post to quickly retrieve matching records from the database table - If there are matching records display the data in a clean in-post widget - If the request returns NO data, hide the in-post widget - S...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

I need an immediate migration from GoDaddy to another hosting provider, most likely Hostinger, for my WordPress website. The primary reason for this migration is to tap into better performance capabilities that my current hosting provider is unable to deliver. Key Requirements: - Faster Loading Times: The new hosting provider should be able to significantly improve my website's loading speed. - Higher Uptime Guarantee: I need strong assurances that my website will be up and running almost constantly. - Improved Security Features: I require enhanced security measures to protect my website and its data from any potential threats. The ideal freelancer for this project should possess the following skills and experience: - Proficient in WordPress migrations - ...

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

I'm looking for a data entry specialist to help me clean up a small dataset of less than 1,000 entries. The data is currently in Excel/CSV format. Key Responsibilities: - Reviewing and cleaning the data for any inaccuracies, inconsistencies, or redundancies - Ensuring data is formatted correctly and in line with the provided guidelines Skills and Experience: - Experience with data entry, especially data cleaning tasks - Proficiency in Excel/CSV file manipulation - Attention to detail to ensure data accuracy - Ability to follow instructions and meet deadlines This task is straightforward and brief, making it perfect for someone who can dedicate a few hours to it. Please provide your relevant experience when applying.

...react native app and laravel developer who can make changes in mobile application and its backend web admin panel: 1. Need each project description 1 or 2 lines at the very beginning before the containers and need an option in backend panel to enter that info 2. If we go into each interest or project we will see multiple campaigns here first of all i need all this campaigns in a line one after another or in a column and now each campaign will have its own set of pictures which user can see via slide 3. Further i want to change the look and feel of the container i have reference available 4. Secondly each user has its own donation history which you can see right here i want this particular rows showing particular transaction clickable through which user can see their particula...

...through voice commands and assist in carrying out everyday tasks. My focus is to have a voice assistant that is both functional and easy to use, but I would be willing to work through the learning curve if needed. When the user opens the program, it should be possible to use it with/without an account. I will teach the program to do actions. It should be possible to memorize actions to send to another user by email as a computer file. I would change the names of buttons on settings. 7 days will be free to use it, but later it should be possible to use the program only after payment by card. Key Functionalities: - Set reminders: The voice assistant should be able to set reminders for the user based on voice commands. - Web search: The tool should be able to conduct web searches b...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer ...

I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full...

I'm in search of a meticulous data entry specialist to help with a simple text data entry task. The job is quite straightforward, involving the transfer of information from digital files to a different format. The role strictly involves data entry without the need for any form of data analysis. Key responsibilities: - Accurately entering text data from digital files into a specified format. Ideal Skills and Experience: - Proven experience with data entry. - Attention to detail. - Proficiency in working with digital files and transferring data.

...tool will be to check if the numbers on my list are active on Whatssap. The end goal is to utilize these numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a...

... - The Skills Required: 1. Strong grasp of course development tools, methodologies, and practices. 2. Excellent understanding of PDF, PPT 3. Ability to add company branding to the material. You will need to copy and paste and format the material into a PDF and 5 PPT based on chapter. - The Project Scope: 1. Convert the provided PDFs into a consolidated PDF with just the required information from the specific pages of information provided. 2. Create a series of 5 PPTs to represent each chapter of the course. Your expertise in the field will help in creating a course for adult learners. You will be relied upon to transform the content of the static PDFs to help assist in the creation of the new course. This job needs to be completed no later than Friday, April 12th. All mater...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I am seeking a proficient developer to create an advanced website data Reader The tool should Read the following information daily prices and another data That I would explain later. Ideal skills for this project consist of: - Extensive experience particularly with this task - Proficiency in data formatting. - StormProxies - PHP - Python - RocketSoruce API - Server Management The output format should be compatible with Magento 2 API. This project demands a high level of accuracy to ensure the scrapped data is both comprehensive and precise. Please bid only if you can fulfill these requirements.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

I'm looking for an expert who can accurately create 3D models of buildings from drone images captured by DJI Mavic. The models should be ultra-precise, reflecting high details, complete with fixtures, textures, and shadows. Knowledge and experience in using advanced 3D modeling software such as pix4d or agisoft would be advantageous. Requirements - Prior experience in 3D modeling from drone images - Expertise in using advanced modeling software (pix4d, agisoft) - Attention to detail - Ability to interpret and work with high resolution images. This project requires a keen eye for detail and a strong understanding of architectural design elements. Please provide samples of previous similar work when bidding.

My colleague and I at Magner Occupational Therapy are looking to build an online educational platform for kids and teenagers with learning disabilities. We are currently looking for an animator to...for an animator to help us create short, step-by-step video models to teach essential daily living skills to people with autism and other disabilities. This is a niche market with a lot of room to grow. Our research shows that simple animations where a task is broken down into simple steps are the most effective method for audiences of young age to learn these skills. I have provided a link to another platform that offers a similar service to what we are aiming for. Pickle system offers educational animation clips that operates based on a monthly subscription model.

...diligent professional to handle the daily update of our inventory data. The primary purpose of this task will be to generate purchase orders based on the stock levels at any given time. The data for this update will be sourced from various channels, which include supplier invoices, our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry...

Hi there, I am currently working on a few projects. As a busy professional, I need someone who is capable of creating simple portfolio pages that showcase my projects. On another freelance site, I am having a hard time getting clients and I want you to work with me together to organize the current project files I have and get images of work done, a portfolio title and a description created for my other freelance profile to showcase all kinds of tasks I have done. I have completed over 61 projects and we need all of them organized and input in my g drive. Start date: Today Time: Now Availability: beginner level freelancer someone who is capable and free to get this done.

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - St...

I'm looking for a freelancer who can write a 12 liner poem for me in Tamil. The poem should be derived from a video I share with you. I have 100 videos and budget is 1500 only... Only if you are aware of tamil language you can do that otherwise you cant do that. Dont ask for increase budget

...receptionist could select a free agent and forward the call from the panel or do it through the physical keypad of her phone (for example # 250) - For each customer call, the receptionists would receive a card showing their name, telephone number, comments, purchases made (date, time, amount, minutes, payment method), calls made, and available balance of minutes. - The customer balance system would consist of minutes that would be automatically deducted when speaking with agents (not receptionists). The client's balance would be indicated by a voiceover at the beginning of the call. The way to buy balance would be through the IVR gateway, during the call through the receptionists, or through a php script to which the OK data from the banking web gateway would b...

My VPS is full and I need to change my hosting to a public cloud from OVH. I need someone to do this quickly without shutting down the site. They'll have to advise me on which offer to take and explain what's going to be done.

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonu...

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I purchased a source code from codester for a mobile application and I'm looking for an experienced app developer to add some new features. Key modifications include: - Integrating a payment gateway into the app - Incorporating the Facebook SDK for enhanced social media functionality The ideal candidate should have: - Extensive experience in mobile app development for both iOS and Android - Previous work on integrating payment gateways and social media SDKs

Hi there, I am currently working on a few projects. As a busy professional, I need someone who is capable of creating simple portfolio pages that showcase my projects. On another freelance site, I am having a hard time getting clients and I want you to work with me together to organize the current project files I have and get images of work done, a portfolio title and a description created for my other freelance profile to showcase all kinds of tasks I have done. I have completed over 61 projects and we need all of them organized and input in my g drive. Payment: 4 AUD Start date: Today Time: Now Availability: beginner level freelancer someone who is capable and free to get this done.

...hope to create a simple zone map of this city clearly marking out the placement of each development. The zone currently has some existing infrastructure part of this commercial park (including a golf course and club house, hotel resort and spa, a primary school, and a conference center) and the remainder of the zone will be developed into commercial space, education facilities, office blocks, another hotel, small laboratories for pharmaceutical companies, supermarkets, restaurants, residential housing for rent and so on. This commercial zone is focused on attracting businesses in the Biotech and Fintech industries. This mini city will be designed with a "one-stop-shop-approach" in which everything you need is in one place (commercial, retail, tourism, entertainment, spo...

...process) across different shopping platforms. Specifically, I am looking to move my products from Shopify and Takealot to Amazon (South Africa). Key Responsibilities: - Guide me on the processes involved in migrating the products from Shopify and Takealot to Amazon without any loss in information. - Assist in mass uploading of products across different platforms. Key Requirements: - Proficient experience in product uploading and migration on e-commerce platforms, with a strong emphasis on Amazon. (Experience in uploading products that have never existed on Amazon before ) - In-depth knowledge of Shopify, Takealot, WooCommerce, and Amazon. - Ability to efficiently move products from one platform to another without losing any information. Your role will be ...

Hi I need to very basic example on how to call a rest api from Aveva using a put command. It should be build importing .net libs.

...on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain data accu...

Redraw plan / elevation from pdf to dwg not using automatic software / check dimension and scale PLS MAKE REAL OFFER only after looking attached file - redraw all pages

We don't want our employees to see the phone numbers of customers on whatsapp and chat with them. We just want to restrict whatsapp usage to making calls only without visibility of the numbers. So best is that if the GUI of WhatsApp Desktop is not visible and we access it using another app. Either from browser or another windows app. Alternative is that we do this with android app

Don't show the whatsapp app or atleast hide the numbers and don't allow users to access chats. Only allow whatsapp calls with no number visibility and settings change. The goal is to allow users to make whatsapp calls only to the saved contacts only. So can you modify whatsapp or run in hidden mode to use it using another app.

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would gre...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete thes...

...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

...comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this project will involve making recommen...

I am looking for a skilled developer to implement ...site. Specifically, users should be redirected to another website once they click the 'Process Order' button. Along with this, certain order details need to be transferred to this redirected site too. The deliverables are: - Creation of a redirect action at the 'Process Order' button click, leading users to a different website - Transfer of specific order details to the redirected site. The details to be transferred include the item name, quantity...... and store name Ideal candidates will have experience in WordPress development, and have previously worked on similar redirect functions. Familiarity with transferring site parameters is also preferable. The developer must ensure the proper functioning and secu...

looking for some one expert on python and how to use huggingface models llama3 an how install any model from huggingface and create API with python with JSON to consume it by Another and have experianse on tranning LLama3 to make it able to learn i want this expert to train a team from 4 people online to do this - know the basics of llama3 - how to use huggingface models - create API with python with JSON to consume it by Another - training LLama3 to our own data