Excel vba search function työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

typing job; data entry; research

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.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

oi need pr,ohvhvhbbgv gviyhvyvhivhiou

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

...adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the addition of a new category search criterion using the Smyles Plugin on the back-end. - Ensuring a smooth integration: You must make sure that all changes and additions are fully integrated with the existing system without causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries o...

...the input text file contains. 4. You can make it a price depending of what it can do and list possibilities. 5. If there is an app that allows a TXT definition like what I am saying, then I would consider buying that, but I tried that and this gig is really for having it developed. Search for FLOWCHART and click on IMAGES and you'll see hundreds of examples. Include: 1. Source Code 2. Compiled Code 3. User documentation. 4. Technical (programmer) documentation: Technologies used, overall flow, for each function/subroutine what the input and output are. Should be 1-2 pages (the more the better.) 5. I get a week to test it. At first you can run it. When it's working I'll test it myself. If I find bugs they are fixed and I get another week. But before we...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

...Arduino Leonardo or ESP32. The goal is to simulate pressing the Z1 keys solely through software, without external devices. Activation should be tied to the Caps Lock LED status—active when on, and inactive when off. Solutions utilizing 'keybd_event' and 'SendInput' do not meet the requirements of this project; a deeper, more intrinsic approach is necessary. Conditions: The keyboard emulator must function correctly within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least one of the following programming languages: C++, Python, or Pascal. Payment will be made upon successful demonstration of the emulator working within the game. Note: This project does not involve breaking any game's security measu...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm seeking a skilled PCB circuit designer to create a digital circuit f. The primary function of the circuit is PWM Motor Speed Control Key requirements: Input supply voltage: DC 2.5V-25V The maximum output power: 350W The maximum continuous output current :15A The overload and short circuit protecting current is 25A PWM frequency: 25-30kHz Duty Cycle adjustable: 0-100% The operation environment temperature:-20℃-40℃ Ideal freelancer would have: - Proven experience in digital PCB circuit design - Strong knowledge of signal amplification principles - Familiarity with radio technology and its requirements - Ability to optimize circuits for low gain

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm seeking a mobile app developer with experience in developing TV applications. The project involves the creation of a TV app that would support live TV streaming specifically. Here are the project specifics: - **Primary Feature**: The main function of the app is to support live TV streaming. This is the core feature that will require meticulous implementation. - **Content Categories**: The live streaming feature will specifically focus on TV content. This includes channels that cater to TV shows, documentaries, or other related TV broadcasts. - **Device Compatibility**: The app should be compatible with Samsung and LG smart TVs. The ability to ensure the app runs smoothly across different models of these brands is crucial. Ideal candidates should have: - Proven experien...

I am looking for an experienced CNC programmer to help me program M codes on my Syntec 60W-e CNC controller. I have 3 unused out relays that I want to use, and I would like each of them to be assigned to specific M codes. Here’s what I need: - Assign M code e.g. M30, M50 and M80 to the unused output relays. - The function they should perform is to turn an external device on/off. Skills and Experience: - Previous experience with CNC programming is crucial. - Familiarity with Syntec 60W-e CNC controller will be highly advantageous. - Proficiency in M code programming required.

I have a iOS application with a few bugs that needs fixing and adding the function of inviting phone contacts to our app. iOS application built in: - Objective C - Native App and UIKit I will share the specification document when we speak in freelancer chat.

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

I need an experienced VB.net programmer to make modifications to existing source code. The project itself should include feature demonstration forms. Key Responsibilities: - Modify existing source code: The main task will involve working with the existing codebase, making necessary adjustments, and ensuring the software continues to function as expected. - Demonstration forms: The project includes creating feature demonstration forms for the software. Ideal Skills and Experience: - Proficient in VB.net: The candidate should have a strong background in VB.net, with practical experience in modifying and building upon existing code for file IO, object generation and file parsing for data output. - User Interface Development: While the project involves existing source code, a good u...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...

I need a catalog to be designed keeping a classic and elegant aesthetic in focus. This catalog should function as a product showcase for my clothing and apparel line. Key Requirements: - Outstanding design skills, preferably in the fashion industry - Able to deliver a classic yet engaging aesthetic - Experience in catalog layout design. The goal is to create a captivating and beautiful product story that will inspire and engage potential customers. If you have a background in clothing and apparel design, it will be beneficial. Please share examples of similar work while bidding. We are exporting to Europe and other Asian countries.

I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the fr...have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to understand that the scope of the project is conversion and compatibility, rather than development or adjustment of any specific function. Therefore, a strong understanding of technical requirements between Windows 8.1 and Wi...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...

I'm looking for a talented illustrator to create visuals for my innovative smart headphones. They feature an over-ear design with sound isolation technology, noise cancellation, speech processing, and a unique eye-tracking function. Desired Illustrations: Photorealistic Image: I envision a modern, sleek design with visible sound isolation details. Include four microphones for capturing sound and show the headphones being held or worn to emphasize portability. Eye Tracking Camera Focus: A close-up image showcasing two discreet cameras positioned near the headband, facing inwards towards the eyes. Label them as "Eye Tracking Cameras." Technical Breakdown (Optional): An illustration depicting the internal components, including a central processing chip connected to sec...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT o...

