Macro for vlookup multiple sheets työt
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
...the challenge of mass importing 100 exams, each composed of 50 to 100 multiple choice questions. Each question has two incorrect answers and one correct answer, with specific feedback. The scoring structure is critical: each correct answer adds 0.1 points out of 10, while each incorrect answer subtracts 0.5 points. Project Needs: Advice and Effective Execution: We are looking for a Moodle expert who can guide us and execute the import of these exams correctly and efficiently. Import/Export Troubleshooting: We need to overcome current bugs that prevent scores from being calculated properly and other glitches during the import and export processes. What do we expect from the Freelancer? Proven Experience: We are looking for professionals with demonstrable experien...
Hi there! I am looking for a skilled app developer to create a rideshare platform for my personal driving business. The app should be accessible on both iOS and Android platforms and should be capable of offering a variety of payment methods for rides, including credit card, PayPal, Venmo, Zelle, Cash App and cash. Key Features: - User Registration and Login: Users should be able to create accounts, log in easily, and manage their profile information. - Ride Request and Booking: The app should allow users to request a ride and offer a price, see drivers bids, and pick a driver and book their ride. They will be able to schedule a future ride as well. - Drivers will be able to bid on jobs, or accept a customers price. - Drivers and customers will both be able to use th...
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm requiring a data scrapping software quickly to extract text content from both websites and PDF documents. It's crucial that the scraped data is directed into Excel or Google Sheets format for my immediate use. Ideal skills for this job would be: - Proficiency in programming languages like Python that are often used for data scrapping. - Familiarity with web scraping libraries or frameworks, e.g., Beautiful Soup or Scrapy. - Experience using APIs to scrape data if necessary. - Previous work in pulling data from PDFs into readable formats in Excel or Google Sheet. - Ability to deliver the project ASAP. Your attention to these requirements will be much appreciated as I need this task done urgently. Please contact me if you need more detail about th...
I'm in need of a tech-savvy programmer to build a comprehensive project management software using Trello/ Clickup/ along with Zapier mainly. Some additional software will be google sheets, Jibble.io. This platform should enhance task management, encourage team collaboration, and streamline our time tracking efforts. The key functions of this software should include: - Task Management: The ability to create, assign, and track tasks is essential. The software should allow for task categorization, deadline setting, and progress tracking. - Team Collaboration: The software should facilitate superior communication and collaboration. Features might include chat functions, file sharing capabilities, and project timeline views. - Time Tracking: To enable productivity analys...
Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.
I am in need of a certified Google Cloud engineer to help with multiple tasks namely, Cloud migration, Infrastructure setup, and Application deployment on the Google Cloud Platform. Your key responsibilities would be: - Google Cloud Platform migration and set-up - Application deployment on Google Cloud A clear understanding and broad experience of Google Cloud is critical for this project. Ideally, you hold Google Cloud Certifications which showcase your expertise and finesse with this platform. Given the sensitive nature of the information we will be dealing with, it is paramount that you have an understanding of Google's cloud security standards and certifications. Whether you have worked on similar tasks before or hold pertinent certifications, I'd love to h...
Administrative and Documentation Work Phase #1 Multiple deliverables are needed and will be communicated with the freelancer and tasks will be created
I have an Android application that I'd like to enhance with ...review feature. - The reviews should be submitted on a third-party platform linked from the app. - Ideally, I'd like to incorporate some form of user authentication before reviews are accepted. I'm open to suggestions on how to best handle the authentication process. The overall goal is to encourage genuine and constructive feedback while preventing spam or irrelevant reviews. I'm looking for a developer with experience in Android app development and implementing user engagement features. It's important that the final solution is user-friendly, secure, and seamlessly integrated with the existing app. Your ability to propose and implement a secure and user-friendly authentication process wi...
...packaging art for my cookie business. The material will be lay-flat packages, with the exact dimensions being 120x120 millimeters. Skills and Experience Required: - Practical knowledge in Packaging Design - Prior experience designing flexible, lay-flat packets - Efficient in communication, decision-making, and revisions - Familiarity with cookie-based products is a plus REQUIREMENTS: 1) Please ensure all fonts are outlined and artwork is embedded into the template 2) All colors set up in CMYK + White 3) Artwork sent back in AI format 4) please leave a section clear and indicate it will be a window section Provided is a rough mock up of the simple design we require. We will also need you to provide multiple options for the font on the front of the packaging as we...
...I need a software done for my auto repair shop business with the following requirements: 1. Inventory Management: Track auto parts and supplies in stock. Automatic updates based on sales and purchases. Low-stock alerts for inventory levels. Supplier management for ordering parts. 2. Service Management: Track service history for each vehicle. 3. Reporting and Analytics: Sales reports for revenue and profit margins. Inventory reports for stock levels and turnover rates. 4. User Management and Security: Secure login/authentication. Role-based access control to restrict access to sensitive information based on user roles (e.g., technician, manager, accountant). 5. Parts Catalog and Pricing: Add new parts and update pricing. Estimation Tools: Genera...
I'm looking for a Python developer working with Selenium to develop two separate apps. These apps are required to automate the submission of URLs from Text file to two different directory websites. Both websites only accept one URL submission at a time, therefore I need a solution to streamline this task. The data to be submitted is URLs only, with no additional company, product, or service details to be included. Key tasks include: - Building a user-friendly application that can handle and submit multiple URLs to each respective website - Ensuring each app is configured to submit URLs in the specific format or template required by each directory website Ideal skills for this project: - Proficiency in Python and Selenium - Strong experience in web scraping a...
It allows the users to Custom Pet Portrai...as Necklaces, hats, accessories etc. can also support the Users to custom their own pet Portrait by AI prompt. AI Editing and Multiple Print Sizes. Editing: Allow users to provide text prompts to refine the AI generation. For example, "thicker beard" or "wearing a red bandana." a tool like CLIP (Contrastive Language-Image Pre-training) to let users edit specific aspects of the portrait based on text descriptions. an image scaling library within your app to resize the generated image for different print sizes without losing quality. Tips: Consider offering a "surprise me" option where the AI generates a random portrait for the user. users to share their creations on social media dire...
I am searching for an efficient freelancer, who is proficient in spoken Czech/Slovakian. Your primary task will be to confirm the shipping addresses for new orders. These orders from our perfume webshop will be generated multiple times a day, so exceptional organizational skills are a must. Calls to our customers need to be made during morning or afternoon business hours; therefore, availability and adaptability to these timeframes are crucial. Ideal Skills: - Fluency in Czech/Slovakian - Excellent verbal communication skills - Customer service experience - Ability to work during specified hours - Strong organizational skills. Expect to interact extensively with our new customers, ensuring their orders are delivered seamlessly. Your affable communication will am...
Job Responsibilities: MUST BE FROM KOLKATA Develop and maintain server-side applications using Node.js Collaborate wi...Understanding the nature of asynchronous programming and its quirks and workarounds Solid understanding of RESTful APIs Experience with NoSQL databases (MongoDB, Cassandra, etc.) Good understanding of server-side templating languages Basic understanding of front-end technologies, such as HTML5 and CSS3 Understanding accessibility and security compliance User authentication and authorization between multiple systems, servers, and environments Nice to have: Experience with cloud platforms (AWS, Azure, or GCP) Knowledge of containerization and orchestration (Docker, Kubernetes) Familiarity with continuous integration and deployment (CI/CD) pipelines Benefits: Competit...
Hello ! Looking for a Freelance 3D Video Editor for an Educational Project! Description: I'm forming a team to create educational, holistic, and spiritual content for my new YouTube channel, targeting children and mothers. I'm seeking a 3D video editor to collaborate on creating approximately three-minute animated videos. Responsibilities: Edit 3D videos according to the provided script and music. Create innovative and creative content that engages the audience. We look for new authentic and copyright-free content. Requirements: Experience in 3D video editing. Ability to meet agreed-upon deadlines. Offer: Payment of $120 per video, with the possibility of creating multiple videos based on your work pace. Opportunity to be part of an exciting...
I'm seeking a p...detail-oriented PHP developer to shape an e-commerce website on WooCommerce for my business. The website will need to feature: • A seamless user registration and login mechanism ensuring frivolous sign-ups are at a minimum. • Robust payment gateway integration, making online transactions secure and efficient. • Social media integration enabling connectivity with multiple platforms. A solid background in PHP development, WooCommerce, and e-commerce web development is crucial for this project. Experience with payment gateway integration and social media integrations will also be highly beneficial. The goal is to create a smooth online selling experience for our customers. An ideal freelancer would share my enthusiasm for...
Description: We are looking for a skilled WordPress integrator to convert our web designs into a pixel-perfect, high-performance, SEO-friendly bilingual website with a mobile-first approach. The project scope includes integrating 24 pages across both desktop and mobile versions (48 page designs total). The ideal candidate will have a proven track record of integrating responsive designs into fast, secure and search engine optimized WordPress sites. Key requirements: Integrate our provided desktop and mobile designs for 24 pages into a fully responsive, mobile-first WordPress theme Implement bilingual functionality in French and English (with possible future languages) Integrate custom designs for product category and product detail pages Integrate our blog design ...
...using mobile sim and will operate on both Android and iOS platforms. Key requirements and responsibilities include: - Developing the app for both Android and iOS - Creating a user-friendly interface for bulk SMS sending - Ensuring the app efficiently sends SMS to multiple contacts - Implementing a feature that allows users to manage their SMS lists - Testing and debugging the application In mobile application there will be a configuration page For setting config values 1) base URL 2) get messages API URL 3) update message status API URL 4) time interval field (in seconds) 5) choose sim card through which we'll send messages The ideal candidate for this project should have: - Proven experience in developing mobile applications using Flutter,...
Hello there, I hope this message finds you well. I am reaching out to invite you to collaborate on an exciting project aimed at revolutionizing heat insulation solutions for metal sheet applications. We are in need of your expertise as a formulation chemist to develop a cutting-edge heat insulation coating that can significantly lower the internal temperature of metal sheets upon application. Our goal is to create a coating that not only provides excellent thermal insulation but also maintains the structural integrity of the metal sheet. More details are in the attached file. Thanks Mahesh
I'm seeking a seasoned software developer to build a comprehensive restaurant management system suitable for Android, using Kotlin and Firebase. This application will not just be an order tracking platform, but a suite that includes features such as: - Order Management: This core function should not only create and track orders, but also be equipped to handle special requests and customizations from customers. - Multi User System: The system should support multiple user logins with varying access rights. - Point of Sale (POS): The system should have integrated POS capabilities - Printing: Thermal Print functionality is a must-have in order to generate customer bills and other essential hard copies. -Reports - sales report, profit etc. The preferred candidate would ha...
I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration
I'm looking for a skilled developer to create an online interface which can upload a Word document and extract key pieces of information to populate a database. Key Requirements: - Extract multiple fields: The tool should be able to efficiently parse and extract a range of fields from the Word document, such as Title, Author, Date, Description, and Quantity. - Metadata Extraction: The primary focus of this project is to extract specific metadata from the document, specifically Date, Description, and Quantity. - Populate Database: The extracted data should then be used to populate a database. Ideal Skills and Experience: - Proficiency in programming languages and tools for working with Word documents. - Experience in developing data extraction and parsing tool...
I'm looking for a financial analyst who can help me with my small business's financial data. Key responsibilities and requirements include: - Analyzing income statements, balance sheets, cash flow statements and projected profits. - Conducting financial analysis twice a year (bi-annually). - Focusing on revenue trends, expense breakdown and profit margins. The ideal candidate should be well-versed in financial analysis techniques and should have experience in dealing with small businesses. A deep understanding of income statements, balance sheets, and cash flow statements is crucial as well. This is a great opportunity for a financial expert who can deliver accurate, actionable insights to help me make informed decisions about my business.
Hi, I need many rewrites. The first batch is of 200 articles. Use the software for humanization or rewriting the content and manually correct the obscure sentences. Check each and every sentence and it should make sense. I will ask for a 100 -150 word sample rewrite on the topic given by me. (Removed by Freelancer) Interested candidates, please bid. Long-term work for the right candidate. We will hire multiple writers. Regards, B
...in Flutter and Firebase to develop a robust restaurant management app. The desired application will incorporate features for order management, table reservations, and menu displays. Key Features: 1. **Order Management:** This function will allow users to manage customers' orders easily. 2. **Table Reservations:** Users should be able to reserve tables via the app. 3. **Menu:** To enable customers to view different meals and their prices, the app will need a menu feature. System Integration: The app needs to seamlessly integrate with a POS system and an online reservation system. Your experience in API integration is desirable. User Roles: The app should support multiple user roles to accommodate administrators, managers, and waitstaff. Each role will have distinct...
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy...
I am establishing an energy company called "Future Energies Africa" and need a modern, dynamic logo to represent my brand. The logo should predominantly feature orange, grey and black tones and include a lightning bolt and the letter 'F'. - Company Nam...The design should be original - It should primarily use orange, grey and black tones, evoking a sense of energy and vitality - Ideally, the logo should include a lightning bolt in a creative and modern way - I'd also like the letter 'F' subtly incorporated into the design The ideal freelancer for this project will have experience in: - Logo design, with a strong understanding of modern designs - Proficiency in using color theory to create engaging, vibrant logos - Ability to incorporate mult...
...recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additional sections beyond the recipes and their nutritional information are not...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is ins...
We're looking for multiple competent native English editors to trim content and help us improve English language usage across a large batch of tutorials. Starting with a paid trial. Please bid $18.
In need of a skilled graphic designer well-versed in minimalistic aesthetics to create an impactful logo and accompanying animation. The deliverables will be used across multiple platforms: * Website * Social media * Branding materials While the elements to include were not specified by me, I expect creative suggestions that would best represent my brand. Perfect candidates will demonstrate: * Expertise in minimalistic design * Ability to create smooth, engaging animations * Strong portfolio of past logo design and animation projects * Clear and prompt communication skills.
I'm on the lookout for a skilled website manager who can handle multiple facets of my E-commerce website. In addition to managing the website, you will also be responsible for marketing through various channels. Key Responsibilities: - **Website Maintenance:** You'll be responsible for ensuring the website is running smoothly, keeping the design up-to-date, and overseeing its overall functionality. - **Content Creation:** As my website manager, you'll be tasked with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include manag...
... I need an expert that can provide us with a unified and consistent brand image. The ideal candidate: - Can create a clean and minimalistic layout - Has a knack for professional and formal color schemes - Is proficient in creating consistent branding elements across multiple platforms At the moment, I am planning for less than ten pages for the corporate website. No specific navigation structure has been decided for yet, so your professional input and recommendations are more than welcome. Top-notch communication skills, creativity and relevant experience in corporate brand creation are the essential qualities I'm looking for in my ideal freelancer. I look forward to reviewing your proposals and portfolio showcasing your previous brand ...
I need a Google Doc converted to Google Sheets while maintaining the formatting of the original document. This will ultimately be a printable document, so the Sheets version should look identical to the original Doc. Key Tasks: - Move all content from the Google Doc to Google Sheets - Copy all the imagery over and have it formatted for easy editing - Ensure that the content is laid out exactly as the Google Doc (as it is a proposal document) - Implement specific formatting requirements such as: - Header and footer - Page numbering - Font styles and sizes (as per a style guide) - Imagery and pictures Ideal Skills: - Proficient in Google Docs and Google Sheets - Strong attention to detail - Experience with document formatting and layout - Ability ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
...captures attention, tells a compelling story, and invokes emotions, you'll be the perfect match for this project. Your responsibilities will involve: - Crafting engaging and cinematic videos - Optimizing content specifically for instagram reels and tiktok. - Implementing branding and marketing strategies within the video content Ideal skills and experience: - Proven experience in video editing, preferably with automotive content - Comprehensive understanding of cinematic style editing - Proficiency with video editing software like Adobe Premiere Pro - Knowledge of social media marketing - Familiarity with car brands and specifications would be a plus. I'm on the lookout for someone who can take multiple projects from commencement to completion w...
I'm looking for a Zoho expert who can help me with improving my inventory management, streamlining sales and customer relationship management, and increasing overall efficiency and productivity. Looking to build a template platform that will be recreated across multiple companies. Key Responsibilities: - Assist with data import/export in Zoho Inventory - Customize fields and layouts in both Zoho Inventory and CRM - Integrate Zoho Inventory with my existing CRM system and sales tracking system Ideal Candidate: - Proven experience with Zoho Inventory and CRM - Strong understanding of inventory management principles - Experience in customization and integration of Zoho systems - Excellent communication and problem-solving skills Your assistance will significantly help me...
As a director, I am in need of a highly...Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm eager to find t...
We are seeking an experienced [VA] to help us with our company tasks such as social media posts, research data entry etc... The ideal candidate should have a strong background in [LinkedIn Job posting - data entry - Google drive/sheets] The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role
I'm in need of a minimalistic yet smart jersey design for our Ultimate Frisbee tournament named "A Day on the Beach". The design should incorporate the colours from our tournament logo. The event is held in London (on volleyball pitches) so where possible, London can be incorporated in the design. Essential elements to be included are: our tournament name, our logo, and player numbers on the back of the jersey. Ideal candidate will have experience in sportswear design and a knack for capturing team spirit visually. Inspiration: The final file will need to be provided in multiple formats (.ai or .psd as well as .png).
...target audience. - Ads Campaigns: Your team will design and manage advertising campaigns across multiple platforms, organically appealing to our specific market. Furthermore, you'll engage in: - Social Media Ads: Focused on maximizing reach and engagement among our target audience. - Influencer Partnerships: Collaborating with influential personalities who resonate with our brand and can effectively market our products. - Email Marketing Campaigns: Crafting powerful emails to keep our customers engaged and selling our fitness products. Ideal skills and experiences for this job include expertise in social media management, proficiency in content creation (both written and visual), and a knack for launching effective advertising campaigns. A background in fitne...
...Bluetooth Low Energy (BLE) and Bluetooth Classic. - Have a simple, user-friendly interface. The freelancer for this job should ideally: - Have experience with Bluetooth technologies, specifically BLE and Classic. - Be comfortable working across iOS and Android platforms. - Have a portfolio of relevant apps they've worked on previously. - Be able to deliver a secure and user-friendly interface. I am looking to create an app for Android and iOS smartphones which uses Bluetooth or BLE technology, or similar technology, to transfer and receive small packets of data wirelessly between mobile phones, or cell phones, of the same and differing operating systems in a Mesh Network. There would be multiple users of the app within a 30 metre radius locality using an ad h...
...data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. - Proficient in building and implementing formulas and functions in Excel. - Strong background in data visualization. I'm looking for a professional who can commit to del...
