Macro excel cells Jobs

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with this project.

I need assistance with converting various Excel, Word, and PDF documents, making up a total of 32 pages, into a comprehensive and printable directory. Here's what would make you a great fit for this: - Proficiency in data entry and conversion between formats. - Strong skills in Excel, Word, and creating PDFs. - Experience in building and formatting directories. - A track record of delivering high-quality, print-ready documents. Key Tasks Include: - Collation and organization of information from different files. - Conversion of these files into a uniform, printable PDF. - Quality checks to ensure formatting remains consistent and ready for print. Please bear in mind, the final directory is not intended to be searchable. It should be built and formatted for printing wh...

I require a professional with a meticulous eye for detail and proficiency in spreadsheet tools, such as Excel, to handle my data entry project. The data, which needs to be manually inputted, will be derived from scanned documents. Your role will primarily involve re-typing the content into neat and orderly spreadsheets. Ideal skills that you must possess include: - Speed and accuracy in typing - Proficiency in data entry and management - A keen eye for spotting errors or inconsistencies - Familiarity with spreadsheet tools like Excel - Ability to handle confidential information if it arises Your previous experience with similar projects will be a definite advantage. Kindly ensure you include it in your proposal. Please also highlight your availability and estimated timefr...

I need assistance with Excel, specifically with its worksheet formatting feature. My main goal is to create tables and charts to visually represent my financial data. The perfect freelancer for this job should have extensive experience in data visualization, especially when it comes to: Creating accurate formulas displaying in a clean manner

I'm seeking a freelancer with outstanding Excel skills to compile a comprehensive list for personal contacts. The required data for each contact includes: - Name - Address - Phone number It's essential to meticulously organize and enter the required data into the spreadsheet. Precise attention to detail is crucial to ensure no errors are made when adding the details. While there isn't a specific order for the data I will provide you with, I expect clear and uncluttered presentation will be kept as a consistent standard. The ideal freelancer should have: - Proven experience with data entry - Keen attention to detail - Excellent organizational skills - Proficient Skills in Microsoft Excel. If this sounds like you, I encourage you to bid. Let's ge...

I'm looking for a skilled freelancer who can develop a comprehensive Excel dashboard for tracking financial performance. This will primarily involve creating charts and visual representations of the following data: - Sales Data - Expenses Data - Profit Data The main purpose of this dashboard is to facilitate easy tracking and visualization of our financial performance. Ideally, successful freelancers will have: - Relevant experience creating Excel dashboards for financial tracking - A deep understanding of accounting principles

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

I'm in need of a developer to help me transform the tables on my web platform into a downloadable Excel sheet. This needs to be done in a way that the Excel sheet maintains the same order and all data fields as seen on our website. Job requirements: - Extract all data fields from our websites data tables - Develop a downloadable Excel sheet functionality for each table - Ensure the data maintains the same order as on the website - Use PHP and Javascript languages Key details: - Users are expected to download updates on-demand - The Excel sheet should be styled to match the website's design I'm looking for a developer who is proficient in both PHP and Javascript and has prior experience working with similar data transformation projects. Attent...

I require a solution to fetch real-time stock prices from the National Stock Exchange (NSE). The fetched data should populate in an Excel spreadsheet and refresh every second. Key Responsibilities: - Scrutinize the dedicated NSE platform to fetch live stock prices - Develop a method to automate data update in Excel every second Mandatory Skills: - Proficiency in Excel, with particular emphasis on data extraction and automation - Knowledge and experience of the NSE online system - Familiarity with automatic data retrieval and real-time updating This project must maintain a high standard of accuracy, as any mistakes could lead to misinformed financial decisions. Hence, meticulousness in data management and understanding of stock market trading is paramount. I look ...

crear un libro de Excel que me permita gestionar mi negocio de compra y venta de materiales a nivel internacional. Aquí te detallo lo que necesito: Hoja de Proveedores y Clientes: Esta hoja deberá enlazar a mis proveedores, que están organizados por países, con los materiales que ofrecen. Además, deberá mostrar a los clientes que pueden comprar estos materiales identificándolos por países y dándome un campo en donde poner su puerto mas cercano.(para el proveedor y cliente) Hoja de Productos: En esta hoja, necesito identificar a los proveedores que venden un material específico, organizados por país. Necesito realizar cálculos para determinar el volumen en toneladas adquirido y el precio por tonelada...

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

