Vba lookup value in another sheetmunkák

Keresek valakit, aki tudna huawei OLT-t beállítani/kezelni (távolról). Az OLT-t az ONT-k tesztelésére szeretném használni. Először be kellene állítani konzolról, és meg kell oldani az ONT-k hozzáadását majd rövid teszt után az ONT-t cseréjét másikra. Ha ...cseréjét másikra. Ha rendelkezik a fenti tudással, akkor a fenti manuális teszt beállítása után tovább mehetünk egy komplex tesztkörnyezet elkészítésére. I am looking for someone who could configure/manage a huawei OLT (remotely). We would like to use OLT to test ONTs. First it need to con...

SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...

Sziasztok, lenne egy projektem ahova szükségem lenne egy steam authenticate-re és egy paypal integrációra. Egy weboldalra kéne felrakni egy steam logint és ha az adott felhasználó be van jelentkezve egy gombnyomásra tudjon beállított értékeket utalni paypalon, majd ha a tranzakc...tudjon beállított értékeket utalni paypalon, majd ha a tranzakció sikeres volt akkor egy adatbázisban az eddigi értékét növelje +annyival amennyit utalt ----- [ENG] Hi, I would have a project where I would need a steam authenticate and a paypal integration. You should put a steam login on a website and if the given user is logged in, you can tra...

Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.

...used by bars and restaurants, so they should be able to place tables of different sizes (2-20 people) and shapes (circles, rectangles) on a rectangular canvas. You can find directions for the editor in the attached images. (floorplan designer) For tables, users must be able to enter and store the following information in the editor. (name, ID, size, status (integer)) Each recorded table must also be erased individually. A save button is also needed on the interface, which will cause the browser console to display information about all the tables you've added. There is also a need for another interface where you can view recorded tables and store their data on the browser side without editing. (floorplan not editable view) The editor must be responsive and m...

Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti

fill spread sheet with given data

I'm very rookie in OpenGL programing, and skeletal animation under Android, therefore I would like to ask you to develop the following module for my project: I started with jPCT-AE and Bones API, but if you have another option, feel free to use it. I need an activity with a GLSurfaceView which the following features: 1.: Should import a fully rigged 3d object model from a Collada (.dae) file, which exported out from Blender (Human male body) 2.: It should be able to create keyframes from external files (the file format is not fixed, you can use your own one), and create an infite animation from it. 3.: Apply the animation to the previously imported 3d object and then play the animation in a GLSrufaceView.

username: megaharvestcrm password: 8NT@7zO~fP5C

1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...

I will provide names, address, phone, email, etc. etc on a pdf file. I need the information put in an excel spread sheet under company, contact, phone, mobile, fax, email, address, city, state, ID each set will be given a specific ID. some names an email will need to be entered There are approximately 500 or so names. maybe less maybe more one set will be on the internet to scrape the other are on pdf.

I'm in need of an experienced and creative architect to work on the floor plan for my new villa. Ideal Skills and Experience: - Ability to understand and translate the client's vision into a functional and aesthetically pleasing floor plan. - Strong communication skills and willingness to make revisions as necessary to meet the client's needs. Floor Plan for Home Villa I need Floor Plan design for 2.5 story Villa including elevations, sections, windows and doors schedules Lot area is 520 SQM with required 270-280 SQM foot print North is 26 LM East is 20 LM South is 26 LM West is 20 LM Set Back from north is Minimum 4 LM Set back from east is Minimum 3 LM Set back from west and south is 2 LM GF requirements Mens’ Setting area 5.5 x 7 M ex...

...incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL -> PHPMy...

...Indian Rupees of Rs.600 as another Rs.300 will be taken as commission. If you agree then proceed and apply to help. I am looking for a native female American English speaker to provide me with in-person lessons like a friend. This is a personal growth initiative, so I am interested in developing my overall comprehension in a relaxed, engaging environment. More specifically, I am keen on enhancing my conversation skills through real-time discussions, scenario-based conversations, and constructive feedback. Ideal candidates should have: - Teaching experience in English (American dialect) - Strong conversation skills - Ability to develop and adapt lesson plans to cater to my personal progress - Ability to hold in-person lessons regularly - Patie...

