How to filter data in excel using macro punët

Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure ...

I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.

I need a developer adept at integrating ZohoBooks with Power BI using REST API. The ideal candidate should possess these skills and deliverables: • Proficiency in ZohoBooks REST API and Power BI • Experience with complete, real-time data synchronization • Expertise in creating customizable dashboards on Power BI • Ability to visualize all types of data from ZohoBooks, including financial reports, customer data, and sales data. This should also cover timesheets, invoices, and profit/loss analysis • Capable of executing sales and financial analysis using Power BI The goal is to seamlessly analyze and monitor our data from ZohoBooks in Power BI. Developers with prior experience in...

The report will consist of the following tasks: 1. Identify and justify your chosen global target market and present a market analysis that identifies the macro and micro trends and issues that are currently facing the industry in which your organisation operates and how these relevant factors may impact your market sector. 2. Evaluate and align the organisation’s current approach to expand and operate in relation to at least one competitor. 3. Propose, with justification a customer value proposition supported by academic theory/frameworks for the business strategy for your new ethical product, service, brand extension that addresses one or more of the identified global trends or issues. 4. Create an original customer persona for a specific, ...

I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly in...

I'm in need of a professional who can create a modern and efficient website for my pathological lab. The website will have several key features: - Booking System: Users should be able to book a test online. This functionality should be user-friendly and easy to navigate. - Test Panel: A searchable test panel should be implemented on the website. Users should be able to search for tests by name, filter tests by category, and view detailed information about each test. This is a crucial feature that needs to be carefully designed. - Report Download: The website should include a report download page that allows users to download their reports individually. This feature should also have a mechanism for identifying the user, such as using...

Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.

This project consists in two stages. The first one (included on this budget) is creating an eLearning using Wix and Wix's Course App. The project will use MercadoPago as a payment gateway. Good design skills will be appreciated. The second stage (for a future budget) is improving the eLearning and switching into a CMS, in which other users will be able to upload their courses and get paid through the platform.

I'm looking for a...Flutter developer who can build an iOS and Android application using Flutterflow. The main features I need are user authentication and push notifications. Key requirements: - Develop a Flutterflow application for iOS and Android - Implement user authentication feature - Integrate push notifications functionality Ideal skills and experience: - Proficiency with Flutter and Flutterflow - Prior experience with developing user authentication and push notifications in mobile applications - Timely delivery and ability to meet short deadlines The project needs to be completed as soon as possible, so I'm looking for someone who can work efficiently and effectively. If you believe you have the right expertise for this task, please get i...

I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It ...

...professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear fro...

...need a photo folder scheme created to manage and display photos of our resort floor plans, properties, and locations in Mexico. This scheme will enable me to easily browse, search, and filter through our product images and use them in content posts. Key Requirements: - Design and implement a logical system to manage photos of accommodations, surrounding property and location. - Allow me to browse through photos by category. The main categories will be resort accommodation floor plans, properties, locations and dates photos are taken. - Implement a search functionality that allows me retrieve specific photos by a keyword search. - Include a feature that me to filter photos based on the date they were uploaded. Ideal Skills ...

...**Color and Font Customization**: I'm looking to refresh the look and feel of the page through a new and engaging color scheme and font selection. - **Layout and Structure Adjustment**: I'm interested in rearranging the current sections of the page to make it more user-friendly and visually appealing. This might involve adding or removing content blocks, and potentially changing the navigation menu to improve site navigation. MUST HAVE Vertical sliders of 4 pages, page enabled e.g. when I scroll up or down the next/previous slide should be open. Show paging indicator as well. Each slider will have a different background color and also use some relevant gifs in the background for animation. Ideal skills for this project include: - Profici...

I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data se...

...are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Driv...

As discussed I have delivered the excel workbook. Thanks!

Implement a BERT model for text classification to filter emotions of Twitter posts based on their content.

I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for ...

I'm looking for an experienced freelancer capable of developing 2 AI filters for Instagram which automatica...for an experienced freelancer capable of developing 2 AI filters for Instagram which automatically detect the user's face and apply makeup effects. One filter will focus on eyeliner, while the other on lipstick. Key Requirements: - Development of 2 AI filters for Instagram - Automatic face detection for makeup effect application - One style only for each filter (eyeliner and lipstick) Ideal Skills and Experience: - Prior experience in developing AI filters for Instagram is highly preferred - Strong understanding of image processing and face detection algorithms - Proficiency in designing and implementing makeup effects - Aesthetic sense t...

Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.

I'm looking for an experienced...for an experienced full-stack and OAuth expert to integrate OAuth authentication for Tiktok , TikTok into existing React.js applications. You are responsible for implementing a seamless user authentication experience that allows users to connect their social media accounts to our platform. If authentication is successful, the user's social media profile information should be safely stored in the database. For example, when the user presses the "Tiktok connection" button, the Tiktok user information input field using Auth0 appears, and when entered, the information is changed to the "connected Tiktok". If you successfully complete this task, I will award you development of all parts of ...

We are an Ecommerce company...dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have suff...

Data entry work from home part Tim e

I am in need of a website for , which is an e-commerce platform specifically designed for children. The website is aimed at providing a safe and engaging online shopping experience for kids. Key Features: - Product search and filter: The website should allow for easy browsing and searching of products, with filters to help children find what they are looking for. - Secure payment gateway: As this is an e-commerce platform, it is crucial that the website has a secure payment gateway to ensure safe transactions. - User reviews and ratings: While the specific features were not mentioned, incorporating user reviews and ratings can help build trust and engagement among the young audience. The ideal freelancer for this project should have: - Experience in dev...

