Filter data excel using vba jobs

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, 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. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...

I'm in need of a NASAL MASK design whose primary focus is to be both user-friendly and effective in treating sleep apnea. Key Requirements: - Detailed Design with Dimensions: I require a ...comprehensive design with precise measurements and specifications. This is crucial as the mask should fit comfortably and effectively for the user. - Adjustable Straps: The design must include adjustable straps. This is essential as it will allow the user to customize the fit, ensuring comfort and effectiveness during use. Ideal Skills: - Proficiency in Solidworks: The design should be created using Solidworks, so proficiency in this software is a must. - Experience in Medical Equipment Design: Experience in designing medical equipment, particularly for sleep apnea treatment, would be hig...

For my festival, I'm seeking a skilled web developer who is proficient in Bootstrap to create a website similar to the Festy Template. The primary functions of the website are to: - Promote the festival - Provide comprehensive information about the festival - Offer vendor signup with a contact form - Provide schedule and performer signup The project scope includes the development of less than 5 webpages with: - Textual content - Images - Videos A successful freelance web developer for this project should be experienced in Bootstrap and have a strong understanding of creating effective and engaging festival or event website pages. They should also be adept at incorporating various types of content, including text, images, and videos into their designs.

...platform for handling loan data. Key Functionalities: - User Management: The CMS should have the ability to manage users, with a specific focus on admins. - Reporting and Analytics: The system should incorporate robust reporting and analytics features that can offer insights into loan applications and user activity. - Application Rejection: There should be a clear mechanism for rejecting loan applications within the system. - Filters will be required to filter and sort data as per date, status, month. User Roles: - Admin: The primary user role I'm seeking is for admins to manage the system. Rejected Applications: - The system already have a mechanism in place to handle rejected loan applications. Ideal Skills: - Experience with CMS development - Strong unde...

I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for commerci...

I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...

Hello, I just need a quick solution to send Whatsapp message using twilio API. In my twilio account, I have already [Whatsapp Business Account ID], [Meta Business Manager ID], [WhatsApp number] That is it. Thank you for your time and look forward to working with you.

...categories > 3 subcategories > products there is a categories page and a products page and every single product has one main category and 3 subcategories will be able to add or change categories, subcategories, and products by Excel or JSON in CMD 2- brands > their products 3- offers > list of offers > their products There are offers page when you choose one of the offers you'll go to the list of their products 4- BestSellers 5- Rewards Point... 6- all in the target website we need it even though I don't list it here -when you go to every single page form above, will find a filter on the left side for categories and pin which category we are on, and other filters(Brands, Ratings, Price, type of offers, Gender, Life Stage, and more) -there is a li...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...

...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...

The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate

...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data...

I am seeking a talented website developer to construct a formal, corporate-style ecommerce platform for my business. This high-quality site should be designed with the following features: - User registration and login capability - Product search and filter functionality - Shopping cart and a seamless checkout process The ideal candidate will have strong experience in ecommerce website development, a keen sense of corporate aesthetic, and a proven track record of integrating user management tools, search functionalities, and transaction processes. Honed skills in design, UX and ecommerce are essential for the success of this project. The site could have 17,000 members who would need to have profiles on the site, there would have to be membership levels, the site would sell merch...

...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS O...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create u...

Here is a brief of my requirement. What I want is when I am creating a collection page, the way I can actually sort the product is either through best selling item, product title, highest price or lowest price, new best oldest and manually. Now we have thousands of product in a collection at the moment hundreds of them. What we want to do is instead of the regular product filter which is available on Shopify, we want to have a custom one with the logic on the basis of either row as or basis on the conversion rate. So we can actually connect this with the Google sheet or we can actually have an identifier in terms of how the product would change their, how would product would look on the collection page in terms of where they are on the collection page basis of an identifier.

I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And t...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel...

I'm seeking a highly skilled developer to integrate Dialogflow into my ManyChat chatbot for the primary purpose of customer support. Ideal Skills: 1. Previous experience in Dialogflow integration 2. Expertise in chatbot development for customer support. Your responsibilities will include: 1. Create a HTTP request inside ManyChat flow builder that return the answer from Dialogflow, so I can use this answer in my chatbot. A successful completion of this project involves creating a chatbot that can effectively handle customer queries, troubleshoot issues, and provide instant responses. The end product should be a tool that enhances our customer servicing system, saves time, and improves service quality.

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