I'd like to replace a friend's face in a certain picture with another person's face, while keeping the final image as realistic as possible. Key task details: - Swap faces from two different photos - Ensure the final image is as true-to-life as possible - Maintain the overall harmony in terms of lighting and angles after the swap Prior experience in detailed photo editing and manipulation is required for this project as the change needs to be seamless for realistic aesthetics. I'm particularly keen on seeing past work where you've successfully handled similar tasks. Show me that you understand the finer nuances of making facial swaps appear utterly genuine!

...compute the next value in the sequence. Write recursive solution. • Test both programs for different input sizes and compare their performance. Task 2: Parallelize the algorithms for the second and third recursive equations obtained from the 1 practical selection test, and also parallelize second and third algorithms obtained from the 4 practical task selection test. Ensure that the programs correctly synchronizes the threads by comparing the final results of the sequential and parallel versions of the programs. • Analyze the sequential and parallel algorithms and determine their computational complexity using both Big O and Omega notations. • Measure and compare the execution time of the sequential and parallel versions of the programs and identify any ...

I'm in need of an expert in financial modelling to help evaluate numerous real estate investment opportunities. This project is focused on comprehensive analysis of potential investments and to help me make informed decisions. Key Areas: - Evaluating Investment Opportunities: I need someone who can create robust and reliable financial models to assess the viability of various real estate ventures. Your models should help me identify and prioritize the most promising investments. - Financial Metrics: Your models should primarily focus on Return on Investment (ROI), Net Present Value (NPV), and Capitalization Rate (Cap Rate). These are the key metrics I need to see to make sound investment decisions. Ideal Candidate: - Proven Experience: Previous experience ...

...web designer with a proven track record in creating engaging and effective landing pages. The main purpose of this landing page is to advertise a product/service to a wide audience, including both general consumers and business professionals. Key Requirements: - Engaging Design: The landing page needs to immediately capture the attention of visitors and effectively communicate the value proposition of our product/service. - CTA Optimization: Strong calls-to-action (CTAs) and well-thought-out user flow are essential to encourage conversions. - Mobile Responsiveness: The landing page should be fully responsive and optimized for mobile devices to ensure a seamless user experience across all platforms. - FIGMA - First Design in Figma then implementing in React +...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I am looking for a highly skilled Django developer who can help m...and interaction. - Messaging System: The site should have a robust messaging system that allows users to communicate with each other privately. Ideal Skills and Experience: - Proficiency in Django: I need someone who is well-versed in Django and can leverage its features to create a robust and scalable website. - Strong Front-end Skills: A good eye for design and the ability to create a user-friendly interface is key for this project. - Experience with Social Networking Sites: Prior experience in building social networking sites or similar platforms is highly desirable. - Strong Communication Skills: I value clear and concise communication, and I am looking for someone who can keep me updated ...

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I am looking for someone who knows how to do theme customisation on Shopify. I want that when a customer clicks on the Buy Now button of my Shopify store, that customer is taken to the checkout page of another Shopify store. My budget is ₹1000 for this task.

...a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one server to another. - Dedicated Server Management: Understanding of managing applications on dedicated servers. - Problem-Solving Skills: Ability to identify and resolve any specific requirements or dependencies. Please provide an overview of your relevant experience with ASP.NET migrations and manag...

I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designi...

Freelancer hiring for Seo Expert, Social media Expert My friend is looking for a freelancer who can do 1. seo activities on a daily basis, update the sheet. 2. Do work on social media with posting stories, highlight creation, daily activities on social media. #seo #remote #freelanceseo #seofreelancer #socialmedia #socialmediaexpert #freelancer #freelance #daily2/3

Hi Ahmed! I have another art creation I'm hoping you'll be interested in doing. Same as always it will need to be all black with a transparent background, high-resolution and 5 inches in height. Let me know if you need more information. - Fida Arnous

