Excel macro to hide columns based on criteriaKazi
I'm in need of a system that can t...need of a system that can transform my existing PDF into word file. - The first needs to be a Word document, containing a fillable form. This form should encompass text fields, check boxes and date fields, mirroring those found in the original PDF. - The second is an Excel spreadsheet, which is to be linked directly to the Word form. This link should enable automated data transfer between the two, minimising the need for manual data input processes. Proficiency in Word, Excel, PDF conversions and data automation would be ideal for this project. Understanding of complex form creation and Excel-to-Word data linking is also crucial. This endeavour requires precision and a strong attention to...
...expert freelancer to collaborate with us in enhancing our e-learning platform. The ideal candidate will possess a deep understanding of Moodle's functionality and be adept at implementing various features to optimize the learning experience. This is an ongoing project with opportunities for continuous platform development. Key Responsibilities: 1. Reporting Enhancement: - Develop robust reporting functionalities allowing for the generation of detailed reports tailored to specific groups or cohorts. - Implement visual representations such as graphs and charts to enhance data visualization. - Enable the capability to download reports for individual students and predefined groups. 2. Gamification Integration: - Introduce engaging gamif...
I'm looking to have a Learning Management System developed, with a primary focus on Course Enrollment. Key Features: - Web-Based: The system should be developed solely for web usage. - Course Creation: I want to be able to create and manage courses. - User Types: The system should cater to Trainers and Trainees. - Course Enrollment: The MVP's critical feature is the Course Enrollment process. This should include: - An Approval Step: Trainees should be required to receive approval from either a Trainer or an Administrator before they can enroll in a course. - Communication: The system should utilize Email SMTP for notification purposes, particularly to inform Trainees about their enrollment status. Ideal Skill...
I have 73 PDFs that I need to be converted into separate Excel sheets. The Excel sheets need to follow a specific format, which is in table form with specific columns. Key Requirements: - Convert 73 PDFs into rows of an Excel sheet - The Excel needs to follow a pre-defined format, which I will provide. - The pre-defined format is in the form of tables with specific columns The Excel sheets should contain all the data as shown in the template with a separate summary tab with the following: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation H...
...dropshipping store and handle the complete process of connecting it to major marketplaces such as Amazon, eBay, and Etsy. In addition to this, I'd need assistance with extending its reach on social media. Key Responsibilities: - Building and designing the dropshipping store with essential features - Establishing connections with Amazon, eBay, and Etsy - Implementing reliable payment methods including credit card, PayPal, and Apple Pay - Strategizing and executing comprehensive marketing campaigns on various social media platforms I'll be responsible for managing the store post-setup, which includes handling sales, customer inquiries, and returns. As a compensation, I'm willing to pay you a percentage of the net profit, ranging from ...
I am in need of a freelancer who can help me convert a bulk of my purchase invoices from PDF format to Excel. - The PDF invoices are all Text-based and thus, the conversion can be automated. - The original scanned PDF will also be provided if needed. - The Excel sheet should have the following fields: - Vendor information, Invoice number, Invoice date, Purchase details (Product Name, Uom, Qty, Rate, VAT, Total) - I prefer all the invoices to be organized in a single sheet in the Excel file. Ideal skills for this job include proficiency in data extraction, PDF to Excel automation, and a keen eye for detail when it comes to organizing data. A background in finance or accounting would be a plus, as it will help in ensuring...
...Veristaff is a new East African background check company focused on providing secure and efficient verification services to small and medium businesses (SMBs). We are seeking a talented and experienced developer (or development team) to build our Minimum Viable Product (MVP). 2. Project Overview The MVP will be a user-friendly online platform that allows SMBs in East Africa to request and manage background checks for potential hires. The initial focus will be on one core services: Employment Verification: Verifying past employment history by contacting previous employers (with candidate authorization). The platform will offer a starter package with a limited number of combined background checks per month. Users will be able to register, create a...
I'm searching for a highly skilled Web3 designer to build and launch a Web3 website. This individual should excel in user interface design, creating visually pleasing and intuitive designs for a seamless user experience. Key responsibilities will include: - Developing a user-friendly Web3 website design - Incorporating decentralized identity feature in the website Expertise and Skills required: - Proficiency in Web3 designing - Previous experience with decentralized identity - Solid understanding of Blockchain - Proficiency in user interface design Ideally, you should have an impressive portfolio of previous Web3 design work. Looking forward to a designer who can deliver a high-quality user interface and contribute innovative ideas for site features.
Grâce a l'ocr et AI je veut créer une plateforme en ligne pour récupérer les factures scannées ou photographier ou les bon et pourvoir lire tout les informations de la facture grâce a l'ocr et reconnaître les différentes type de factures grace au machine learning et a la fin récupérer les données dans un fichier excel ou csv ou dans une base de données grâce a la configuration de chaque rebrique et colonne.
...skilled WordPress developer to enhance my product page by changing its layout and adding custom fields. Your primary task would be to import a CSV file containing a variety of product data. I have created the attributes I need but the CSV importer is not pairing my CSV attributes with the woocommerce attributes. Key requirements include: - Changing the layout: I need the layout of my product page to be similar to the attached Product Page Sample. What I have been unable to do is get my product attributes to list in 2 columns. - Adding custom fields: Introduce new fields for product data that is not currently displayed in the default layout. I have added the necessary attributes, but they aren't pairing when I try to upload ...
...safety advisories. 2. Diet Plans: Nutrition recommendations and daily diet plans tailored to support strength training. These may include recommended meals, macro or calorie counts, and advice on supplements if necessary. 3. Progress Trackers: A system for tracking training progress, such as weight lifts, cardio fitness levels, and body measurements. A visually appealing, easy-to-understand format is important. 4. Daily Macros/Calories Checks: A straightforward way for clients to track their calorie intake and macronutrient ratios, which is crucial for those pursuing strength training. 5. Check In Form: A form that clients can fill out to monitor their weekly progress. It'll allow me and them to track their progression and make m...
Hey there, I've already set up some indicators on PA, İ'll add some extra indicators on monthly, weekly periods. already a stock library installed and there's a working system for different indicators. i'll send the indicators pine editor codes, we need to change it to pyhton. the project is really very small.
As a company, we're currently in need of a seasoned Power BI expert, well-versed in creating engaging dashboards and detailed reports. Key Responsibilities: - Develop and design interactive dashboards...Develop and design interactive dashboards and reports - Generate in-depth, data-driven reports - Provide data analysis and insights Key Requirements: - Proficiency in Power BI - Strong experience in creating interactive dashboards and detailed reports - Skilled in data analysis and providing insights The project will involve connecting to data sources primarily from Excel spreadsheets. The main audience for the dashboards and reports will be our data analysts. To ensure that you're the right fit for this project, please provide examples of your previous w...
I'm looking for a skilled developer well-versed in both Flutter and networking to create a TCP proxy server client for my project. Key Features: * The TCP proxy server client must support HTTP/HTTPs. * Ensure it's cross-compatible and functions seamlessly on both Android and iOS and desktop. Additional Requirements: * The client should have strong capabilities to handle multiple simultaneous connections. * Previous experience in load balancing and traffic monitoring would be a definite advantage. Please bid only if you have extensive experience with both Flutter and networking. Your bid should include any similar projects you've completed. *More details about the project: I will include both the proxy server and the client side that I made in golan...
I'm looking for a skilled developer to create a web-based application focused on content management. The primary function of this application is to serve as a platform for curating and managing content. Key Features: - Interactive Quizzes: This application will feature an interactive quiz functionality. Users should be able to create and interact with quizzes in a seamless manner. Ideal Skills & Experience: - Proficiency in web-based application development - Proven experience in building content management systems - Strong understanding of interactive quiz functionalities and design - Experience with similar educational resource applications is a plus Please include relevant examples of previous work with your application. I look forw...
...handling specifically relating to Excel spreadsheets. The ideal candidate will be responsible for: - Sorting the data to make it more organized and user-friendly. - Cleaning the data. This may entail tasks such as detecting and correcting errors, and potentially removing any duplicates (however, a clear plan on handling this aspect will be shared later in the project, since the specific data cleaning operations were not predefined). - Separating the data as requested. This is a time-sensitive project requiring completion as soon as possible. Therefore, the individual needs to be adept at working under pressure and towards tight deadlines. The perfect fit would be someone with a proven track record handling similar tasks, demonstrating a strong profic...
I will do enlisted task. Renovation Brands needs an analytical assistant to support our FP&A department in a variety of tasks. The ideal candidate will have experience with Excel and running/modifying SQL (no need to have experience writing it). Tasks will include things such as downloading data from ERP or SQL, Refreshing files and validating refresh worked, troubleshooting errors in execution, etc.
I'm looking for someone with a solid underst...solid understanding of the market and strong research skills to help identify multi-brand women's clothing retailers in the UK and USA. The project involves finding both online and physical retailers that also have an online presence. The ideal candidate will have experience in market research, preferably within the fashion or clothing industry, and possess excellent analytical skills. Knowledge of the retail sector is crucial, and having access to premium market research tools would be a plus. Please include details of your experience and your research approach in your proposal. Note that we will provide an Excel sheet for the data, and we are offering $50 for every 1000 records. Please apply only if the budge...
...focused on women aged 25-75. My business caters to this demographic, and I'm looking to expand and engage this audience through social media. Primary Goals: - The main objectives of this campaign are to increase brand awareness and drive more traffic to our website. I'm looking for someone who can create and execute a strategy that will effectively achieve these goals. Ideal Candidate: - The ideal candidate for this job will have a proven track record of successful social media marketing campaigns, particularly targeting and engaging specific demographics. - Experience in running campaigns across Facebook, Instagram, and Twitter is a must. - Knowledge of tools and techniques to increase brand awareness and drive website traffic is h...
...responsible for developing specialized models to enhance the processes through advanced AI technologies. **Responsibilities:** - Develop and optimize AI models tailored to specific use cases. - Integrate and manage API interactions between OpenAI, Azure, and Google Gemini platforms. - Monitor and adjust models based on performance metrics to ensure optimal functionality. -Ensure seamless integration and deployment of AI models. **Required Skills:** - Strong expertise in AI, specifically with OpenAI GPT models, Azure Open AI, and Google Gemini API. - Extensive experience in developing and fine-tuning large language models (LLMs). - Proficient in handling and analyzing large datasets with advanced analytical techniques. - Proven ability ...
I need a talented statistician to help determine if there is an association between gender and different types of admission sources from the Emergency Department (ED). The analysis will not be limited to a particular admission source. The data for the project will be supplied in an Excel file format. Freelancers are required to have proficiency in Excel and a deep understanding of statistical tests, particularly Chi-Squared tests. In your application, please include: - Your past work relating to statistical analysis - How you plan to execute this project utilizing the Chi-Squared Test - An estimated timeline for completion I look forward to working with you on this exciting project!
I've compiled an Arabic-Chinese dictionary in an Excel file and I'm seeking a skilled developer to convert this into a user-friendly software. This software will be exclusively for laptop or computer use, and should operate offline. Key requirements: - Experience with software development for Windows and Mac operating systems - Proficient in programming languages suitable for offline software - Ability to create a user-friendly interface The ideal freelancer will have experience in developing functional and user-friendly software. I would like this project completed within a month, so I'm looking for someone who can work efficiently, while also maintaining high-quality standards.
We are seeking a highly organized and proactive Web Assistant from the Philippines to support our web-related tasks. The ideal candidate will have excellent communication skills, a strong understanding of Microsoft Office tools, and the ability to engage effectively in daily calls with stakeholders. This position offers a great opportunity for growth within a dynamic team environment. Key Responsibilities: Assist in the management and upkeep of the company's website and related tasks. Schedule and participate in daily calls with stakeholders to discuss updates and resolve issues. Utilize Microsoft Office tools to create and manage content, reports, and presentations. Coordinate with team members to ensure smooth execution of web projects. Manage em...
I need professional assistance with energy modeling for a traditional residential building, which falls within the size range of 1,000 - 2,000 sq ft. Job Requirements: * ...the size range of 1,000 - 2,000 sq ft. Job Requirements: * Expertise in energy modeling specifically for residential buildings * Knowledge of modern energy efficiency standards for homes * Proven track record of getting approval from building departments * Familiarity with traditional architectural designs The ideal candidate will help ensure that the proposed energy model meets all required criteria for approval, and provide necessary guidance for potential improvements. Your expertise will be crucial in successfully navigating the approval process, so a detailed understanding of these systems and standar...
There's an existing problem with my WordPress website's search functionality. Specifically, the issue lies with the feature that allows users to search by distance. Usually, when this feature is working correctly, users who search by distance should be shown all the services that are available within the chosen radius. Currently, however, no services are displayed when a user tries to conduct a distance-based search. I am seeking a freelancer with extensive knowledge and experience in troubleshooting and repairing WordPress website functionality. Ideal skills for this job would include proficiency in PHP, JavaScript, and a good understanding of how WordPress plugins work. The plugin used is WP Job Manager / Resume Manager.
I'm in need of a freelancer with an eye for detail and proficiency in Excel for a data sorting project. The task involves the following: - Sorting of a large Excel dataset - Understanding of sorting methods with Excel is crucial - Experience in data management would be a big advantage Completion of the project within the next three days is essential. The efficient and quick turnaround is a prime requirement. Let's discuss if you thrive in fast-paced environments.
I need a professional to create a dual-platform dashboard in both MS Excel and Power BI. The primary objective of these dashboards is to monitor the status of multiple projects. Key responsibilities include: - Setup and design of interactive dashboards that display project status in a user-friendly manner. - In MS Excel, the dashboard should efficiently track and report project status. - For Power BI, the focus will be on analyzing project status. Ideal freelancer will have: - Proficiency in MS Excel and Power BI. - Proven experience in creating versatile dashboards. - Strong understanding of project management principles. - Knowledge of data analysis and reporting.
I need an Excel spreadsheet created to store and display information for 200 products. The project involves: - Entering product name, product description, and price for each item - Embedding images for each product in the spreadsheet - Receiving product information and images in a text document Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail - Ability to work with and embed images in Excel - Familiarity with data entry and handling product information Looking forward to working with a skilled freelancer on this task.
I need a specialist to generate leads for our acquisition initiative. This initiative targets tech-focused firms with a revenue of $5 million to $100 million. Key Deliverables: - Comprehensive list of names and contact information of software companies, e-commerce businesses, social media agencies, fintech, Saas, video production and advertising businesses. - All identified businesses should operated nationally. Key Skills & Experience: - You should have a robust network and significant experience in tech/SaaS to understand where to look and who to contact. - Keen knowledge on financials of potential lead business to ensure they meet our revenue and profit criteria. - Adequate experience in lead generation and business acquisi...
...individual who can teach beginner-level tutorials focusing on GPT-4 training and the implementation of AI techniques. Since I did not specify any programming languages or frameworks, an understanding of several widely used languages would be beneficial. The ideal candidate would be proficient in teaching complex concepts in an easy-to-understand manner. We are looking create a knowledge base within our business that will help us embrace AI moving forwards and enable us to create GPT’s, mainly to extrapolate / merge / compare / reformat data from excel files. We would like to train 3 staff members with the knowledge of how to ultimately create GPT’s to take multiple workbooks of data, extract the relevant informati...
...a diligent and experienced web designer to build a website for my real estate company. The website must support residential property listings with the ability to display them in a list view. Key requirements: - A comprehensive property search feature: Facilitate users to search through our listed properties based on specific criteria such as location, price, size and more. - Property listings: The website needs to display designated sections for property listings, with each segment containing detailed information about the property including the price, size, location, and images. - Contact form: A user-friendly contact form needs to be incorporated for customers to reach us with inquiries or feedback. - WhatsApp Button: Inc...
I need an excel spreadsheet developed that can compare my actual expenses against my budgeted expenses and display the variance in currency value. The project is quite urgent and I need it to be completed ASAP. Key Requirements: - Create a tabular representation of my actual expenses vs the... - Develop a similar tabular representation for my budgeted expenses - Calculate the variance between the two in currency value - Display the variance in a clear and visually appealing manner - be able to toggle between different cost centres - be able to select data from different months Ideal Skills and Experience: - Advanced Excel skills and experience in creating financial spreadsheets - Familiarity with financial data analysis and budgeting - Attention to...
I'm in need of an experienced laser printer technician around the Key West area. My laser printer is producing poor-quality prints across all colors, which is affecting my daily operations. Key requirements for this job include: - Expertise in troubleshooting laser printers - Ability to improve overall print quality across all colors - Proximity to the Key West area. Please get in touch if you fit these criteria.
1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.
...have a stack of physical documents that need to be input into an Excel spreadsheet. Your task will be to transfer this information accurately and efficiently. Key Requirements: - Proficiency in Excel: You will need to have a good working knowledge of this software, and be able to use it to create a well-organized database from the information provided. - Attention to Detail: While I don't expect perfection, I do need the data input to be mostly error-free. Accuracy is key. - Physical Document Handling: As I will be sending you hard copies of the documents, you will need to be able to handle and return them safely. This project is great for those with a good amount of data entry experience, and who are c...
I'm looking for a skilled data visualization expert to create a comprehensive dashboard in Excel based on the following criteria: - Data Visualization: The dashboard should primarily feature line graphs and pie charts to represent the sales data of various organizations. The design should be clean, intuitive and should effectively communicate the insights from the data. - Data Organization: The data should be organized by category, making it easy for the user to understand the performance of different organizations segmented by different categories. I expect the freelancer to have experience in data visualization, specifically in Excel, and should be able to design a dashboard that is not only visually appealing ...
...task will be to collect contact information from one website and populate an excel template (attached). Key Responsibilities: - Gathering ALL phone numbers and email addresses from the website I will provide to you (63 ITEMS). - Fill in the yellow highlighted cells, ignore the white cells - DO NOT CHANGE THE SPREADSHEET STRUCTURE DO NOT ADD OR DELETE COLUMNS. Ideal Skills and Experience: - Proficiency in data entry and web research - Excellent attention to detail to ensure accurate transcription of contact information - Experience in working with spreadsheets - Ability to deliver work in a timely manner Please note that we are seeking a professional who can deliver accurate results on time. The
Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online
I'm looking to enhance my Microsoft Excel skills, focusing on data analysis, pivot tables, and macros, to efficiently manage project construction data and create insightful reports. Key Responsibilities: - Advanced Data Analysis: Interpret project construction data effectively. - Pivot Tables Mastery: Create complex reports with dynamic pivot tables. - Macro Proficiency: Automate repetitive data analysis and report generation tasks, boosting efficiency. Ideal Skills: - Proven expertise in Excel, particularly in data analysis, pivot tables, and macros. - Experience with project construction data, financial data or similar. - Strong analytical and problem-solving abilities. - Excellent attention to detail to ensure high-quality,...
...are seeking a talented video producer to create an engaging and informative video that explains the social responsibility and business model of CEMCUI. The video should be produced in both English and Spanish versions. Objectives: Highlight Social Responsibility: The video should emphasize our commitment to social responsibility through our workshops and partnerships with artisans. Explain Our Business Model: Detail how CEMCUI connects customers with artisans by designing custom products that go beyond commodity items. Explain the entire process including quality inspection, logistics, and distribution. Visual Branding: Incorporate our business brand logos and color scheme (#382f2d, #dad6ca, #cdcb5f, #ffbe72, #f17ca0, #94c7cf, #ffa168, and #e8b2d3) to maintain bra...
...have a stack of physical documents that need to be input into an Excel spreadsheet. Your task will be to transfer this information accurately and efficiently. Key Requirements: - Proficiency in Excel: You will need to have a good working knowledge of this software, and be able to use it to create a well-organized database from the information provided. - Attention to Detail: While I don't expect perfection, I do need the data input to be mostly error-free. Accuracy is key. - Physical Document Handling: As I will be sending you hard copies of the documents, you will need to be able to handle and return them safely. This project is great for those with a good amount of data entry experience, and who are c...
We are seeking a skilled freelancer to develop a simple PHP script focused on data visualization, specifically catering to planetary hours. While the script's core functionality can be achieved through ChatGPT, we believe an experienced individual can deliver efficient results promptly. Description: We require a straightforward script to display planetary hours based on location and date input. Key Functions: The script will closely resemble the functionality of this sample site, with additional features: - Integration of Islamic (Hijri Date) display alongside the conventional calendar. - Option for users to select their location, with the flexibility to change it as needed. - Enhanced visualization by displaying the names of ...
I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a ...
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required st...
...System developed with Python. The key components required are: - Use of the YOLOv8 model for plate detection. The detection should be real-time using webcam. - An incorporated Optical Character Recognition (OCR) library for the recognition part. - It should match the characters of license plate from an excel sheet that already contain the data of college cars in an excel sheet. - A model that produces at least 95% accuracy. - An easily navigable user interface. The system does not need to process an enormous amount of data daily, as it will be dealing with less than 500 entries. Thus, the solution should be designed with this volume in mind. Ideal applicants are experienced in Python programming, YOLOv8 model applications, and OCR libraries. An understanding of u...
The project aims to develop an IoT sensor-based bazaar light that can be easily fixed onto any product. The light will be activated remotely via a mobile application, allowing users to locate the product in real-time. This solution involves minimal circuitry and compact design for seamless integration onto various items.
I'm looking for someone based in Paris, France to help me receive Shein clothing items on a monthly basis and forward them to me in Morocco. Ideal Skills and Experience: - Professionalism and reliability in handling packages - Regular access to a post office or courier service - Good communication skills for coordinating with me Key Responsibilities: - Receiving Shein clothing packages on a monthly basis - Safely storing the items until shipment - Forwarding the package to me in Morocco in a timely manner - Providing me with tracking information for the shipment Package Size: The packages I expect to send are medium in size, weighing up to 20kg. It's crucial to handle them with care and ensure their safe for...
I'm in need of a skilled developer to build a detailed warehouse management software, proficient in creating feature-rich applications. This project includes aspects such as inventory management, SKU linking and comprehensive sales reports. Features: - Inventory management: This involves tracking item quantities, receiving and restocking items. - Setting up alerts for low stock, and providing daily updates on stock in and out. - SKU linking: The ability to link SKUs effectively to a master SKU. - Generating detailed sales reports, including merging data from all sales channels, which must be compatible with uploading to Tally. Ideal freelancer would have previous experience in Python-based application development, and a solid understanding o...
Looking for a skilled data entry specialist who can efficiently transfer plain text data into a structured spreadsheet. The type of data to be entered is purely textual, excluding any numeric or mixed data. The target platform for data entry is a user-friendly spreadsheet. However, the source of data is not specified, implying a need for a flexible and independent professional who can adapt to various sources. Ideal Skills and Experience: - Proven experience in data entry - Excellent knowledge of MS Excel - Fast typing speed - Attention to detail - Ability to work independently