Set up MailWizz and run several tests to verify that bulk sending emails is working properly. The personalization of emails consists in include information extracted from the Excel file (MailWizz ) and insert it into the text of the email (MailWizz Test ) Likewise, the freelancer will teach how it works to be able to carry out the next campaigns autonomously. To do this, the freelancer will make a video tutorial.

I am searching for an Excel expert to help me create a dynamic visualization dashboard for health data. - The dashboard will focus on a range of health data - It will need to display specific and diverse health metrics such as age, type of therapy given, time periods, and mortality - so be able to calculate mortality, time periods, - Each individual's health record data will be detailed in a specific manner ie data will be entered as numeric code -Each patient will have about 20 data points Ideally graphs will have consistent coloring eg PD patients orange, HD = green etc- to allow for intuitive understanding The ideal freelancer for this project needs to have: - Proficiency in Excel, especially in creating dynamic and interactive dashboards. - Experience working w...

I'm seeking an experienced freelancer with expertise in Excel and data management. My project involves merging 5 sheets into one and matching up all of the data lines to be merged. Key Responsibilities: - Keeping the same layout as the source documents during the merging process. - Merging data from different documents in new columns in one sheet. Ideal Skills: - Proficiency in MS Excel and data manipulation. - Experience in creating and managing complex spreadsheets. - Attention to detail. Please provide examples of previous similar work in your proposal.

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

I am looking for a data expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3c...prior to transformation, ensuring they are structured correctly. - Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical. Ideal Candidate Skills & Experience: - Experience in data manipulation and transformation using Excel and CSV formats. - Proficiency in data cleaning and standard standards application. - Attention to detail to ensure entries are formatted correctly. All Question has 2 - 4 answers with multiple right answers wich are marked by an X The Excel i published is...

I have a set of printed documents that need to be converted into an excel file. The data primarily consists of text, and the excel sheet has 1-5 columns. Key Responsibilities: - Inputting data from printed documents accurately and efficiently into the excel sheet - Ensuring that the text data is correctly organized within the specified columns Ideal Skills and Experience: - Proficiency in typing and data entry - Experience with Excel or other spreadsheet software - Attention to detail and accuracy to prevent errors - Ability to handle and convert printed documents to digital format Your work will be essential in transforming this printed data into a digital, easily accessible and analyzable format.

I need professional help to accurately enter and organize text data in an Excel sheet. The text has to be arranged in alphabetical order. I'd also appreciate some expert input in making the document more readable with the appropriate font styles. Ideal Skills and Experience: - Proficiency in Microsoft Excel including formatting - High accuracy in data entry - An understanding of best practices when it comes to data organization - Strong attention to detail and ability to follow specific instructions Requirements: - Type text data into Excel Sheet - Organize data in alphabetical order - Apply appropriate font styles to improve readability.

crear un libro de Excel que me permita gestionar mi negocio de compra y venta de materiales a nivel internacional. Aquí te detallo lo que necesito: Hoja de Proveedores y Clientes: Esta hoja deberá enlazar a mis proveedores, que están organizados por países, con los materiales que ofrecen. Además, deberá mostrar a los clientes que pueden comprar estos materiales identificándolos por países y dándome un campo en donde poner su puerto mas cercano.(para el proveedor y cliente) Hoja de Productos: En esta hoja, necesito identificar a los proveedores que venden un material específico, organizados por país. Necesito realizar cálculos para determinar el volumen en toneladas adquirido y el precio por tonelada...

...a professional who can extract data from my searchable text PDF files and input them into Excel. The PDF files contain complex data layouts, including tables and images. Key Requirements: - Extract and organize the text, tables, and images from the PDF files into Excel - Maintain correct data alignment and structure - Apply basic Excel formatting, such as font styles, cell borders, and column width adjustments You are expected to: - Have experience with PDF to Excel conversions, particularly with complex layouts - Be proficient in handling searchable text PDFs - Demonstrate knowledge in basic Excel formatting techniques I'm looking for a freelancer who can efficiently convert these PDFs into Excel without compromising the data integrity ...

Keyword research with up to 1 alternative and corresponding search volume for the languages ENG, FRA, ITA and target markets England, Italy, France. Please enter the exact search volume, not from... to... as displayed by Google Ads Alternative can be an alternative spelling or a synonym. The subject are... Alternative can be an alternative spelling or a synonym. The subject areas are 'casting' and 'forge' Keyword 1 is the preferred keyword No 1:1 translations, it's about keywords, search intentions and not terminology. Keywords in the target language can also be longer or have a different order. The corresponding keyword in the target language may be missing. COMMENT: Please fill out the Excel file containing 157 Keywords Instructions can be found ...

