Cell address based vlookup result macro exceldela

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..

Hello, I'm trying to obtain 2 products from , but since I live in Germany, and the sellers don't want to ship abroad, it's not possible for me to get them by myself. Therefore, I am looking for someone from Slovenia to buy them for me and ship them to my address via mail. It's about these 2:

need help with spreadsheet formula

I'm seeking an experienced web developer with extensive knowledge in WIX and payment gateway integration to build the checkout system of our bulk ice selling business' website. Key tasks include: 1. **Payment Gateway Integration**- The checkout system should incorporate a payment gateway to facilitate secure transactions. 2. **Delivery Address Input** - Allowing customers to input their delivery address to ensure proper and accurate delivery of our products. 3. **Order Confirmation Email** - After a successful purchase, an order confirmation email should be sent to customers for their records. 4. **Design** - Implement a simple and clean design that aligns with the website's current aesthetic. 5. **Delivery Tracking** - Incorporate real-time tracking of ...

REUQUIRED PERSON TO BE BASED IN PHILIPPINES ONLY! Are you passionate about social media marketing and graphic design? Do you have experience in creating engaging content for e-commerce businesses? If so, we have the perfect opportunity for you!Our clothing e-commerce startup is looking for a dynamic and enthusiastic Assistant to join our team. As we continue to grow, we need someone who can help us elevate our online presence and drive sales through creative digital marketing strategies.**The ideal candidate will:**- Have a strong understanding of social media marketing platforms such as Facebook, Instagram, and TikTok- Be proficient in creating and managing paid advertising campaigns- Possess advanced skills in Photoshop and Illustrator for editing and creating visually appealing ...

I need a data expert to collect and analyze NFT transactions on a daily basis. Key Responsibilities: - Collect NFT transaction...expert to collect and analyze NFT transactions on a daily basis. Key Responsibilities: - Collect NFT transaction data daily - Analyze the data for market research - Track ownership movements - Provide analytics on the data collected The ideal candidate should: - Have experience in data collection and analysis - Understand NFT transactions and their data points (Transaction ID, Buyer's address, Seller's address, Collection Name, Specific Item) - Be able to provide daily updates on the data collected - Have a background in market research is a plus This is a long-term project, and I require someone who is dedicated and can provide accura...

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

I need an age verification popup for my website that is displayed upon entry to any page. Key requirements: - Ability to change validation type (e.g. Over/Under 18; Date-of-birth, Year-of-birth) - see images - Ability to change images, text, background and redirection address (for Under 18) - To remember age verification forever (for Over 18s) and this session for Under 18s I already have a mock up design and imagery files available. The website is hosted by Neto e-Commerce and I have full access to all files.

...will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for… Jake The Plumber Minneapolis, MN … I see a link to Jake The Plumber’s website. Your script(s) will not submit the forms; rather, I will review each form and then manually submit each myself. In other words, I will click on, fo...

...chat client for me. The client will primarily be text-based, allowing group communication between multiple users. Key Features: - Group Chats: The primary function of this chat client is to facilitate group chats. Therefore, it should support multiple users in a single conversation thread. - User Mentions: I'm also looking for the implementation of user mentions, which will enable users to tag others in a message, signaling their attention. Additional Features: - File Sharing: The ability to share files within the chat would be a very useful feature. - Chat Moderation Tools: I'd like the chat to have basic moderation tools to oversee the group chats and manage user interactions. Ideal Skills and Experience: - Proficiency in text-based chat client development...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

...in researching, identifying, developing and responding to Ontario/Canadian grant opportunities in areas that support IT, Digital Marketing & SEO programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organization. * Research grant opportunities from Ontario/Canadian government agencies. * Draft grant proposals and supporting documents based on the funding requirements of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on drafted and submitted proposals. * Maintain positive relationships with fund providers and other stakeholders. * Maintain records and submit reports related to grant opportunities. * Researches and identifies new Canadian Governmen...

Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. - Trac...

I'm on the lookout for a skilled Flutter developer to create a cross-platform (iOS and Android) restaurant application with intuitive and user-friendly interfaces. This app serves as a comprehensive solution for consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming la...

Java based app backend for tourism activities need 2 things. 1 - add a copy activity in activity page to copie a existing activity content to a new one 2 - migrate backend from vps centosOS to cpanel based hosting.

I need a 5-page website for my tile company based in Texas. It should be simple and easy-to-use for potential customers. Key Requirements: - Home Page: A welcoming, visually appealing landing page that effectively showcases the business. I have created the welcome page content with A.I. so you would simply need to plug in that content. - Products Page: Not needed for now. - Services Page: This page should include detailed descriptions of the services we offer along with the respective pricing. - Contact Us Page: A standard contact page with a contact form, email address, phone number, and a location map. - Must be familiar with !! The site should be built using WordPress, allowing me to update content myself in the future. The design should be clean, professional, and ali...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visua...

