Excel macro extract data filter jobs

Hello! In order to help me learning Arabic, I would like to make a small dictionary with the help of chatGPT API. I would like to make it from 2 books. The first book is a book in Arabic and the second book is its translation in English. Here is an extract from the book in Arabic (): فَمِنَ الْوَاجِبِ خَمْسُ صَلَوَاتٍ فِى الْيَوْمِ وَاللَّيْلَةِ الظُّهْرُ وَوَقْتُهَا إِذَا زَالَتِ الشَّمْسُ إِلَى مَصِيرِ ظِلِّ كُلِّ شَىْءٍ مِثْلَهُ غَيْرَ ظِلِّ الِاسْتِوَاءِ. وَالْعَصْرُ وَوَقْتُهَا مِنْ بَعْدِ وَقْتِ الظُّهْرِ إِلَى مَغِيبِ الشَّمْسِ. وَالْمَغْرِبُ وَوَقْتُهَا مِنْ بَعْدِ مَغِيبِ الشَّمْسِ إِلَى مَغِيبِ الشَّفَقِ الأَحْمَرِ. وَالْعِشَاءُ وَوَقْتُهَا مِنْ بَعْدِ وَقْتِ الْمَغْرِبِ إِلَى طُلُوعِ

...Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click of...

I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel t...

I need a Telegram usernames scraper that can gather user data from a specific Telegram group. This scraper is required to: - Extract Usernames: The primary task of this scraper is to collect usernames from the specified Telegram group. - Storage in CSV Format: The extracted usernames should be saved in a CSV file format. This is for easy accessibility and subsequent use. - Daily Operation: I would like the scraper to run on a daily basis. The aim is to capture any new usernames that may have joined the group. Ideal candidates for this job should have experience in web scraping, specifically with Telegram. They should also be proficient in scripting languages and have a strong understanding of data storage formats. The ability to automate the scraping process to run...

I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and easy t...

...making it more suitable, seamless, and time-saving for our users. Here's what I'm looking for in the chatbot: - Property Search Assistance: The chatbot should guide users to search for properties based on specific criteria. This includes a location-based search feature that will provide properties at the user's desired location, price-range search to suit the user's budget, and property type filter that narrows down the search results based on the specific type of property the user is interested in. The development needs to begin As Soon As Possible. Bear in mind that I am interested in working with an experienced AI chatbot developer, with prior experience in scripting for Real Estate bots. The ideal freelancer needs to understand the importance of this p...

I'm facing a persistent issue with my Instagram page: someone is consistently sending fake followers. This is hurting the authenticity and engagement of my page. Sadly, the spam filter is on and making my page private isn't an option for me. I'm in need of a skilled Instagram expert who can help me address this problem. Key Requirements: - Identify and remove fake followers: The primary goal of this project is to clean up my follower list. I need someone who can effectively recognize and eliminate the fake followers that are being sent to my page. - Work with Instagram restrictions: Since I can't make my page private, the selected freelancer needs to be able to navigate and respect Instagram's terms and conditions. Additional Information: - Reporting: Wh...

I am seeking a professional who is adept at data entry and copywriting. This project will require: - Online form filling using data from existing digital documents. Attention to detail and accuracy is of utmost importance. Skills in data entry and experience with handling digital documents will be essential. - Copy writing for blog and articles. I am looking for someone with experience in crafting engaging, informative, and high-quality content related to my industry. Expertise in blog and article writing is a must, as well as a strong command of English language and grammar. The perfect candidate will possess Excel skills for the data entry part of the project, and should have a track record of creating enticing blog posts that keep the reader's...

General Requirements: Consistent Design Language: Maintain a cohesive design across all pages and devices. Navigation: Ensure easy navigation between pages and sections. Performance: Optimize for fast loading times on all devices. Accessibility: Follow accessibility standards to ensure usability for all users. Security: Implement measures to protect user data and privacy. Feedback Mechanism: Include options for users to provide feedback or report issues. Documentation: Provide documentation for developers and administrators detailing design decisions and maintenance procedures. These requirements should guide the design and development process of your web app, ensuring a user-friendly experience across different devices while meeting the specified page requirements. 1. About Us Pag...

