Excel vba hide rows based on cell valuepráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

hello sir ji

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

Vytváříme personalizované dřevěné předměty a potřebujeme zvýšit povědomí o značce, o produktech, zvýšit followers.

datae

datae

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

Zdravím, měl bych nabídku na dlouhodobější projekt (vývoj standalone aplikace, ne webové) a v případě zájmu pošli více informací.

...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...

I'm looking for a skilled developer to create a custom script for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy, the required...

**My budget is less than $100 I'm currently at the startup ...detailed business plan that includes market analysis, financial projections, and a clear path towards profitability. - The plan should be tailored to attract potential investors, showcasing the value of my business and the potential for high returns on investment. Ideal skills and experience for this job include: - Proven track record in writing successful business plans that have secured funding for startups. - Deep understanding of the current market and industry trends. - Strong financial analysis and forecasting skills. - Excellent communication skills to clearly articulate the business's value proposition and growth potential. - Ability to work collaboratively and iteratively, taking into ac...

I need an expert in data entry, cleaning, and data visualization in RStudio. The primary goal of this project is to identify trends in a small dataset (less than 1,000 rows). Ideal Skills and Experience: - Expertise in data entry, cleaning, and visualization in RStudio - Strong understanding of R Programming - Proven experience working with small datasets with missing data - Ability to identify trends through data analysis Please only apply if you have demonstrable experience with RStudio and data analysis. The ideal candidate should be able to extract meaningful insights from data and present them in a clear and concise manner.

As an expert in business strategy, I'm seeking a self-driven sales professional to scout for potential clients and connect them with my consultancy services. Key Responsibilities: - Proactively engage with startups, introduc...Candidate: - Proven track record in sales, ideally within consultancy or a related field - Strong understanding of business strategy and its application to startups - Excellent communication and negotiation skills - Self-motivated and able to work independently - In-depth knowledge of the startup ecosystem and a strong network within this space This role is commission-based and offers a lucrative opportunity to earn based on successful client acquisition. If you're passionate about startups and business strategy, and have a knack for...

...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a m...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precision are paramo...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamles...

create a captivating ad for Meta platforms and other digital ad spaces. The ad should feature our logo in a simple yet eye-catching animation, accompanied by additional text to convey a special sale message. so the design should be straightforward and appealing. along with the logo animation. The text should be: Website design and deployment $299 when you mention Spring Sale and or “730” $675 Music Video Production sale. Payments plans available.

...Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It should be easily configurable for clients and capable of pulling data from databases, Excel, or Google Sheets. Ideal candidates for this project should have a strong background in software development, particularly in AI and chatbot technology. The ability to create a u...

...4 distinct designs and each can be used on multiple merchandise items. Key requirements: - Exceptional ability in logo design, illustration, and typography design - Proficiency in creating a message in style design. - Deep understanding and appreciation of local culture and heritage. - Appreciation of community and the small business role in creating strong communities - Will need files in reproducible format at least 300 DPI The ultimate goal is to produce designs that express our sense of community and our dedication to supporting local small businesses. The right candidate will have a creative mind and a keen eye for details. Work will be used on merchandise including Tote bags, T-shirts, Hats, etc using printful as the supplier. Previous work on similar proje...

...or any other relevant hardware as required - The BMS should include essential safety features such as: * Temperature monitoring * Short circuit protection * Cell balancing * Reverse polarity protection - The system should allow for charging and discharging through the same port I need this project to be completed within a month. Ideal skills and experience for this job include: - In-depth knowledge and experience in BMS design, particularly with LiFePO4 batteries - Proficiency in creating flexible BMS systems with variable ampere capacity - Extensive experience with temperature monitoring, short circuit protection, cell balancing, and reverse polarity protection - Ability to deliver the project within the stipulated timeframe - Strong problem-solving skills an...

