Vba excel search value row column 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.
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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure
...aspects of my LinkedIn job search. This includes my profile visibility that currently requires some modifications to push it from moderate to high visibility. Moreover, I'm also facing some challenges with the job filters on the platform. Particularly, the filters are returning job listings that are not relevant to my professional interests and skillset, an issue that I'd like addressed effectively. Finally, I also require guidance on how to optimize my networking strategy on LinkedIn for better job opportunities. I am looking for a freelancer well-versed with the LinkedIn environment, its algorithms, and user behaviors, to perform this task. Your responsibilities would include: - Bolstering my LinkedIn profile visibility - Adjusting my job search...
I have a database that I need to extract specific textual information from, in a one-time extraction. The data needs to be structured in an Excel file. Key Requirements: - Extracting Textual Data: You'll need to retrieve text from the database. - Data Structuring: The extracted data should be organized and presented in an Excel format. Ideal Skills and Experience: - Database Scraping: Experience in extracting information from various types of databases. - Data Structuring: Proficiency in organizing and presenting data in Excel. - Attention to Detail: Ensuring that all relevant text is accurately extracted and included in the final Excel sheet.
...and experienced UI/UX designer to bring our vision to life with an engaging, intuitive, and visually appealing user interface. Scope of Work: The freelancer will be responsible for designing the entire user interface and user experience for the EduVerse platform. This includes, but is not limited to: Landing Page: A captivating and user-friendly landing page that effectively communicates the value proposition of EduVerse. Clear call-to-actions for signing up and exploring features. Authentication Pages: Login and Signup pages with fields for first name, last name, email, username, password, and confirm password. A clean and secure design that enhances user trust and ease of use. Onboarding Process: A seamless onboarding experience that guides new users (tutors, students and ...
I'm looking to develop a sophisticated and elegant brand name for my new fashion line of women fashion. The intention is to primarily target women who are high end, aware of fashion trends- in the age group of 25-40 The preference of brand names is to start with either of the following alphabets E,B, O, V The name should have high recall value and not difficult to pronounce Ideal Skills and Experience: - Proven experience in brand naming, especially within the fashion industry - Understanding of the nuances and requirements of a sophisticated and elegant branding - Familiarity with the professional adult target audience
The key focus of this project is to upgrade our current search functionality using Elastic Search. This will predominantly involve: - Handling abundant textual data. - Designing and implementing a sophisticated display for search results, favoring a detailed view with rich snippets. Ideal freelancers for this job should possess proven proficiency in Elastic Search and experience working with substantial textual data. We also prefer those with a solid background in creating detailed rich snippets for search results. Your role will be pivotal in enhancing our application's service and user experience.
In the zipped folder, it contains - sample of 2 months dummy data - ea...the zipped folder, it contains - sample of 2 months dummy data - each file contain IND and ENT sheets, some files may only contain either or - "consolidate" excel file is the sample outcome for reference The VBA should work as per below - an input to insert month (free text) e.g. 202301, 202302 etc - choose destination folder and files (in some of the months it contain unnecessary files) - IND sheet to consolidate only IND data from selected files - ENT sheet to consolidate only ENT data from selected files - 'Summary' sheet to provide number of rows overview for both Challenge - whether consolidation outcome can be done in 1 excel - whether it would work with a password en...
I'm looking to build a comprehensive search and listing portal focused on software and tools. The portal will be a one-stop platform for users, offering a spectrum of services and solutions. Key Features: - User Registration: A simple, intuitive user registration process is crucial for onboarding new users and keeping them engaged. - Advanced Search Filters: Providing users with robust search filters will enhance their experience and help them find what they need quickly. - Reviews and Ratings: Implementing a review and rating system will add credibility to the platform while aiding users in making informed decisions. - Product Comparison Feature: Enabling users to compare different software and tools will add value and help them make the best choice for ...
I'm looking for a skilled freelancer to create a custom Cashflow forecast template in Microsoft Excel. The template should be specifically designed to provide an intermediate level of detail - think monhtly breakdowns and categorized expenses. Key Responsibilities: - Develop a comprehensive, user-friendly cashflow forecast template in Excel - Ensure the template can handle a monthly breakdown of cashflow - Categorize expenses in a clear and structured manner - Make the output visually appealing and easy to read Ideal skills: - Proficiency in Microsoft Excel - Experience in creating cashflow forecasts - Ability to design and structure data in a logical and visually appealing manner - Attention to detail in categorizing expenses - Understanding of financial conce...
I need assistance in managing my customer data effectively. The ideal candidate needs to set up a system that allows me to keep track of my customer data and generate Excel reports based on this data. Requirements: - Set up a system for me to input and manage customer data - Ensure the system generates Excel reports with the necessary fields - Ensure the system is user-friendly and easy for me to use The ideal candidate will have experience in: - Database management - Excel report generation - User interface design for data management systems Please only apply if you have demonstrable experience in these areas.
My client's website currently uses a standard search field to allow users to enter a location or address. I want an autocomplete function added, so that when the user starts to type in an address, it will show suggested locations. PLEASE SEE MY BRIEF ATTACHED WITH SCREENSHOTS
You must to be at least 16 years old and live in Latin America or Eastern Europe. ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever; however, you must be clever and eager to learn. No. I am *not* being charitable; rather, I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me w...
I'm looking for a proficient content writer with a knack for crafting compelling event summaries for my squadron's record book. Job Requirements: - Writing short, captivating yet brief overviews of the squadron's events. We value intricacy but for this project, stick to providing a brief account. - Creativity in formatting is crucial. Instead of a single standardized format, each event summary should be individualized. The style and structure should flow with the unique nature of each event. Ideal Candidate: - Freelancers with strong writing skills and capability to explain events in a crisp and engaging manner. - Ability to create unique formats for different events, bringing out the distinctiveness of each event. - Familiarity with military terminologies...
...problems. Experienced in the creative design and delivery of social media campaigns Strong attention to detail and accuracy in managing event logistics, budgets, and administrative tasks. Exceptional written and verbal communication skills, including drafting professional emails and event materials. Excellent IT skills and ability to confidently use PowerPoint, Canva, Word and Excel to quickly pick up new programmes....
I'm in need of a skillful web designer to craft an engaging and f...transactions. 3. Product Review System: Customers should be able to leave, read, and respond to product reviews. 4. Ease to track stock count [Critical] 5. Ease to add and remove products [Critical] Special Requirement: 1. Excel Sheet Collation: The site should be programmed to automatically update Excel sheets with appropriate site data. The ideal candidate will be proficient in eCommerce website design, have a solid understanding of secure payment systems, experience in integrating product review systems, and a track record of creating dynamic data collation functions. Proficiency in Excel and related coding specifics will be a significant plus. Your portfolio and past experiences will signifi...
I need a freelancer preferebly someone with experience in Zoho books. I need to you to add some data from excel to zoho books. You can use the bulk upload feature or do a manual entry. Just need to make sure you are not doing thing in a hurry & adding wrong entries. Each transaction has to go to some expense segment/vendor, must have some experience of doing accounting work. The whole work might take 2 full days, please bid accordingly, you should be able to work between 11 & 8 PM IST & available on call & with remote desktop view.
We want the freelancer to understand our requirement and complete it on time
I am in need of a mobile application that arranges words in alphabetical order to make it easy for seniors to search for specific words. Key Features: - Alphabetical sorting: The app should be able to alphabetize a list of words. - User-Friendly Interface: It's essential that the app is intuitive and easy for seniors to navigate. - Search Functionality: Users should be able to enter a specific word into a search bar and find it easily within the organized list. Target Audience: - The primary target audience for this app are people aged 65 and above. As such, the design and functionality should cater to the needs of this demographic. Ideal Skills and Experience: - Experience in mobile app development, particularly for iOS (as the app is intended for Apple devic...
I’m currently in need of a top-notch professional who is skilled in data entry, particularly in Excel. Key responsibilities will include: - Data entry into Excel from Word - Regular upkeep of the database I require someone with the following skills and experience: - Proficient in using Excel and Word - Attention to detail - Data management skills - Dependable and reliable Experience with data entry in Excel is crucial for this project. It's important that you can efficiently transfer data from Word. If you meet these requirements, I’d love to hear from you.
As an established Amazon UK seller, I'm looking for an experienced professional to list my Home and Kitchen products on the platform. i am looking with someone with great knowledge of amazon seller central, list process and product creation using excel spreadsheets and xml imports we have a lot of data and a bank of 50k products we really need an individual with great knowledge of amazon any selro knowledge will be a bonus Key Responsibilities: - Accurate and detailed listings for a range of products within the home and kitchen category - Ensuring that all product details are correctly populated - Adherence to Amazon's guidelines and policies for product listings - Regularly updating and managing existing product listings Ideal Skills and Experience: - Proven experie...
I need a new Excel flowchart that's designed to include symbols like the ones in the attached Visio file. I just wa The ideal freelancer should be proficient in: - Excel: Demonstrated experience creating complex flowcharts in Excel is a must. - Technical Illustration: Capable of replicating and customizing symbols from a provided example. - Attention to Detail: Able to create a clear, legible flowchart that can be easily understood by others. Your application should include: - Examples of your past work, especially any Excel flowcharts or technical illustrations. - Relevant experience that demonstrates your capacity to complete this task. - A detailed project proposal outlining your approach to creating this flowchart.
This short video will demonstrate what I need I'm looking for a skilled programmer who can create a script that will automatically insert a timestamp into my Google Sheets document each time new data is entered. Key Requirements: - The time stamp should consist of both the current date and time. - The script should insert the time stamp in the column immediately to the right of the cell where new data is entered. - The format of the time stamp should be fully customizable. Ideal skills for this role: - Proficiency in Google Apps Script - Strong understanding of Google Sheets - Experience in developing scripts for automated processes - Ability to create customizable timestamp formats - Excellent problem-solving skills and attention to detail Please
I'm looking for a Google Search Ads specialist who can help me generate more leads on a national scale. Key Project Details: - **Objective**: The main goal of this campaign is to increase the number of leads, not just website traffic or product sales. - **Audience**: The target audience for these ads is a National, US-based audience. It's critical for the freelancer to understand the dynamics of reaching out to a diverse audience. - **Budget**: As a small business, I'm working with a monthly budget of $500-$1000. The ideal candidate should be able to optimize the campaign to achieve the best possible results within this range. Key Skills and Experience Required: - **Google Ads Expertise**: Proficiency in Google Ads, particularly in lead generation campaigns, is a m...
I'm looking for someone to create a Dynamo script for me to add a parameter that determines the relative position of the window to North. It just need to be north, south, east and west. The script will do the following: Add a property to the glazing or curtain wall structure (if it...an external wall. So it may be best to create a script that first assigns a property external wall = true, then use this for a second dynamo script to get the orientation of windows in the external walls based on the property set. Ideally it would then create a schedule with all the external windows with the following properties: Window Id, length, height, U-value, SHGC. Finally, I'm new to dynamo, so part of the contract value will be some time to take me through it and show my ho...
I'm looking for someone who can proficiently print names and addresses on standard white envelopes. - Envelope Details: All envelopes are standard white and require nothing but names and addresses. No logos or other branding elements need to be worried about. - Printing Requirements: All names and addresses should be clearly printed. While I value efficiency, the quality of work should not be compromised for speed. Ideal skills for this job would include accuracy, meticulousness, and a solid grasp of both formatting and the English language's written form. Previous experience in relevant fields will be considered a definite plus, but isn't strictly necessary.
Buenas,necesito la creación y diseño de una hoja de Excel para recogida de datos para crear una base de Datos estadística de un proceso asistencial sanitario
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...fetch the current Kitco market values and cache them as needed, possibly using a crontab. The output price is always for Fine Gold, 999. The customer should be able to select karat numbers such as 8K (333), 9K (375), 14K (585), 18K (750), 21.5K, 22K, etc., to display the current market price according to the karat numbers. It should display as follows: Estimated Value: [current market value] Maximum Pawn Amount: 50% of the market value It's important that no other API is used, but rather prices are fetched from kitco.com. Additionally, at the beginning, customers should be able to select Gold, Silver, or Platinum. These prices must effectively be queried from Kitco, with the output being less than 50%, just like with Gold. Furthermore, a visually appealing ...
I have a product form on my PrestaShop 1.7 website that's experiencing an issue. It has over 100 declinations, and when trying to submit the form, I receive an error message stating, "The value of the setting "max_input_vars" must be increased to 5000 in order to be able to submit the product form." Key aspects of the project include: - Identify the root cause of the error message regarding the "max_input_vars" setting. - Fix the bug in the product form that's preventing me from submitting it. Ideal skills and experience for this project are: - Proficient in PrestaShop, specifically version 1.7. - Expertise in PHP and understanding of PHP settings. - Experience in debugging and fixing product forms with numerous declinations in PrestaShop....
...Chrome On Firefox and on Safari no issues The booking widget from is not loading which might be rather a stylesheet issue than .htacess on Google Chrome and the stylesheet for the header links does not work On Firefox and Safari the widget is loading, just load the site on different browsers and you will see For the .htaccess file, I need: All links on the left column are resolving to .hmtl but it should resolve to .php One example: Now the links (pages ) are not loaded but if you change the links in the browser line to .php the pages are loaded. NOT WORKING WORKIND To me it is a .htacces issue. The ideal candidate should have: - Proven
I want to design a vba code where i can send text or whats app message
I'm seeking an individual proficient in copying and pasting data from various sources into an Excel spreadsheet. While the complexity of the data isn't explicitly defined, a basic understanding and familiarity with Excel are a necessity, so you can format and organize the data accordingly. Key Responsibilities: - Transferring data from different sources to Excel - Basic manipulation and organization of data in Excel Ideal Skills and Experience: - Proficiency in Excel - Previous experience in data entry - Excellent attention to detail
I'm looking for a professional data entry specialist to assist with the input of textual data in an Excel format. The key requirements of this task are as follows: - Experience in carrying out text data entry tasks. - Ability to methodically input less than 1,000 entries. - Knowledge and proficiency in using Excel for data input. - High attention to detail and accuracy for data input. Please ensure that your bid includes an estimation of time required to complete less than 1,000 text data entries in Excel.
Hello Everyone! I need to improve the design of my page created with Elementor. Currently need it it for desktop version. Please note: I am not looking to rebuild, redesign, install new themes, or anything similar. Please refrain from sending messag...changes should make the page look nicer and more professional without drastic alterations. I need someone with a good sense of style who can refine my page to look more professional. Please respond if you have experience in stylishly enhancing Elementor pages. Example of my page (please open on desktop version) 1 column version 2 columns layout version I can stay with any layout (1 column or two) if you will be able to make it nice. Thank you!
I'm seeking an experienced Microsoft Excel professional to assist with visual data representation in my Excel sheets. - My primary need is for the successful candidate to help me create clear and comprehensive visual representations of my data using Excel's charting and graphing capabilities. - The ideal candidate should have a solid understanding of various data visualization techniques and be able to recommend the most appropriate type of visualization based on the nature of the data. - Experience with Excel's chart customization features is a plus.
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
Seeking skilled debt consolidation professional to address my business's current financial challenges. Currently, we are grappling with over $100,000 in business loan and credit card debt. Our primary approach has been to cut expenses, which helped to a certain degree, but hasn't fully addressed the problem. We are open to other strategies, including debt consolidation, to find a practical solution. Ideal freelancer should have: 1. Proven background in Financial Planning or Debt Management 2. Experience dealing with business loans and credit card debt 3. Strong problem solving, strategic, and planning skills 4. Previously demonstrated success in helping similar businesses minimize and manage their debts.