As an individual dealing with financial data, I am in need of an expert who can perform a time series analysis on specific financial ratios. This task will be performed in Excel and will require expertise in: - Data manipulation - Forecasting techniques - Time series analysis, specifically with financial ratios The ideal candidate should have solid experience in forecasting and weighted moving average (WMA) methods. Due to the nature of the project, a background in finance or a related field would be advantageous. This job is best suited for individuals familiar and skilled with Excel operations, especially in relation to time series analysis. Proficiency in dealing with financial data is a paramount because the project focus is entirely on financial ratios. Your skillse...

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

I am seeking a skilled and detail-oriented Excel specialist to assist with data entry, data analysis, and formatting. Your job scope will require the following: - Accurate data entry into Excel. - Proficient use of SUM, AVERAGE, and COUNT Excel functions for detailed data analysis. - Knowledge in formatting Excel worksheets to ensure cohesiveness and professionalism. The purpose of this task is to effectively organize a large amount of data. The ideal candidate should have strong strategic thinking and problem-solving skills, as well as advanced Excel competencies within data organization. Previous experience in similar jobs will be a plus.

I need a skilled freelancer to copy and paste data from several websites into an Excel spreadsheet. Key Requirements: - Proficiency in data entry - Detail-oriented and precise - Familiarity with using spreadsheets Please deliver the data in the spreadsheet format. Let's discuss the specifics and get started on this project.

I need an advanced Excel spreadsheet created, compatible to both Windows and Mac. It will be used primarily for team collaboration, and should have the following key features: - Real-Time Editing: The ability for multiple team members to edit the sheet simultaneously, reflecting changes in real-time. - Task Highlighting: An in-built mechanism for highlighting overdue tasks, enabling focused teamwork and timely task completion. - Report Creation: A feature that allows the easy conversion of the sheet into plain text. The report should maintain much of the original formatting for clarity. - Task List: An organized task list creation feature, enabling team members to assign and keep track of tasks efficiently. The spreadsheet should also be editable as part of a shared worksheet on T...

I'm in search of an Excel expert who can create a specific quotation formula for my window and door shop. The formula should: - Calculate per square meter cost - Incorporate various variables, including item price, quantity, discounts, profile price, glass price, mosquito net price, Extras, and installation - Categorize 'Extras' to include delivery and customization fees Ideal professionals for this project would have significant Excel experience, particularly with complex formula creation. Knowledge of cost calculation and financial modeling would be beneficial. Efficiency and attention to detail are key in this project.

I'm looking for a diligent data entry professional to assist with transferring text from various online sources into a structured spreadsheet format. Key Points: - The task involves pure text en...The task involves pure text entry, requiring accuracy and attention to detail. - The data will be sourced from online content, so familiarity with the web and online research is preferred. - The final output should be a well-organized and error-free spreadsheet, most likely on platforms like Excel or Google Sheets. Ideal Candidates: - Proficient in data entry with a keen eye for detail. - Comfortable navigating online sources and extracting information. - Skilled in using spreadsheet software like Excel or Google Sheets. - Able to complete the task accurately and within the ...

I am looking for a data entry freelancer to transcribe handwritten notes into a spreadsheet. Key Responsibilities: - Accurately transcribe handwritten text into a spreadsheet format - Organize and format the data in a clear and structured manner Skills and Experience: - Proficient in data entry, especially from handwritten sources - Experience with spreadsheet software like Excel or Google Sheets - Attention to detail is crucial to ensure the accuracy of the transcription - Ability to work efficiently and deliver quality results within the agreed timeline. Please note that the data will be provided in handwritten notes, and must be transcribed into a spreadsheet.

...check our their training on their last version: ) Job description: 1. Based on a Excel sheet containing translation to a package label saying, the designer will have to generate: a XML file containing the different language version to be applied on the package. The Excel sheet will contain 5 languages (all written from left to right): - Portuguese - Spanish - English - Polish - Greek 2. Based on an existing trilingual AI artwork (sample attached) I'll share the designer will have to map the artwork with the correct placeholders for the label sayings in different languages sheet. 3. Each block of text in the excel sheet will be numbered. Each block of text in the AI file will be numbered as well (for easy correspondence) 4. The deliverables