I'm seeking a professional to design a sales pitch deck for my business. The aim of this presentation is to effectively reach potential customers. The deck should be comprehensive, visually appealing, and persuasive. Key Elements: - The pitch deck should have 10-20 slides, ensuring it's rich in content yet concise enough to maintain the audien...customer-focused approach. Ideal Skills and Experience: - Proven experience in creating sales-oriented pitch decks. - Strong understanding of visual design principles. - Familiarity with creating impactful, persuasive content. - Prior experience in designing presentations for potential customers is a plus. Your primary goal will be to craft a compelling pitch deck that effectively communicates the value proposition of my busine...

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...

...an engaging landing page that effectively promotes my product or service. The focus is on presenting product features and benefits, testimonials from satisfied clients, and clear pricing information. Key elements to include: - Design: A visually appealing layout that builds interest and trust. Utilize colors, fonts, and images that align with the product/service and resonate with the target audience. - Product Information: Display the product features and benefits in an engaging and easy-to-understand manner. - Testimonials: I want to include positive testimonials from customers to build credibility and trust. - Pricing: Clear and transparent pricing information that helps the visitor understand the value proposition of the product. I'm looking for a designer who c...

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a skilled designe...detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver high-quality work quickly, I...

I need an automation expert to streamline my data entry process on Google Sheets through app script. Key Requirements: - The automation is triggered when the number is input in the cell. - The data source for this automation will be online forms. - we have three google sheets. and the same scenario where we need to triggered a message via Twilio. Ideal Skills and Experience: - must be able to show the demo. - Proficiency in Google Sheets and App Script. - Experience in automating data entry processes. - Knowledge of Twilio and Whatsapp API is a plus.

I have a simple iOS app with subscriptions enabled, I would like to track conversions in real time by integrating mixpanel to my existing code. Should be an easy job if you know how to integrate mixpanel sdk and conversion tracking on the current code. Looking for someone that already integrated this successfully on an iOS app

...layer of security for the riders, besides the existing emergency protocols. The riders will often be in remote areas in the mountains, with no cell reception or internet, therefor the app needs to be able to handle offline navigation on predefined tracks, which need to change every race day. Mobile App Requirements 1. Map Display with Custom Data: The app should display a map with custom data layers relevant to the user. This can be GPX files with Waypoints and tracks or a completely custom map file. 2. Offline Functionality: - Both the app and the map should be fully functional offline, ensuring accessibility without an internet connection or cell reception. The displayed map should be the one valid for the current day (the map changes every race day). 3. Eme...

I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer inf...

I need a skilled Flutter developer to help me enhance my existing app with new features at the earliest. Key Responsibilities: - Collaborating with me to understand and implement the new features that will add value to the app. - Ensuring the new features are seamlessly integrated and the app's overall performance is not compromised. - Conducting testing and debugging to ensure the app is completely free of glitches before it's released. Ideal Candidate: - Must have substantial experience working with Flutter and be able to demonstrate previous work. - Should be able to work on a strict timeline and deliver the project ASAP. - Ability to work collaboratively, take direction, and communicate effectively.

I'm planning a crowdfunding campaign to raise funds for a charity or cause. I ...transparency: The successful candidate should have a strong understanding of the legal requirements and best practices for running a donation-based campaign. Ideal Skills and Experience: - Proven track record: I require a professional who has a successful history of running donation-based crowdfunding campaigns for charities or causes. - Marketing and communications: An expert who can create effective messaging and campaigns that resonate with target audiences. - Relationship-building: Strong networking skills and experience in engaging specific interest groups. If you have experience in this area and can help me create a successful and impactful donation-based crowdfunding campaig...

I am seeking an experienced developer to create a customized text-based chat platform using WordPress and chat plugins. Requirements: The chat function must align with a client’s credit limit and rate per minute. The chat should close automatically when the client’s credit reaches zero or if the client decides to end it. The system should handle disconnections gracefully, maintaining the client's credit balance by deducting only the time spent. The client's credit balance should always reflect the amount spent and the remaining balance available for future use. The deduction rate should be accurate, regardless of whether it's 0.5, 1, or 2 credits per minute. The system should automatically track and deduct credits based on the time spent in...