I need someone who can donaload following datasets, then join them into one and merge into one dataset in COCO format so that it works out of the box if I replace data in attached notebook. Here are the links https://archive.ics.uci.edu/dataset/241/one+hundred+plant+species+leaves+data+set I am interested only in the following plants: Phragmites australis Typha angustifolia Typha latifolia Acorus calamus Iris pseudacorus Schoenoplectus lacustris Nymphaea alba Nuphar lutea Potamogeton natans Hippuris

I am in need of a talented website designer who can develop an engaging and interactive e-commerce website that will mirror the functionality and design of The website should contain the following: - Product Catalog: A comprehensive and easily navigable catalog of products that allows users to filter according to their preferences. - User Reviews: An in-built system for collecting and displaying user reviews for products. - Online Shopping Cart: A reliable e-commerce setup that ensures smooth transactions for customers in terms of selection, purchase, and check-out. The website will have 10-20 pages, complete with essential features such as home, about, product categories, product detail pages, blog, and contact us, among others. Candidates with proven experience

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

...marketplace needs to be user-friendly with an emphasis on a smooth, easy to navigate interface. Key features of this project include: - Online Rental Transactions: The platform must support online payments, therefore familiarity with popular payment gateways is essential. - User Profiles: Ability to create and manage user profiles for owners and renters. - Search and Filter: Renters should be able to easily search and filter through available rentals based on various criteria. - Ratings and Reviews: A system for rating and reviewing both vehicles and renters will need to be incorporated. - Security: As this platform will handle confidential user information and monetary transactions, a strong understanding of cybersecurity is essential. The ideal candidate for this p...

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I am urgently in need of a skilled freelancer to assist in B2B lead generation for my aluminium extrusion products. The ideal candidate should be experienced in exploring opportunities within the Construction, Automotive, Aerospace industries, along with Heat sink Manufacturers, Ladder Manufacturer, AHU manufacturer, and Filter Manufacturer sectors. Skills And Experience - Proven B2B lead generation experience with excellent track records - Knowledge and understanding of these industries are indispensable - Excellent communication and negotiation skills Task - Identify potential leads within these industries - Strategically pitch our aluminium extrusion products My project timelines are strict as I need this completed ASAP. Please ensure you can commit to this timescale b...

Hi, As discussed in meeting , We are going with Phase 1

I'm looking for an experienced API developer to help with syncing and scraping data from Confluence. Ideal Skills and Experience: - Proficient in Confluence API - Expertise in data synchronization and data scraping - Knowledge of handling Confluence pages, spaces, attachments, and content images - Able to preserve formatting and filter by date Key Responsibilities: - Develop an API integration for data synchronization - Implement scraping functionality for Confluence pages, spaces, and attachments - Ensure the scraped content maintains original formatting - Implement filtering logic to sort data by date

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

...functional e-commerce website for my business. I currently own the domain, so I need someone that can take my ideas and turn them into an engaging digital storefront. Key Features: - Shopping cart and checkout functionality for customers to make smooth and secure purchases. - Customer reviews section to allow for feedback and to build trust with prospective buyers. - Advanced product search and filter to help customers navigate and find exactly what they're looking for swiftly. - A dedicated offer page to frequently update customers about sales, deals or new product launches. Skills & Experience: - Proficient in creating minimalistic and clean designs. - Proven experience in developing e-commerce websites. - Strong understanding of user-experience design for mobile and...

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

...on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are using. Ideal Skills and Experience: - Proficiency in web design and development - Previous experience in developing inventory showcasing websites - Ability to create a clean and user-friendly design - Experience working with search and filter options on a website - Understanding of responsive web design and mobile-first approach Ultimately, I'm loo...

I'm looking for a detail-oriented researcher to help me gat...- charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be ref...

I'm looking for a skilled freelancer who can develop a program for the Click PLC to control a Variable Frequency Drive (VFD) hoist. Key tasks would include: - Implementing a start/stop control which can be manually triggered. - The program needs to possess speed control, allowing adjustments in the hoist's operating speed. - Including direction control within the program functionality would be vital as well. An understanding of PLC programming and specific proficiency with Click PLCs is crucial for this project. Previous experience with VFDs, industrial automation, and manual switch controls would give any potential freelancers a significant advantage.

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally....

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

...on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are using. Ideal Skills and Experience: - Proficiency in web design and development - Previous experience in developing inventory showcasing websites - Ability to create a clean and user-friendly design - Experience working with search and filter options on a website - Understanding of responsive web design and mobile-first approach Ultimately, I'm loo...