Excel macro find replace batch 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.
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.
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I am looking to hire an experienced researcher who can find and compile a list of DIY YouTube influencers within United States with 20,000 to 100,000 followers. Looking to gather a list of upto 1000 influencers. List should include a mix of home diyers, garden diyers, craft diyers etc - i can provide a list of categories. Your task: - Identify and list popular DIY influencers on YouTube within the follower range. - Collect their contact details including their email addresses and social media handles. - If available, find any agencies they are associated with. Ideal Candidate: - Proficient in online research - Understands the YouTube platform and its influencers - Has a keen eye for popular trends within the DIY community. - Respect for privacy and only using lawful metho...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm looking for a 14 developer who can help me with a quick job. I need to upload data to MongoDB and images to Firebase, then retrieve the image URLs to display them in a gallery. Key Requirem...gallery. Key Requirements: - Upload data to MongoDB - Upload images to Firebase - Retrieve image URLs - Display images in a gallery I don't require any extensive proposals or past work; just someone who can complete this task quickly. The project should ideally be completed within a day. I have 90% of the code already done but I do not have time to finish it. But i do need it to be easy to replace the dummy data when I want to deploy/publish. Ideal Skills: - Proficiency in 14 - Experience with MongoDB and Firebase - Basic understanding of data retrieval and display in a ga...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requ...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). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively...
Need someone to make a reactive webage which will replace an existing site with a single "holding page" whilst a new site is being worked on. Single page, a few links and some text.
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
I'm looking for an experienced graphic designer that can help me create a cool poster in the style of the classic game Streetfighter. Key Requirements: - Create a retro-style poster based on the game Streetfighter. - Replace the game characters with real pictures, but maintain the original retro design. - Completed in 4 days. Ideal Skills: - Graphic Design - Poster Design - Ability to replicate retro styles - Proficiency with design software.
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
We want to have all images on our website converted to webp. So please run a parser over all pages of Collect all png and jpg and jpeg images Convert them to webp Do NOT change their names, except for the extension
I am seeking residents of Munich, Germany to conduct an in-store check for a well-known Dairy brand. Project in a Nutshell: 20 SKUS (Products) need to be assessed for the following: Tidiness of shelves, package quality, time to find product and etc. 3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. Consumer will assess 31 samples per a product in total. No purchases required Products include water, plant based and diary. All data will be captured via an App thus good quality photos are needed. Answer questions related to the product via the APP. Full training provided. Requirements of the consumer: Tech Savvy. Promptly answers emails. Flexibility with time 4 weeks to complete Fee for project 1: €600. There is a secon...
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
Cher Freelancer, Je suis à la recherche d'une personne femme/homme s'exprimant parfaitement en français dans le but de pouvoir appeler des casinos français d'une liste excel avec les numéros de téléphone. Votre mission sera la suivante : - Appeler chaque casino - Obtenir les informations demandées dans le fichier excel - Mettre à jour le fichier - Rappeler les casinos qui n'ont pas pu vous répondre au 1er appel - Répéter l'opération mensuellement ou à convenir Les appels peuvent être effectués en semaine comme en week-end. Cependant, ceux-ci devront être fait le soir dès 20h30. Je recherche une personne avec collaboration sur le long...
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
We are searching for a highly skilled and experienced developer to assist us in building robust API integrations using CloudQuery. Our project involves extracting and integrating...write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with cloud platforms (AWS, GCP, Azure, etc.) is a plus. Strong problem-solving skills and attention to detail. Excellent communication and teamwork abilities. We are excited to find a passionate individual who can contribute to our project with their expertise in CloudQuery and API integrations. If you are a developer looking for a challenging and rewarding project, we would love to hear...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
...specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Ability to work independently and meet deadlines Duration and Budget: This mini-project is expected to require approximately 15 to 20 hours. The budget for the task is 200 EUR. How to Apply: Please submit examples of previously created financial models along with your applica...
I'm in need of 4 consumers based in Berlin, Hamburg, Karlsruhe, and Stuttgart to visit 8 stores per city. Your task will be to gather data specifically on the promotional displays and materials used for a well-known dairy brand. Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the product via the APP. -Full training provided. This data...
I am in need of 4 consumers based in Berlin, Hamburg, Karlshue and Stuttgart to visit 8 stores per city, for a well-known dairy brand. Your role will be to gather market data, particularly focusing on promotional displays and materials. - Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the product via the APP. -Full training provided. ...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
So for the competition, please photoshop one of the photos of Hannah Palmer which you can find here (you can choose any) and add a cat in the picture. The one who is selected will be asked to make a series of photos to include the same cat. Most important is that it looks realistic, also a bonus if it looks funny. Note that the offered budget is just for the 1 winning picture. You will be paid 50€ for 10 adjusted pictures.
I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
I'm in need of an experienced email marketing and web scraping professional to help me generate quality leads through email campaigns. - The primary goal of this project is to generate leads for my business. - The ideal candidate should have a track record of successful lead generation through email campaigns. - Additionally, I need someone who can scrape the web to find relevant email addresses of potential leads. You must have Good English and most importantly manage the whole process from start to finish outside of us reply to leads generated. This will mean you need to be able to scrape websites in Ireland like directories/maps etc and Linkedln. Generate marketing lists of each niche and setup emails to contact relevant niche. You must have or recommend bulk sending p...
Hello Creatives, Welcome to the "growber" sticker design contest! We are a dynamic and trend-conscious brand selling indoor hardware for cannabis cultivation, and we're looking for 3 vibrant and exciting sticker designs to represent our company. Here's what you need to know: 1. Brand: "growber" 2. Tagline: "to make your grow better" 3. Website: "" 4. ...we encourage designs with outlines for this task. Bring to life the playful, stylish and innovative personality of "growber" with bold, colorful and fun designs. We can't wait to see how you interpret our brand through your creative lens. Remember, this contest is all about creativity and having fun. Good luck, and we're eagerly looking forward to seeing your stu...
As the final step to my graduation, I am seeking a frontend developer who is expert in using the react.js, and CSS Tailwind frameworks. The project is hosted on GitHub which you can find more details on the link provided. The frontend should have the following key features: - User Authentication - Responsive Design - Interactive UI Components I need these features to be efficiently implemented using for server-side rendering and the Styling to be designed using CSS Tailwind. The overall interface should work interactively and reflect the educational theme of the project. Ideal Candidate Requirements: - A proven track record of developing frontend using react.js, , and Tailwind. - Previous experience that showcases your skills in building user authentication, intuitive