Excel vba if and multiple conditionsdela
Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server
Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent
Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..
Pripravljamo obsežen program marketinških aktivnosti s poudarkom na video povezavi ( , ) si lahko natančno ogledate, kakšne video posnetke potrebujemo, pri tem pa upoštevajte, da imamo trenutno cca. 10 takšnih...da imamo trenutno cca. 10 takšnih oseb torej 10 različnih videov. Konkretneje bi nas zanimal: • Čas izvedbe, • pričetek dela, • cena. Vsi tisti ki menite da nam lahko v dotični zadevi pomagate, ste strokovni in konkurenčni, vas vabim k sodelovanju! Za vsa dodatna vprašanja smo vam na voljo na elektronskem naslovu: [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] Lep pozdrav, Sergej Merc
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
...devices Functionalities: - Booking and reservation system: This is a core feature of the website. Users should be able to easily book and reserve products/services. - Availability calendar: A must-have feature. Customers need to be able to see available slots or products. - User reviews/ratings: Essential for building trust and reliability among customers. Payment Integration: - Credit card, PayPal, Cryptocurrency: These are the primary payment methods I'd like to integrate. - Cash on site: I'd also like to incorporate a cash payment option for users who prefer to pay on delivery or on-site. Ideal Skills and Experience: - Proven experience in developing E-commerce websites is a big plus. - Deep knowledge in integrating payment gateways, especia...
I am looking for an expert in Python programming to assist me in ...assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if...
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
...a multi-user web portal that will facilitate the connection between trainers and students. The portal will have the following features: - **Multi-Login System**: There needs to be a seamless and secure multi-login system to accommodate both trainers and students. - **Search Functionality**: Users should be able to search for trainers or classes based on the city or trainer's name. This will make it easy for students to find trainers that are close to them or whom they may have heard of. - **User Profiles**: Each trainer or class should have a detailed profile which includes: - Biography: A brief description of the trainer and their training methods. - Reviews and Ratings: Users should be able to rate and write reviews about the tra...
I have a high-resolution JPEG image with brown grass that I need altered to a natural-looking green. The picture is of exceptional quality, so the adjustmen...natural-looking green. The picture is of exceptional quality, so the adjustment needs to be very precise. Key requirements: - Change brown grass to a natural looking green across the entire image - The color change should be seamless and look realistic in all lighting conditions within the photo Ideal Skills and Experience: - Proficient in Adobe Photoshop with experience in high-resolution photo editing - Strong color correction and natural-looking color matching skills - Attention to detail and ability to make the change look as realistic as possible Please only apply if you have a portf...
...skills and experience for this job include: - Strong proficiency in PHP and Prestashop - Experience with PayPal module customization and integration - Knowledge of Prestashop Multishop feature - Familiarity with coding for extra security measures and user interface improvements TASK 1 Reset Prestashop database. Setup on new. (Google cloud server) 1. Clean the prestashop directory, CMS pages and empty links. 2. Make a backup of the current Prestashop database including clients, orders, products, pictures, CMS pages all other information needed for a full reset. 3. Upload backup. 4. Setup all modules setting as was before the reset. Movic theme, Onepagecheckout, Crypto payments, PrettyURL, and Google reviews, rich snippet. TASK 2 ...
...applications. Ideal Skills and Experience: Proficient in Windows application development. Expert in low-level programming, specifically in system-level assembly language. Knowledgeable in gaming input emulation and keyboard input simulation. Experience in backend applications is beneficial. Project Specifics: The emulator must not breach game firewall securities or require unauthorized system modifications such as disabling driver signature enforcement. It should operate successfully in the game, similar to devices like Arduino Leonardo or ESP32. The goal is to simulate pressing the Z1 keys solely through software, without external devices. Activation should be tied to the Caps Lock LED status—active when on, and inactive when off. Solutions utilizing '...
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes ...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note th...
I need a proficient data operator to help manage our customer and product data. The primary goal of this project is to improve our customer experience. Key responsibilities include: - Handling and organizing customer and product data from multiple sources - Ensuring data accuracy and integrity - Implementing strategies to improve customer experience based on data insights The ideal candidate should have: - Previous experience in managing customer and product data - Strong analytical skills and attention to detail - A good understanding of customer experience and how data management can contribute to its improvement.
...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compat...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
...to create a set of social media graphics. Key Responsibilities: - Designing social media graphics for Instagram, Facebook, and Twitter. The graphics will be used on my van's design, so experience in creating graphics that can be applied to a vehicle is a great advantage. I need these graphics as soon as possible, hence I'm looking for a responsive and efficient professional who can deliver quality work swiftly. Ideal Skills: - Proficient in graphic design tools like Adobe Photoshop or Illustrator. - Experience with creating graphics for multiple social media platforms. - Prior experience with vehicle graphics a plus. If you can deliver high-quality work promptly and have the skills necessary for this job, I'd love to hear from you. ...
...need of a comprehensive and user-friendly online store design that will cater to the needs of both homeowners and renters. Specifically, the shop will feature a variety of home products related to water, including water filters, faucets, and shower heads. The challenge lies in ensuring the design is appealing and intuitive for a diverse audience, as well as the seamless integration of an e-commerce platform. Key Requirements: - Aesthetically pleasing and modern design - Intuitive user interface that maintains simplicity - E-commerce platform integration - Responsive design for mobile devices Ideal Skills & Experience: - Proven experience in e-commerce website design, especially in the home product niche - UI/UX design expertise, with a focus on u...
...is appealing and stands out. Requirements: - Modern Design: The 3D beauty bed design should be modern, sleek, and elegant. (I have a picture of how I would like it to be) - Color Variations: The beauty bed should be available in black, white, pink, and cream. These colors need to be vibrant and suitable for a beauty bed. - Urgent Delivery: I am looking to get this done as soon as possible. The final deliverable will need to be in a format that I can easily edit on Canva. Therefore, please ensure that the files are compatible and easy to work with. Ideal Skills and Experience: - Proficiency in 3D design, specifically for beauty products - Experience with modern design aesthetics - Ability to deliver high-quality, editable files I look for...
...to create a set of social media graphics. Key Responsibilities: - Designing social media graphics for Instagram, Facebook, and Twitter. The graphics will be used on my van's design, so experience in creating graphics that can be applied to a vehicle is a great advantage. I need these graphics as soon as possible, hence I'm looking for a responsive and efficient professional who can deliver quality work swiftly. Ideal Skills: - Proficient in graphic design tools like Adobe Photoshop or Illustrator. - Experience with creating graphics for multiple social media platforms. - Prior experience with vehicle graphics a plus. If you can deliver high-quality work promptly and have the skills necessary for this job, I'd love to hear from you. ...
...user-friendly, and secure platform for booking rides. Key Features: - GPS Tracking: The app must have a reliable GPS tracking feature to ensure accurate location-based services. - Ride Booking: A well-optimized booking system that allows users to easily book, cancel, and track their rides. - Payment Integration: Secure, efficient, and user-friendly payment gateways to facilitate smooth transactions. The budget is 2500-3000 INR Cross-Platform Development: The app should be available on multiple platforms including iOS, Android, and Web, ensuring a wide accessibility and user base. Ideal Candidate: - A seasoned app developer with a strong portfolio of similar projects in the ride-sharing or transportation sector. - Proficient in cross-platfor...
...looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This ...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.
...Ticketmaster, Live Nation, ThaiTicketMajor, and BookMyShow Malaysia. The ideal bot should be able to perform several functions: - IS A MUST TO KNOW WHAT IS QUEUE-IT SYSTEM - Search and display available tickets - Add tickets to cart and checkout - Send notification when tickets are available - Simultaneous requests : send multiple requests at once to increase chances of securing tickets - Queue management : handle queue-it system's virtual waiting room effectively, maintain session and user states to handle queue redirects - Human Simulation : mimic human behavior to avoid detection (randomized request intervals) - Technical requirements - use session management and different proxies/ips, implement captcha solving techniques or third-party...
...our operational strategies and enriching support systems for startups within the Web3 and DeFi sectors. This role requires a proactive individual to enhance our accelerator’s offerings and ensure they are perfectly aligned with the needs of startups in this rapidly evolving industry. Key Responsibilities Design, implement, and refine accelerator program structures specifically tailored for Web3 and DeFi startups. Facilitate seamless coordination across internal teams and external partners, ensuring alignment with the DAO’s token economy and governance structures. Develop and maintain strategic partnerships critical to the blockchain ecosystem. Manage the logistical and organizational aspects of the program to gu...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm looking to create a PVC card that will serve as a...serve as a loyalty card for my fashion brand, Auraya, in collaboration with other brands. Key Requirements: - The card should include the customer's name and contact details, the Auraya brand logo and name, as well as the logos and names of the collaborating brands. - The design should be minimalistic and modern in style. Distribution: - The PVC cards will be handed out in person Ideal Skills and Experience: - Graphic Design: A strong portfolio of minimalistic and modern designs is crucial. - Branding: Experience creating cohesive branding materials for multiple brands. - Loyalty Program Design: Knowledge of loyalty card design and customer information incorporati...
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel whi...
I am looking to fill a longterm editor position for multiple projects for my agency. I run a short-format content agency that edits videos for various coaches, businesses and podcasts. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 7usd for every video-edit. The process is super streamlined. All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple t...
...I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file con...
...dynamic and innovative social media marketing agency dedicated to helping businesses thrive in the digital landscape. Our team is passionate about crafting creative strategies and delivering measurable results for our clients. *Role Overview:* As a Lead Generation Expert, you will play a crucial role in identifying and engaging potential clients interested in our social media marketing services and closing deals with them. You will utilize various research and outreach techniques to identify leads, initiate conversations, setup sales call, and nurture relationships with prospects. *Key Responsibilities:* 1. Research and identify potential clients through online platforms, industry directories, and social media channels. 2. Deve...
Seeking a skilled and experienced photographer who can capture the essence of an 18th birthday/debut. The location of the pictorials would be both indoor and outdoor; therefore, experience in varied lighting conditions is highly desirable. Key Requirements: - Expertise in both traditional and candid styles of photography. - Ability to dedicate 2 hours for a comprehensive pictorial session. - Familiarity with shooting for occasions such as debuts/18th birthdays. In summary, I'm looking for a professional who can adeptly manage the camera to make this occasion memorable.
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
I'm seeking a creative and talented graphic designer to craft a modern logo that reflects my brand. Key Project Details: - Design Style: Modern - Usage: Primarily online (websites, social media) and occasionally in print (business cards, flyers) - Color Preferences: Bright and vibrant Ideal Skills and Experience: - Proficiency in modern logo design - Strong understanding of online and print design principles - Ability to work with bright and vibrant color schemes - Past experience with creating logos that are versatile across multiple mediums Please include a link to your logo design portfolio in your proposal. Looking forward to seeing your unique and innovative ideas! logo is for an CRM Application called Digital Glide ( w...
I'm in need of an experienced Shopify expert to set up a compre...be able to support a catalog of 51-100 products. It should allow for easy addition, modification, and removal of products. - Shopping Cart: A seamless shopping cart feature is essential for a smooth customer experience. It should be user-friendly and support multiple purchases. - Payment Gateway: Integration of a secure and reliable payment gateway is a must. The gateway should support major credit cards and other common payment methods. Please note that the project is for the website setup only. The design aspect will be handled separately. Experience in e-commerce website development, specifically on the Shopify platform, is a significant advantage. A strong understanding of FMCG bu...
I'm seeking an app developer in the Philippines to collaborate with a skilled web developer on a unique project. The app will have multiple functionalities, including user registration and login. Your role will involve closely working with the web developer to ensure seamless integration between the web and mobile platforms. The ideal candidate would: - Have prior experience in app development - Be based in the Philippines - Be able to work closely with a web developer - Be proficient in integrating a variety of functionalities - Have a creative and collaborative mindset Please note that the target audience for this app has not been specified, so you should be comfortable working on a project with potentially broad appeal.
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
I'm seeking a skilled developer to integrate the Razerpay payment gateway into my custom-built website. The project will include the following requirements: - Integration of Razerpay payment gateway: The developer should be experienced in integrating payment gateways and should have specific experience integrating Razerpay. - Multi-currency support: The payment gateway should be able to handle transactions in multiple currencies. This may require additional configurations on both the gateway and the website itself. Ideal Skills: - Proficient in web development - Experience with custom-built websites - Experience with Razerpay integration - Knowledge of multi-currency payment processing
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displa...
I'm seeking a skilled professional who can help me with a malware issue affecting multiple websites I own. - All my websites are experiencing the same type of malware. - The primary issue I'm facing is the presence of the malware on the websites. The ideal candidate for this job should have the following skills and experience: - Proven experience in malware removal and website security. - Familiarity with various malware scanning tools. - Implement security measures to avoid future attack
...create a state-of-the-art medical coding and billing software. This software should be packed with various features such as: - Patient Information Management: Manage patient's data with utmost ease and accuracy. - Claims Processing: Streamline processing and tracking of patient claims. - Reporting and Analytics: Generate concise reports and conduct in-depth analytics. - Medical coding: Incorporate an AI-powered module to provide coding suggestions. One of the compelling additions I desire is the integration of AI functionalities mainly for predictive diagnostics. This should help in forecasting medical conditions based on the available patient data. The candidate for this project should preferably have a background in healthcare software ...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
...with a clean and minimalist design for my Head Spa business. The course should be geared towards working professionals and should incorporate video tutorials, written instructions, and interactive quizzes. |I also require my landing page on Thinkific to be worked on. It's half done but needs refining. You must be fast and efficient with examples of similar work you've competed. Please do not apply if you are juggling multiple projects. I need someone dedicated to getting this completed within a few days. The ideal candidate for this project should have: - Experience with Thinkific course creation - The ability to develop clear and concise video tutorials - Skills to create engaging written instructions - Experience in d...
I need an employee time tracking syste...allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with employee attendance tracking - Ability to create a user-friendly interface t...
...with a primary focus on visual design. - Ensuring the new UI is fully aligned with the iOS design guidelines. - Retain and enhance the core functionality of the app for a seamless user experience. Deliverables: Task 1: Redesign the user interface for an application. • Show 9 sketches of the interface design, Images, screenshots, ets. Task 2: Design 3 posters for the phone application. • Design poster that calls to shop online. Use more than one realistic photo for each poster. • Create a creative composition image that uses multiple techniques in selections, color correction, lighting, and shadows. Task 3: • Try to make a creative and neat layout for the application and poster. Supported upload file types are jpeg, pdf Subm...
I'm in search of an experienced and compassionate care manager to assist with the management of mental health issues related to chronic illnesses. Your responsibilities: - Providing weekly summaries and updates on the mental health of patients suffering from chronic diseases. - With our newly developed case management tool, you will be using it in a selected hospital of ours and rate how the tool works well in the medical field. - main task would be; telehealth, care plan creation, track patients' condition etc. Skills and prerequisite required: - Works in the United States - Prior experience in care management, specifically in the context of chronic diseases or mental health. - Strong understanding of mental health issues, particularly as they rel...
I am seeking an individual or team with extensive experience on Shopify platform. Our website is on Shopify platform and we need to make some modifications, details mentioned below: - We need to have different pricing structure, different offers and different shipping rates for international customers. - Interlocking conditions for different transactions. example: discount code can be applied only to prepaid orders - auto play video on the home page - improve overall speed of the mobile site