I am in need of a skilled developer to build me an Android app specifically for tourism and car booking services. Key Features Required: - The app must have a Payment Gateway feature incorporated into it for efficient and user-friendly transactions. Ideal Skills & Experience: - Proven experience in Android app development - Previous work with tourism and/or car booking apps is a plus - Knowledge about implementing Payment Gateway features for app transactions will be highly valued - Demonstrable capacity to deliver quality work on time. The final deliverable should be a fully-functioning Android app as per the described specifications. I value open communication and expect frequent progress updates. Looking forward to seeing your bids.

...with seller profiles to showcase items in live videos Items pop up at the bottom of the video with information, allowing viewers to add them to their collections or purchase directly Option for sellers to conduct auctions during live sales, with real-time bidding Collections and Trading: Tools for users to manage their personal collections Options to mark items as available for trade and create wishlists Automated matching system to connect users based on their trade preferences and wants Trade proposal and negotiation system Real-time chat feature allowing users to discuss trades and negotiate directly within the platform Image Recognition: Image recognition technology to identify items from photos Users can take a picture of an item to search for it in the database Dis...

Just create 2 api to pass value. WOrk with ftp only. Simple work

...tech enthusiasts. The main goal of this project is to raise funds for my new product. Key Requirements: - Create a convincing pitch: You'll be in charge of developing a strong, persuasive message that will resonate with tech enthusiasts and encourage them to support our product. - Video Production: A good portion of the campaign will be product demonstration. I'll need you to create engaging and informative videos showcasing the product's value and features. - Social Proof: It's important to include testimonials from early users. You'll need to collect and edit these into compelling content that highlights how my product is making a difference in people's lives. Ideal Skills and Experience: - Previous experience managing successful...

I need a diligent professional to create a 2D drawing of the floor plan of my house. The original plan is lost. The task includes: - Visiting my home in Waco Texas (zip code 76704) to take accurate measurements - Applying these measurements into a visually appealing floor plan. Previous experience in drafting is required, with added value if you have a background in architecture. A keen eye for detail and excellent drawing skills are crucial for this job. Quick turn around time is meeded.

In this project, I'm looking for a talented photographer or digital artist who can expertly alter a family photograph. The goal is to morph the appearance of 'Pa' in a particular photo where he wasn’t looking his best, and replace it with his image from another photo. The tasks include: - Maintaining the authenticity of the original photo - Changing 'Pa's face and body input from another photo while retaining the natural look - The great grandson on 'Pa’s lap must remain unaffected by this alteration It’s crucial that you have extensive experience in: - Digital morphing and - Photo retouching With these skills, you'll be able to achieve the desired result. Understanding and sensitivity to famil...

I am in need of an experienced video editor to help me replace a face in 4-6 scenes of my video with another face. The ideal candidate will have a good eye for detail and the ability to make the replacement look as natural as possible. Key Requirements: - Replace face in 4-6 scenes - Make sure the replacement looks natural - Deliver high-quality video editing work Skills & Experience: - Proven experience in advanced video editing - Familiarity with face replacement techniques - Ability to seamlessly integrate new face into scenes - Strong attention to detail Please provide examples of similar work you've done in the past. I'm looking to hire someone who can deliver high-quality work within a reasonable timeframe.

...Your expertise in this area is crucial. You should have a deep understanding of project management principles, particularly as they apply to construction projects. - **Price Comparison:** You'll be required to create a template that allows me to compare prices for different construction-related products and services. - **Task Scheduling:** This is a key feature that the template should have. It should make it easy for me to schedule different tasks and track their progress. - **Budget Tracking:** Another essential feature. The template should have the capability to track my budget as I enter costs for different services and products. Given the complexity of construction projects and the need for accurate cost comparison, the ideal candidate should have: - Previou...

I need a professional to consolidate and transfer formatti...with the correct content. Your task will involve: - Ensuring the booklet's formatting is consistent and professional. - The formatting and placement of illustrations and other visual elements are according to instructed guidelines. - Utilizing advanced formatting tools in Word to create headers, footers, page numbers, and styles. - Maintaining and enhancing the booklet's overall aesthetic and educational value. The ideal candidate for this job should have: - Proficiency in Microsoft Publisher 2019 and Word. - Experience in handling booklet materials. - A keen eye for detail and design. - Strong communication skills to ensure clarity on instructions and feedback. - Ability to work efficient...