I'm seeking a talented and experienced developer to create an Activity Logger App for both Android and iOS operating systems. Key Features: - The primary function of the app is to track and record specific device usage activities. These activities include: - App usage - Phone calls - SMS - Power on/off device - Website usage - File usage At the moment this is a proof of concept to firstly see if what we're looking for is possible and secondly to see if it is viable from a cost perspective. It is very important that you bid the actual cost to complete the project below and not an hourly rate or cost to discuss further. The cost you bid will be used to ensure the project is viable and if this changes later the project ...

You need to build a power app for a business process of onboarding, offboarding customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient di...

I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficientl...

Copy typingy data entry excel world

I'm in search of a sound designer with extensive experience in utilizing VST plugins such as Massive, Serum, and KONTAKT Evolve Mutation. The primary objective of this project is to replicate a sound from a specific song (【初音ミク】　イヤイヤヨ　【オリジナル】). The successfully replicated sound will be incorporated into my music production. Please listen to the specific song sound we aim to emulate in order to grasp the desired outcome. I eagerly anticipate your unique interpretations and designs. I am specifically looking to replicate the sound of what appears to be a Grandpa piano from Evolve Mutation, an 8-bit lead sound likely made with Massive, and the bass sound design from the track. Additionally, if possible, I would like to...

...seeking a Business Data Analyst for our team who is willing to work with new beginners in the field. As a Business Data Analyst, you will be responsible for analyzing large datasets, interpreting trends, and providing insights to drive business decisions. The ideal candidate should have a strong analytical mindset, excellent problem-solving skills, and the ability to work collaboratively with a diverse team. Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analy...

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for busi...

...proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can for...

I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to your bids. Thank you.

I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with ...

I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to...

I'm in need of a skilled professional who can help me generate leads. Unfortunately, I missed providing some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in understand...

I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.

I'm in need of a talented WordPress developer, especially proficient with Divi and WooCommerce, to help enrich my e-commerce site's functionality. Key Project Elements: - Implement an advanced product search and filter function, with an emphasis on category filtering. This is to enhance the user experience and make product discovery easier. - Incorporate an A-Z product pagination system within existing product pages, allowing visitors to navigate through the product catalog alphabetically. - Ensure that the search and filter functionality updates the product results dynamically without requiring a page reload. This should be an intuitive, seamless experience for the user. Skills and Experience: - Extensive experience with WordPress, Div...

...talented and specialized professionals in UI/UX Design to join our team. We are looking for individuals who can bring innovative and effective solutions to the creation of interfaces that not only delight but also provide an exceptional user experience. Responsibilities: - User Research and Analysis: Deeply understand user needs and behaviors. - Interface Design: Create attractive and functional designs for mobile and web applications. - Prototyping and Wireframing: Develop clear and functional prototypes and wireframes. - Usability Testing: Conduct tests to ensure the effectiveness of interfaces. - Style Guide Development: Create coherent and effective style guides and design systems. - User Experience Optimization: Improve the usability of existing website...

...choose a vehicle and upload an ECU or Transmission file. In admin panel, that file will be downloadable and a admins uploads processed version of the file. There will be a credit system in the platform. Customer will buy credits with their credit / bank cards and the credits will be deposited. They will spend their credits by requesting file processes. Also, there will be a shop section in the platform. Customers will be able to buy already uploaded files by admin. Customers shall be able to view their expenses and deposits as a list and that table should be exportable to excel. There will be 3 information pages which customers will be able to search and find for specific information. After you contact, I will explain these pag...

We have a list of products. We need to check everyday, if those products have strikethrough price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it...

I'm in need of a comprehensive list of small or medium-sized businesses based in UK that are utilizing Microsoft Dynamics 365 Finance and Operations (D365FO) or Microsoft Dynamics 365 Finance and Supply Chain Management (D365FSCM). The list should be exclusive to these software and exclude businesses using ONLY any of the other D365 products such as D365 Business Central, D365 CE, D365 Field Service, I dont need these and should therefore be ommited. If a business using any of the excluded software in combination with D365FO of D365FSCM, then please include on the list.

...Tickets (z.B. offen, in Bearbeitung, gelöst, geschlossen). 9. Zugewiesene Person/Team: Wer für die Bearbeitung des Tickets verantwortlich ist. 10. Erstellungsdatum: Wann das Ticket erstellt wurde. 11. Fälligkeitsdatum: Wann das Ticket gelöst sein muss. 12. Schlagwörter: Stichworte zur besseren Suche und Kategorisierung. Funktionen für Nachvollziehbarkeit und Verwaltung • Verlauf/Nachverfolgung: Automatische Protokollierung aller Änderungen und Kommentare im Ticket, inklusive Zeitstempel und Beteiligten. • Benachrichtigungen: Automatische Benachrichtigungen (E-Mail, SMS oder In-App) bei Änderungen am Ticketstatus oder neuen Kommentaren. • Dateianhänge: Möglichkeit, relevante Dokumente, Screenshots oder ...

Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions ar...

want an excel expert for google excel sheet, who can make raw material data entry for purchase of raw material stock add and when someone uses it then particular raw material to be subtracted from that item two sheets one is for list of items & another is for entry

Laravel who can start immediately. Work with ftp only. Import excel work

Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".

I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.