I'm seeking a skilled developer to build a trading bot for the Solana web3 infrastructure. This project involves: - Smart contract deployment - Token and wallet integration - Algorithmic trading bot development Your expertise should include proficiency in creating trading bots, with a deep understanding and prior experience in implementing auto-buy and sell features. Knowledge of trend following, mean reversion and breakout trading strategies is crucial for this role. Additionally, I expect familiarity with the Solana ecosystem to ensure seamless integration. Your input will be vital in positioning the bot precisely within the market dynamics.

Storecheckers are a Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits. This visit is to an Examination Centre, checking that the security standards are being met, in order to ensure that there is no possibility of cheating at any stage. The exam content and result are irrelevant to this exercise. You will need to be observant and discreet in order to undertake this visit. You need to remain in the test centre and complete the exam as if you were a genuine entrant. We have full guidance notes to assist you, which give a very clear background of the environment. The actions that you need to take are actions that test takers attempt, so do not be worried about carrying them out. After the visit there is a report to complete, it is not length...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I'm looking for a skilled software developer who can create a custom, user-friendly test taking software for my extensive question bank. Key Features: - The software should s... - The results should be displayed in a detailed breakdown by question. Ideal Skills and Experience: - Proficient in software development, specifically in creating educational software. - Experience with creating user-friendly interfaces and interactive features. - Strong understanding of database management to handle a large question bank. - Familiarity with constructing detailed result summaries based on user performance. Please provide examples of similar projects you've completed. I'm open to suggestions on how to make the software more efficient and effective for our users, s...

...WordPress/WooCommerce site for accurate tracking and analytics. • Perform thorough testing of all site functionalities, including Google Merchant Feed file integration, to ensure smooth operation and minimal downtime. 5. Content Migration and Optimization: • Ensure that no content, internal links, or references are pointing to the staging domain, and update all references to the live domain. • Address minor fixes and enhancements on blog pages, including layout adjustments and formatting issues, to maintain a consistent and user-friendly experience. Qualifications: • Proven experience with WooCommerce development, customization, and optimization, including theme development and plugin integration. • Expertise in advanced SEO techniques and tools, with pro...

...need of a skilled developer to build an exam portal web application. Key Features: - User Registration and Login: Implement a secure system to allow students to register, log in and access the platform. - Exam Creation and Management: Develop tools for examiners to create and manage exams. This should include the ability to set time limits, number of questions, and other relevant parameters. - Result Generation: Implement a function that will accurately calculate and display exam results to students. Additional Information: - The portal will only be supporting specific types of exams. - The ideal candidate should have experience with similar projects and be able to provide a secure, user-friendly and efficient solution. - The project requires an understanding of good UX/UI des...

I'm seeking a skilled graphic designer to create an icon-based logo for my company. The desired logo should meet the following criteria: - Style: The overall aesthetic should be casual, veering away from the rigid structure of formal styles. I'm interested in a more relaxed, amusing approach that embodies a cheerful spirit. - Color Scheme: Adorn the logo with bright and vibrant colors. These colors should bring the logo to life, making it more appealing and eye-catching to the audience. - Type: The logo should largely be icon-based, focusing more on imagery than text. Ideal Skills: - Graphic Design skills are necessary, notably in creating logos. - Familiarity with designing icon-based logos. - An ability to balance color, design aesthetics, and imagery eff...

...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...

...optimization within the design team. 4. Quality Assurance: - Conduct thorough quality assurance reviews of design deliverables to ensure adherence to design specifications, usability standards, and best practices. - Solicit feedback from stakeholders and end-users, incorporate feedback into design iterations, and advocate for user-centered design principles. - Collaborate with development teams to address design implementation issues and ensure the fidelity of the final product. - Perform usability testing and gather user feedback to validate design decisions and identify areas for improvement. 5. Collaboration and Communication: - Foster a collaborative and inclusive work environment, promoting open communication, constructive feedback, and knowledge sharing within the d...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should h...

I am in immediate need of a skilled AWS developer to address various issues in my application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vuln...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

More details: What format are the company names provided in? pdf Do you have the capability to extract text from the PDF files? Not sure How soon do you need your project completed? ASAP

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

I'm needing help with a GSAP animation project where a single element is not rotating as intended. Key Points: - Issue Description: The current animation is not rotating the designated element. It's likely a bug or misalignment in the code...animation bugs in similar projects. Your responsibilities will include: - Reviewing the existing code and identifying the root cause of the rotation issue. - Implementing the necessary fixes to ensure the element rotates smoothly and correctly. - Conducting thorough testing to guarantee the animation works as expected across different devices and browsers. Looking for a professional who can swiftly address this problem and deliver a polished, fully functioning GSAP animation. Please include relevant examples of your previous GSAP wo...

Sure, here's a revised version: Experienced WordPress Designer and Developer Needed I am seeking an experienced WordPress designer and developer to create three websites based on the theme provided The theme will be purchased prior to the project start. Website 1: This website is for a web agency. It will closely follow the theme's layout, with customized images and content provided by me. Website 2: A hotel broker website. New icons will be required for this site, designed by you. Images will be provided by me, possibly requiring some Photoshop work. New content will also be inserted, provided by me. Website 3: A corporate

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