I'm in need of an Excel wizard capable of constructing a precise, data-driven model specific to marketing data, as well as supply and demand. Key functionalities are to include: - Data Visualization: Proficiency in translating raw data into visual charts and graphs. Your work should result in a model that effectively communicates complex data in an easily digestible format for decision-making purposes. - Formula Calculations: You must be familiar with advanced Excel formula calculations to manipulate and compute data in ways that align with our specific market information. - Scenario Analysis: High proficiency in scenario analysis is key. Able to put together various ‘what-if’ scenarios in the Excel market model, taking into account different variab...

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

I am in need of a brochure designer with a knack for classic and traditional designs. The main purpose of this brochure is to promote our product/service and highlight the key benefits. Ideal Skills and Experience: - Expertise in traditional graphic design - Proven exper...Detail-oriented with excellent visual storytelling abilities Key Project Requirements: - Design a brochure with a classic and traditional aesthetic. - The brochure must effectively promote our product/service. - The design must highlight the benefits of our product/service - Creation of deliverables should be done in a timely and organized manner. This is a fantastic opportunity for those who excel in creating compelling, traditional design visuals that tell a product's story. I look forward to seeing ...

I'm in need of an accountant to handle our company's financial tasks in Gurugram. The primary responsibilities would include bookkeeping, financial statement preparation, and tax filing. Key Responsibilities: - Regular monthly bookkeeping. - Preparation of monthly financial statements. - Timely and accurate tax filing. We currently use Excel spreadsheets for our accounting, so proficiency in spreadsheets is essential. Experience with QuickBooks and Xero would be a plus, as we might decide to transition to one of these platforms in the future. The ideal candidate would be detail-oriented, organized, and able to work efficiently to meet our monthly accounting deadlines. Experience with corporate accounting and regulations in Gurugram or India would also be highly valued....

Making a Excel based data model (based on some raw tables), will have to make a similar version of existing data model (that will be shared) by the end of Thursday (11th April) i..e in 2/3 days Existing model attached! Currently I have excel with tables of information

I'm seeking a freelancer specializing in PDF ...financial data. - **Project Goals:** - Achieve impeccable accuracy in data and calculations. - Ensure all documents meet professional standards in design and readability. - **Skills Required:** - Proficiency in PDF editing tools (Adobe Acrobat, etc.). - Strong grasp of document design and formatting. - Expertise in Excel or Word for potential conversion. - Keen eye for detail, especially with numbers and calculations. Conversion of PDFs to an editable format like Word or Excel may be requested; please indicate your ability to perform such tasks. This is not just a job but a precision task for someone who considers document perfection an art form. If you possess the necessary skills, I'm excited to collaborate and a...

data entry freelancer who can prepare excel sheet

I am seeking a skilled and creative shoe designer to create a compelling sneaker design specifically for the young adults demographic. My intention is to make a cutting-edge fashion statement, making this project ideal for designers who excel in creating trendy and edgy designs. Key requirements include: - Extensive experience in sneaker design - Strong understanding of current fashion trends, especially towards young adults - Ability to communicate concept ideas effectively - A portfolio that showcases previous work in the fashion footwear sector. Coupling your creative flair with function and fashion, the design should appeal to its target age group, while still demonstrating durability and comfort.

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in financial modeling & excel charts I am looking to visually present selected commodity market data. The work is to creat a few excel line charts. More details will be given once the contract has been given. Key Details: (1) Data source: (2) Line Color: Baby Blue (3) Original excel .xlsx file is needed

As the client, I need an expert who can create a comprehensive Excel dashboard with specific functionalities. - The dashboard should have the capability of data visualization and creation of pivot tables. - It will be populated from two data sources: Excel files and a Database. The ideal candidate should have proficient Excel skills, experience in data visualization, financial and sales data analysis, and database management. I am optimistic that through this project, we can simplify data analysis and decision-making processes in the future.

Hey there, I'm working on a 2D Mobile Game for Android and iOS. I created a prototype for the game some years ago, please take a look at the trailer here: Now I'm looking to expand the game, and need a background artist for the levels. As you can see in the original release, I decided to go with a space theme. It would b...importantly, I want the backgrounds to be able to evolve dynamically over time. Please take a look at Tetris Effect as a reference for dynamically evolving backgrounds. Of course, the background can't be too distracting, as the player will need to focus on the gameplay elements as well. Once again, please look at my references for some examples. If you feel this is a project you would be able to excel in, please get in touch.