...Requirements: • Display locations pin on the map based on Excel/database details (name, Address (or Lat/log), Phone, picture etc. Attributes) • Provide a nearby location list on the left based on the current location or a list of locations based on search and filter criteria. • Enable zooming to the selected location from the list and vice versa. When a map location pin is selected, the corresponding list should be highlighted in the left places list. • Map zoom based on the mouse scroll (Should not be embedded google map) . • The list will include pictures and summaries of the place's rating from Google, cost, number of reviews, address, etc. • Various filters should be available on the map based on multiple criteria (around 5 to 10 cr...

I'm in need of a data analysis and visualisation expert, particularly in R. The ideal candidate will be experienced in Excel, STATA, and SPSS as well. The main tasks include performing data analysis, creating engaging data visualisations, and building data models. Key Responsibilities: - Performing thorough data analysis using tools like STATA, SPSS, and Excel - Proficient in R for creating engaging data visualisations - Building data models to support the provided data Ideal Skills and Experience: - Proven experience in data analysis - Expertise in R and other relevant tools like Excel, STATA, and SPSS - Ability to create engaging data visualisations, preferably in the form of stacked bar cha...

I'm looking to enhance our website's user experience by incorporating color swatches for product selection. Additionally, I'd like to ensure that the size filter functions seamlessly, displaying available sizes upon selection. Furthermore, I aim to optimize our product listings by displaying color variants as separate SKUs, allowing customers to easily identify and choose their preferred options. Key requirements: - Custom coding in Shopify - Experience with online store development - Ability to Add Custom Filters, SKU, ETC.. Please only apply if you have a strong background in Shopify development, particularly in product sales. Experience with custom coding and large inventories is a must.

I have a set of scanned images in PDF format that I need converted into an Excel sheet. The job is purely data entry - you are to copy the content from the scanned images into an Excel sheet. The freelancer should have excellent typing skills and attention to detail to ensure that no data is missed or entered incorrectly. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Detail-oriented - Experience with data entry, especially from scanned images - Excellent communication to ensure any questions about the data are clarified before entry

...this task is to automate the extraction of data from various sources including websites, databases, and APIs. Key responsibilities include: - Designing a script that can seamlessly extract data from websites, databases, and APIs - Ensuring the script is efficient and reliable in data extraction The ideal candidate should have: - Proficiency in Python and automation scripting - Experience in extracting data from different sources - Knowledge of web scraping, database access, and API interaction - A strong understanding of data structures and algorithms to ensure efficient extraction - Familiarity with best practices in automation for data extraction If you have a strong background in Python and automation, and a track record of success...

Hi there, I'm looking for an expert to help me tweak our WhatsApp system so that it can forward messages directly to our specific app teams A and B based on certain user details. Specifically, I need someone who can: * Extract user phone numbers from incoming messages. * Develop an intelligent system that filters and routes the messages to either team A or B based on the nature of the user inquiry. The ideal candidate will have: * Extensive knowledge of WhatsApp API integrations. * Proficiency in data extraction and message routing based on specific criteria. * A great understanding of user detail recognition systems. This project requires accuracy and keen attention to detail to effectively gather and use the appropriate user information for optimal message routin...

Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 3000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor ...

...fundamental features and functionalities: - User Registration & Login: There has to be a comprehensive system for users to register and login, ensuring smooth interaction. - Shopping Cart & Checkout Functionality: This is an e-commerce app which necessitates an unhindered shopping cart and secure checkout functionality for optimal user experience. - Product Search & Filter: Users should be able to effortlessly search and filter products based on their preferences. Fortunately, I have a design and wireframe ready for this project which will provide a clear picture of my expectations. Ideal candidates for this project would have significant experience in building e-commerce apps for Android, and have a thorough understanding of incorporating these key feature...

Key Responsibilities: - Plan, implement, manage and monitor the company's Social Media strategy in order to increase brand visibility, improve marketing efforts and generate leads. - Extract B2B leads set-up email campaign to educate our potential client via content. - Provide a strategic perspective - leveraging social media to generate B2B leads. This role demands expertise in creating engaging content, that can resonate with other businesses, encouraging them to invest in our service. It’s a significant opportunity to showcase your ability to drive business growth through innovative social media & email marketing strategies. In your bid please mention how your skills align with the project and will you be able to put daily 2-4hr.