Small update to the android app. Change the payment gateway "cryptomus" to stripe. After that. Compile the code to obtain the apk version and an .aab version that will be used in the Google Play Store. In turn, upload the updated code to the app server. Send me the updated source code as well. The app is made on react Native, and the backend is Python. All the API's are made on Python. This may require modification in FrontEnd. in that case. You must be able to complete the project. Maximum budget $300

...that includes green. It could be only green or green with other colors. Shire Group is a construction and real estate development company specializing in traditional stone construction homes and development of agricultural neighborhoods. Our homes are natural, built in a traditional style, and connected to the outdoors, durable, and oriented to community interaction. The people who buy our homes value living in community, participating in the production of food, enjoy homesteading, appreciate historical architectural styles, and enjoy the outdoors. Many of the people interested in our homes are religious and appreciate the religious art in our neighborhoods. Some symbols that we connect with our brand: castle, tower, shield, tree, livestock, market, medieval or renaissance font...

I need a professional SEO expert to optimize my website in order to improve our search engine rankings on Google. - The main goal for the project is to increase organic traffic and visibility on Google. - I have a list of specific keywords and phrases that I would like to target. - The work is urgent, so quick and effective execution is essential. Ideal Skills and Experience: - Proven track record of successful SEO projects, especially on Google - Expertise in keyword research and optimization - Ability to implement and execute strategies quickly, with a focus on achieving results in a timely manner. Please include any relevant past projects or case studies in your application.

I'm in need of a consultancy service for integrating Telegra...platform. Key Requirements: - Implementing Telegram VoIP for seamless voice communication - Focused on making the feature user-friendly - Web-based platform The project's primary goal is to introduce a voice calling feature that is both easy to use and reliable. Hence, your expertise in Node.js and experience with TDLib will be vital. The ideal consultant will understand the nuances of VoIP technology and be able to seamlessly integrate it with our existing web application. Your role will be to provide guidance on the integration process, ensuring that the end product meets the needs of our users. Any prior experience in similar projects or a strong understanding of VoIP and web-based...

I'm in need of a talented copywriter who...specific experience in the e-commerce and sales field - Proven track record of increasing sales through copywriting - Adept at understanding target audiences and tailoring content to maximize conversions Your tasks will include: - Crafting persuasive and engaging copy for our product pages - Writing compelling sales emails to our customers, with the aim of driving sales - Creating promotional, value-driven content for our website This project requires someone with a keen understanding of the psychology of selling and who can translate that into effective, results-driven copy. A background in marketing and e-commerce would be a strong advantage. The ultimate goal of this project is to significantly boost our sales figures through the ...

I am searching for a talented meme creator to produce entertaining, image-based memes for a general public audience. - The primary purpose of these memes will be to entertain, rather than focusing on brand promotion or social media engagement. - The memes are to be crafted for a general public audience, so a good understanding of mainstream humor and pop culture references is essential. Ideal skills for the job include: - Graphic design and image editing - Proficiency with popular meme formats and trends - Creativity and a good sense of humor - Understanding of mainstream humor and pop culture references I am looking for someone who can create engaging, shareable memes that will resonate with a broad audience.

I'm in need of a consultancy service for integrating Telegra...platform. Key Requirements: - Implementing Telegram VoIP for seamless voice communication - Focused on making the feature user-friendly - Web-based platform The project's primary goal is to introduce a voice calling feature that is both easy to use and reliable. Hence, your expertise in Node.js and experience with TDLib will be vital. The ideal consultant will understand the nuances of VoIP technology and be able to seamlessly integrate it with our existing web application. Your role will be to provide guidance on the integration process, ensuring that the end product meets the needs of our users. Any prior experience in similar projects or a strong understanding of VoIP and web-based...

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used...professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward...

I'm looking for an experienced financial analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financ...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

I need an access control system that's structured based on the roles my users have, similar to the old system. Key Requirements: - I need the system to manage user permissions on an individual basis. This means that each user should have unique permission settings. - The system doesn't need to have options for temporary or time-based access permissions. Ideal Skills and Experience: - Strong background in access control systems. - Experience implementing role-based access control is essential. - Proficiency in customizing user permissions on an individual basis in a system.