I'm looking for a proficient freelancer with impeccable typing and Excel skills. Key responsibilities include: - Typing text data into an Excel sheet. - All data for entry will come from scanned documents. - Accuracy and attention to detail are crucial as the provided material may not be of high resolution. Please note that the dates should be formatted as DD/MM/YYYY. Ideal skills and experience for this job would include: - Proven experience in data entry. - Excellent knowledge of MS Excel. - Strong attention to detail. - Experience working with scanned documents would be a considerable advantage.

Potential freelancers -Skilled in financial modeling & excel charts I am looking to visually present selected commodity market data. The work is to creat a few excel line charts. More details will be given once the contract has been given. Key Details: (1) Data source: (2) Line Color: Baby Blue (3) Original excel .xlsx file is needed

I require assistance with numeric data entry. The source of this data will be printed documents. The project entails meticulously entering this data into an Excel file. Ideal Skills: - Proficiency in data entry - Familiarity with Excel - The ability to accurately interpret printed numerical data Experience: - Previous experience with Excel-based data entry projects - Handling numeric data from printed sources is also preferred. Accuracy and attention to detail are critical for this project. I look forward to working with a competent and reliable freelancer.

I need support to pull specific data fr...second contact being an Office Manager, General Manager, or Operations Manager Use the Rate My Agents List, Go on the Businesses Website to get contact details, Copy and Paste Business name into ABN Lookup to get ABN and Legal Entity Name Example attached on excel of what information needs to be on the list from the first spot on the list. Additionally, the data extracted should meet a specific criterion: sales volume. Ideal freelancer for this task would be someone who: - Has strong web scraping skills. - Is very proficient with Excel and data organization. - Has prior experience with data extraction projects. - Is able to apply specific filter (Sales Volume) in the data extraction process. Quick and accurate work will be hi...

I need a freelancer with strong Excel skills for text data entry. The job requires accuracy and attention to detail, as it involves straightforward input in an Excel Spreadsheet. There's no need for specific formatting, making it an ideal gig for those with experience in simple data entry tasks.

I am looking for a Google App Script specialist to design a dependent dropdown list on Google Sheets. Your responsibility will be coding an application that enables: - Cross-referencing of data through the dropdown list - This feature should specifically be applicab...Sheets. Your responsibility will be coding an application that enables: - Cross-referencing of data through the dropdown list - This feature should specifically be applicable to certain columns only Please make sure to link the dropdown list to column headers labeled 'Customer Name' and 'Project Name'. An ideal freelancer for this role will have experience in working with Google App Scripts and Excel, or other equivalents, and is meticulous and detail-oriented. Proficiency in managing and organiz...

...modify an existing excel task planner with a goal to streamline task management. Key Modifications Required Include: - Incorporation of a Gantt chart tracker for improved task visibility - Development of a feature for staff assignment to tasks - Automation of email notifications to staff once they've been assigned tasks These enhancements will take the task planner's functionality to a new level, making it an indispensable tool in our project management. Prerequisites: - Expertise with Excel functions, particularly regarding the use of lists - Previous experience with Gantt chart trackers will be advantageous - A firm understanding of staff management systems - Proven ability in automating processes, specifically email notifications Demonstrate your exper...

I need assistance to identify and lean into potential corporate customers in the technology, healthcare, and finance sector specifically, but also customers that need customized printing services. The work involves research and gathering critical data to create an excel spreadsheet containing the following: - Company Name - Contact Person - Contact Phone Number - Email Address - Company Website A demonstrated history of research skills, data mining, and lead-generation experience would be an ideal fit for the task at hand. Familiarity with the technology, healthcare, and finance sectors, as well as understanding the needs of companies requiring customized printing services, would be advantageous. I am seeking a detail-oriented professional who can ensure accurate and on point da...

I'm seeking a proficient Excel expert to develop an interactive dashboard and implement pivot tables within my project. Key responsibilities will include: - Setting up formulas and functions to aid in data analysis. - Creating a visually appealing, interactive dashboard. - Incorporating ability to filter and analyze data via pivot tables. - Customizing calculations and generating summary reports in pivot tables. The ideal candidate should have a strong understanding of Excel's logical formulas and a knack for complex data interpretation. Extensive experience with dashboard design and pivot table utilization is essential.