I need a one-time extraction of specific data from into an Excel spreadsheet. The task involves extracting all data for each date as far back as 1 January 2020. The end product is a long table in Excel also capturing the date of release. Key Requirements: - Extract earnings data that surpasses expectations from a specific website. - Transfer the extracted data into an Excel spreadsheet. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience in data extraction and manipulation. - Strong skills in Microsoft Excel.

I need a Telegram scraping tool that can fetch usernames from a Telegram group in real-time and update the CSV file as new members join or existing members change their usernames. - Scrape group member usernames: The tool should be able to extract the usernames of all members in a Telegram group. - Real-time data updating: The scraped data needs to be constantly updated in a CSV file as new members join or current members change their username.

I need a software developed urgently that can generate playlists on Apple Music. I can provide the Apple music song URLs in a Excel file as follows: ... I need to import the playlist into my Apple music player

Exciting opportunity for an excel whizz! I urgently require assistance with embedding photos into an excel sheet. Key Responsibilities: - Insert Photos: You'll be in charge of seamlessly integrating photos into an excel sheet. you should keep the same resolution Skills and Experience: - Excel Proficiency: Strong excel skills are a must. - Attention to Detail: Aligning photos properly within the sheet is critical. - Quick Turnaround: This project needs to be completed ASAP. Get in touch if you've got the passion and experience to deliver this project swiftly!

I am in need of a highly proficient Excel VBA developer who can implement and automate complex data analysis, and generate reports from large volumes of data. Key Tasks: - Implementing intricate data analysis using Excel VBA scripts. - Automating repetitive data management tasks. - Designing and developing report generation tools. This program will be used by a mix of both internal and external users. Therefore, the created solution should be intuitive, user-friendly and reliable. Essential skills: - Proven experience in Excel VBA programming, dealing with large complex sets of data. - Strong understanding of data analysis techniques. - Capable of designing user-friendly interfaces for report generation. This is a chall...

I need immediate assistance with converting 50 invoices into an Excel sheet. The information to be transcribed includes the following columns: Date, CIF, Company Name, and Amount. Ideal Skills: - Proficiency in Excel - Attention to detail - Fast and accurate data entry skills The project has to be completed within 1 day. No specific formatting requirements are needed at this time. Once completed, I will review the Excel file.

I'm immediately needing a skilled computer operator who could expertly manage data entry tasks, file management, and maintain our database. You must be proficient in utilizing Microsoft Excel, Google Sheets, and QuickBooks. Key Duties: - Accurate Data Entry - Efficient File Management - Consistent Database Maintenance Preferred Skills and Experience: - Proficiency in Microsoft Excel, Google Sheets, QuickBooks - Fast yet accurate typing skills - Strong knowledge in File Management and Database Maintenance - Good time management skills Your ability to deliver quickly is essential as I require this project to be completed ASAP. Please provide proof of your skills in your proposal so I can make an informed decision. I greatly appreciate your interest and loo...

Please Sign Up or Login to see details.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for an expert in Excel data handling and financial analysis with special attention to franchising businesses. The end-goal is to develop a user-friendly, dynamic Excel document for cross-comparison of various franchisor fees, charges, and costs. Key Tasks: 1. Data Entry: Populate the document with the provided profit and loss data. 2. Categorization: Organize costs by frequency of occurrence (monthly, yearly, etc.). 3. Analysis Tools: Implement features to run various cost analysis scenarios with a focus on comparing costs between different franchisors. A back ground document that I can change that clearly show in $ cost the difference and in visual Competitive analysis comparison document Ideal freelancers should have an understanding...

I'm in need of a highly proficient Excel specialist who will perform a series of tasks for me. Specifically, these include: - Data Analysis: Probing and evaluating a medium-size dataset (between 100-1000 rows) to derive meaningful insights. - Spreadsheet Formatting: Improving aesthetic appeal and readability of my spreadsheets. - Formula Creation: Establishing useful formulas to automate computations and functions. The entire project needs to be undertaken in Excel 2016 or later, therefore familiarity with this version is essential. Experience in data analysis and spreadsheet management is also expected. If you're an Excel whiz, I'd be eager to hear from you.