I'm looking for an experienced application developer who is also skilled in UI/UX design to create a futuristic, visually appealing, and user-friendly design for an app I'm developing. Key aspects: - Platforms: The app will be available on both iOS and Android, so you should have experience with both platforms. - Purpose: The app's core function revolves around boosting users' productivity. Hence, it's essential that the UI/UX design enables a smooth and efficient user experience. - Design Style: I have a preference for a futuristic design; think sleek, innovative, and cutting-edge. The ideal candidate should have: - Proven experience in developing and designing productivity apps. - Strong portfolio demonstrating a futuristic design style. - Proficiency ...

I'm looking for an experienced developer to work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communica...

I'm in need of a freelance writer to craft an engaging, informative article on boardrooms. The key aim is to provide general information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must be educational yet engaging, appealing to a wide audience. - The focus should be on clarity and simplicity, making complex concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom functions. - Ab...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I need a C function capable of interfacing with the Windows location services and Linux's geoclue2 to acquire the current location (longitude and latitude) on both platforms. - The function should aim to provide location data with the highest possible accuracy, utilizing GPS, Wi-Fi positioning services, and GEO IP location services. - In cases where the location data retrieval fails, the function should be designed to return an error code. The ideal candidate for this job should possess: - Proficiency in C language. - Familiarity with Windows location services and Linux's geoclue2. - Experience in working with GPS, Wi-Fi positioning, and GEO IP location services. - Capability to handle error cases efficiently with return error codes. - Previous experience i...

...Adjustable power factor (cos(φ)), current, and power. Machine-side control: Adjustable field (Φ), torque, and speed. Overload Protection: Develop a feature to switch the device to idle mode during overload conditions. Measurement and Output: Provide optional output of all internal measurements, especially torque, speed, and power. User Interface: Implement a 4x20 LCD text display for function calls. Enable function calls through the RS232 interface using JSON format. Protect the interface with CRC for error-checking. Ensure PC commands are readable and outputs are optional and adjustable through a menu system using a rotary encoder. Quadrant Display: Implement a 4-LED display to indicate the quadrant of operation (motor or generator mode). Additional Features...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

I am seeking an experienced programmer, whose task will be to integrate the Trilliant Provider Directory API into another system. Must have experience with Trilliant and Dat...into another system. Must have experience with Trilliant and Databricks. It's noteworthy that I am open to working with a freelancer proficient in any programming language. Ideal qualifications are: - A solid general programming background - Experience with API integration - Capable of interpreting and applying API documentation The API must deliver the following functionalities: - Ability to search providers - Retrieve provider details - Seamless integration with another system Freelancers who demonstrate evidence of past experience particularly in Trilliant / Databricks API integration will be hig...

I'm at the idea/concept stage of a new automated device and I'm seeking an experienced freelancer with strong prototyping skills to bring this concept to life. Key Requirements: - Experience: I need someone who's well-ver...should be proficient in using tools and materials to build and test prototypes efficiently. - Problem-Solving: A significant part of this project will involve troubleshooting and refining the prototype as we progress. Your problem-solving skills should be top-notch. - Innovation: I'm seeking an innovator who can offer suggestions for improvements and optimizations to the design. The primary function of the automated device will be assembly. If you think you possess the required experience and skills, please don't hesitate to reach out....

I'm looking for a skilled writer to create a detailed, engaging article on the topic of payment terminals for my fintech website. Key Points to Cover: - Discuss the various types of payment terminals available in the market. - Explain in detail how payment terminals function in the financial ecosystem. - Highlight the benefits and advantages of using payment terminals for businesses and consumers alike. You should have: - Prior experience in writing about financial technology, with a focus on payment systems. - A solid understanding of the fintech industry and its complexities. - A knack for transforming technical information into easily digestible, engaging content. - The ability to research and present information in a clear, concise manner. This is a one-off article, bu...

I'm seeking an expert in 3D printing, specifically using plastic materials, to assist with t...Solid experience in 3D modeling and printing - A deep understanding of working with plastic materials for 3D printing - Strong design abilities to deliver unique, functional appliances Your task will primarily involve transforming simple concepts into tangible, usable items. From initial design to final product, your role is pivotal to creating one-of-a-kind home appliances that combine form and function in new and exciting ways. This project is perfect for those who enjoy rethinking design norms and creating unheard-of items that will surely stand out. Samples of similar work are requested for review. Your creativity and technical skills in 3D printing will be essential to this pro...

I'm changing the requirements if that will help. My Quasar Application now has a Node.js server running ins...Claude_question ); = ; } catch (error) { this.Claude_answer(error); ("Error sending message:", error); } }, And make the call without getting a cors message. It needs to be a Quasar app and not a node.js app. Make a page that has an Question and an answer input. Add a button that calls the function I provided. If you have better code you can use that. Hopefully you have done this before and have an API account at Anthropic. I don't want your API key and I will add $5.00 for you to get one. I'm just looking for code to a good connection.