Budget is is in project. Don't place a placeholder amount / bid. I am here to select and not to increase budget. This project is for next 5 hours max. If you can not work now no need to bid. My developer will be available then but I am impatient and ready to hep him NOW. I am looking for a professional who can help me with troubleshooting and possibly resolving issues in my web-based API around E*Trade. We will connect/ login/ get token to use whatever needed. The task is relatively brief and should not take more than a few hours for an experienced developer. Please provide details of your relevant experience to help me make an informed decision.

...experienced freelancer to develop an All-in-One AI-based HR Solution Platform entirely from scratch. This platform will serve as a comprehensive tool to streamline various HR processes and enhance efficiency across our clients' organizations. Requirements: The freelancer is required to develop a single platform capable of providing web and aap based services for product owner and client user interface, with the following functionalities: 1. Recruitment and Applicant Tracking: Streamline the recruitment process, from job posting to candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employees, ensuring a seamless transition. 3. LLM-Based...

Address about 1050 emails per month. These are time sensitive emails send to people who are going to lose their homes due to foreclosure. You would get the list on a Friday morning. And need to have them to me by Monday. I would gladly pay you extra for fast service. . This would a monthly long term gig. Paula Thanks, Paula

I'm in need of a designer to create a bilingual, two-sided business card for me. I already have a logo, now I need it to be incorporated into a print-ready design alongside my contact details. Project Requirements: - Utilize my provided logo - Incorporate my name, phone number, and email address - The card should reflect the company colors present in the logo - I prefer a standard horizontal layout Ideal Skills and Experience: - Proven experience in graphic design, specifically business cards - Proficiency in design software (Adobe Illustrator, Photoshop, InDesign) - Fluent in two languages aligning with the bilingual card requirement - Ability to follow design instructions diligently - Attention to detail

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

...security. The primary responsibility of this role is to rigorously test the system's security to identify vulnerabilities and suggest enhancements. Key Requirements: - Expertise in network, application, and data security: You should be well-versed in these aspects of security to ensure the entire system is robust. - Ability to identify and address firewall misconfigurations: This is of particular concern, given the specific issues I'm looking to address in the network security. Your role is to simulate various hacking attempts and identify any potential weaknesses in the system's security. This includes: - Conducting penetration tests to find vulnerabilities in the network, applications, and data security. - Specifically, identifying and correcting any fir...

I'm experiencing an issue in my Android application where it crashes on startup when opening specific features. The bug seems to trigger and cause the application to malfunction. I am therefore in need of a skillful developer with solid experience in Android app development and debugging to help address this glitch. Essential Skills: - Proficient in Android App Development - Advanced troubleshooting and debugging skills - Familiarity with Login features mechanisms Responsibilities: - Identify the root cause of the crash - Implement a solution to stop the app from crashing on startup - Ensure proper functioning of the login feature. I look forward to a quick resolution of this critical hindrance in my app.

I need a professional t...watchdog error since the it said "RunTimeError" but the watchdog timer only activates after 15 seconds and the terminal returns this error in less than 5 seconds. On Luxinos's documentation I noticed that if the camera is unable to connect to the DHCP server it has a fall-back IP Address, 169.254.1.222. Using my computer, I was able to run a script that gives me the IP address of the camera and I noticed the two matched. It also mentions "In many cases, your host machine will automatically be assigned an IP address in the correct range", which I'm assuming my computer does but my Raspberry Pi 5 does not. To solve this issue, it says that you need to change the static IP of your host machine to 169.254.1.10. Even a...

I need a professional t...watchdog error since the it said "RunTimeError" but the watchdog timer only activates after 15 seconds and the terminal returns this error in less than 5 seconds. On Luxinos's documentation I noticed that if the camera is unable to connect to the DHCP server it has a fall-back IP Address, 169.254.1.222. Using my computer, I was able to run a script that gives me the IP address of the camera and I noticed the two matched. It also mentions "In many cases, your host machine will automatically be assigned an IP address in the correct range", which I'm assuming my computer does but my Raspberry Pi 5 does not. To solve this issue, it says that you need to change the static IP of your host machine to 169.254.1.10. Even a...

Seeking a skilled and experienced developer to execute an AI-based Android app meant to perform tasks such as image classification and face recognition. An integral requirement for this role is proficiency in the integration of JNI C++ libraries. The foundations of the project include: - Development of an app compatible with Android phones - Integration and enhancement of machine learning algorithms into the app - The app must process object detection & tracking tasks using machine learning The ideal candidate should have: - Prior experience in Android app development - Strong knowledge of machine learning - Proficiency in the integration of JNI C++ libraries Integral to success in this project is a developer's ability to balance technical machine-learning objectives ...

I need a proficient Matlab Simulink professional to simulate the current production in a semi-truck's solid oxide fuel cell. This should take into account multiple variables, specifically: - Temperature - Pressure - Fuel flow rate These should be varied at high levels in the simulation. With a requirement for medium precision, the model should sufficiently represent the real-world scenario without too much granularity. The goal is to understand how these variables affect the current production. The ideal candidate should have a strong background in thermodynamics, system simulations, and Matlab Simulink. Experience in solid oxide fuel cells and vehicular simulations would be a significant advantage.