I'm on the lookout for a talented Python developer who can create a custom web scraping script. The primary aim of this script will be to extract product details from a particular e-commerce site. Key Responsibilities: - Develop a Python script that accesses the e-commerce site and collects product details as specified. - Ensure the script is efficient, accurate and can handle a large volume of data. Skills & Qualifications: - Proficiency in Python and experience in web scraping are crucial for this task. - Prior experience with e-commerce website scraping is a plus. - Ability to extract and organize data in a structured format. - Strong problem-solving and communication skills are highly valued. If you have the skillset to take on this project...

I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick, I have attached the document for data collection from web. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Please view the attach file. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system the...

I need a freelancer to assist me with a small financial calculations task in Excel. - The work is focused on financial calculations, so experience in this area would be highly beneficial. - The task isn't extensive, but I need someone who is detail-oriented and can ensure accuracy in the calculations. - I'm open to seeing examples of your past work, particularly if you've done similar tasks. Please apply with your relevant experience and a brief explanation on how you would approach this task. Need it by today

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

...me. The main goal of this application is to extract data from APIs and databases to be used for analysis and reporting. Key features: - The ability to securely and efficiently extract data from multiple sources, primarily APIs and databases. - A user-friendly interface for easy data extraction, potentially with functions like search, filtering, and scheduling. - A robust backend system to effectively handle and process the extracted data. - Data storage solutions to keep the extracted data secure and accessible for analysis. Desired Skills and Experience: - Proficiency in web development, with previous experience in data extraction projects. - Strong understanding of APIs and databases, with the ability to effectively an...

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

I am in need of a developer skilled in Python for a project concerning the creation of a tablet finder application compatible with Windows. The primary feature of this application must be search filters, specifically, those able to find tablets based on their MAC addresses. Ideal candidate would posses: - Proficient in Python - Experience in creating search filters - Familiar with MAC addresses - Working knowledge of Windows compatibility - Detail-oriented and able to work autonomously. The focus of this project is the development of a reliable application that can perform complex searches based on a tablet's MAC address. This is a specialized task requiring detailed and specific skill sets.

...visit National Skills Competition module for view only, and have their own filter settings, but they can't make any changes and can't see any other modules at all, what they can do is just view NSC module, use the search, filter, or print(if available) features, also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in the task, then each button can copy the certain fields data from project to the certain field...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

...will parse, extract, and vectorize content to understand issues. An explainable ML model like LIME will then diagnose the problem and provide steps, code samples, etc to resolve it. The LLM will be RAG augmented based on a vector protocol of a list of sites to augment the LLM. Key Criteria for Success: Robust technical execution that meets core requirements Modular, extensible architecture for flexibility over time Quality, well-tested code delivered on time Clear, prompt communication throughout project Key Components: Text/file ingestion and vectorization Semantic similarity search in Milvus/SPTAG Local post-hoc model explanations Production-ready Flask/FastAPI UI Documentation and usage guides Document Ingestion (spaCy, Beautiful Soup, PyMuPDF): Scrape/ingest docs, extrac...

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

...seeking an experienced data scientist and analyst to support me in improving my business operations through a data-driven approach. The project will involve tackling tasks across data cleaning, statistical analysis, and data structuring and algorithm implementation. Ideal Skills and Experience: - Proficiency in data cleaning and preprocessing to ensure that the data is in its most usable, accurate, and complete state. - Strong statistical analysis and modeling skills to extract meaningful insights and make accurate predictions. - Excellent experience in structuring data and implementing algorithms that are tailored to business needs. Data Sources: - Social Media Data: You should be comfortable working with a variety...

...tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...

...need my website to be viewed even while customers are at work in a government agency with no restrictions to entering websites. Key Features Needed: - Product Customization Options: The ability for my customers to tailor and personalize their purchases. - User Accounts and Profiles: A seamless system for users to create accounts, save preferences, and view order history. - Advanced Search and Filter Options: A robust search functionality with filters to help customers find products quickly and easily. This project will involve not just the migration of the current site but also the creation of a new domain. I need a skilled web developer who has experience with E-commerce websites, particularly on WordPress. Familiarity with Shopify migration would be a plus. Prior work that ...