...together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule **Objective:** Create a comprehe...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implem...

I have an existing E...with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a meticulous attention to detail, as the compatibility adjustments are crucial for smooth operation. If you're confident in your expertise with Excel macros and have experience with cross-platfo...

Hello there, I'm in need of some assistance with an old PDF file. I'm experiencing issues with stains and blurriness that compromise the quality of the file. The task I need to be done involves: - Removing the stains and enhancing the overall clarity of the PDF. - The correction work will involve handling a mix of both text and images. Ideal freelancers for the job will have ample experience in handling and editing PDF files. Proficiency in using advanced PDF editing tools will be highly beneficial for this task. I value attention to detail in ensuring that the document's quality remains high and no content is lost or altered during the correction process. Looking forward to seeing your proposals.

We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google She...

...Key Requirements: - The tone of voice should be persuasive and compelling. It should be able to convince potential clients to engage with my services. - You should have a background in copywriting specifically for legal services, or at least a strong understanding of the legal industry. - The specific legal services that I want to highlight on the landing page are Corporate Law and Commercial Real Estate. Your writing should be able to clearly and effectively convey the unique value propositions of these services. Ideal Skills and Experience: - Proven experience in copywriting for legal services, particularly in the area of Corporate Law and Commercial Real Estate. - Exceptional command of persuasive and compelling writing. - Understanding of conversion-orie...

I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - ...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibi...macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS ...

I'm in need of an individual who can transcribe intermediate level sheet music to MusicXML format. The work will involve a small ensemble, consisting of 2-5 instruments. Key Requirements: - Experience with transcribing intermediate level sheet music - Proficiency in MusicXML format - Familiarity with transcribing small ensembles - Strong music theory knowledge The ideal candidate will have a keen ear for music and the ability to accurately transcribe notes and dynamics from sheet music. You should be comfortable working with multiple instruments in an ensemble setting. Experience in music transcription and a solid understanding of music theory is essential for this project.

I am seeking an experienced music transcriber to provide me with sheet music in MusicXML for "Almost Blue" by Chet Baker - Live in Tokyo (see on YouTube). Exact transcription of the Piano part from original, including improvized solo, and exact base, is required. If this sounds like something you're capable of handling, please bid on a flat-fee complete project basis with turnaround time and relevant sample works.

I'm looking for a Google Ads expert to review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to offer ...

I'm looking to integrate Open AI capabilities with Google Sheets to create an AI assistant that can provide our customer real time inventory information when asked. Key Project Details: - The main task of the AI assistant will be to provide real-time inventory information from Google Sheet that contains our inventory data. Ideal Skills: - Solid experience with Google Sheets API - Proven track record of integrating AI tools with external data sources - Understanding of real-time data processing and automation - Familiarity with predictive inventory management would be a plus I'm looking for a freelancer who can bring both technical expertise and creative problem-solving skills to this project.

...on the number of available rooms, which in my case is 438 rooms. My current hotel staffing level is in its initial stages. The spreadsheet should effectively track staff allocation costs and other related expenses to assist in budgeting. The key tasks it will need to perform include: - Calculating the optimum number of staff - Staff allocation - Expense tracking The ideal freelancer will have experience in human resources, budgeting and have advanced Excel skills. They should understand how staffing impacts hotel operations and costs, with a keen understanding of allocation of resources. Their experience should also include creating Excel spreadsheets for companies in their early stages, to properly support growth and scalability. The Excel she...

...work experience, update my skills section, and revise my existing educational information. Having this rendered in both PDF and Word formats would be ideal. Below are the key aspects I'll need assistance with: - Integration of recent work experience: I have a new job role that I want to incorporate into my CV fluidly. - Refreshing my skills section: My skills repository has expanded, and I need these articulately highlighted in my CV. - Revising education details: There have been some changes to my academic details that need revising for accuracy. - Design and Layout: I value aesthetics and would love for my CV to visually stand out. - Content and wording: Fluency in English, excellent grammar, and writing expertise are essential to a...