Excel macro vlookup large csvpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
I need to scrape data from real estate website. Specifically data under these two filters: Together some 9300 real estates in two separate datasets. Only the text data is needed (no pictures, no maps), preferably in xls or csv.
Převod v minulosti zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes...zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes nějakej...
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
...extensive experience in copywriting, where it is possible to document previous assignments and work. The required respondent should be able to 100% complete the set dates and form of assignment. We require 1x preliminary revision of the work and 3x total revision of the completed work. About us: We are an advertising agency together with a video and graphic studio, which focuses on medium and large companies. Form of audit and brochure: Technically describe how a particular industry works, list the subcategories that may be audited for the proper functioning of the brand or project. In individual branches and mention and incorporate the methodology of work (not the solution; the solution is the subject of another assignment). Form of text output: - Module name: XY - Methodolo...
...neumožňuje ukládání do XLS. Sháníme tedy programátora, který se chce na našem projektu podílet a vytvoří jednoduchou aplikaci, který bude sloužit k ukládání vyčítaných dat do PC. Požadavky: Spustitelný *.EXE SW s možností přidání do naplánovaných úloh. SW bude mít jen pár základních parametrů. 1) URL ke xml souboru (možnost zadání user & password) 2) Název souboru kam vyčítat 3) přípona (xls, xlsx, csv) 4) interval ukládání hodnot (xml je aktualizováno při každém obnovení) 5s, 10s, 30s, 60s, 120s, 300s, 600s, (3...
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Dobry den, poptavam podporu pri web scrappingu informaci o nemovitostech z konkretniho webu. Jedna se mi o strukturovane ulozeni informaci z webove stranky (bude upresneno) do xlsx/csv a idealni automatickou aktualizaci teto databaze. [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] Predem dekuji. S pozdravem, Dan Vasko
Jedna se o dokonceni eshop od webnode na kterym uz pracuji. Par detailu + hlavne import produktu od Partnera pomoci CSV souboru. Predem dekuji.
Hledám programátora, který zajistí automatický import produktů (dat) ze stránek dodavatele do e-shopu. Součástí importu bude i překlad (Google)
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Úpravu CSV importu pro import produktů do Magenta.
Chtěli bychom přenést stávající eshop (), který běží na pronájmu na vlastní prestashop řešení. Z eshopu bychom chtěli hromadně přenést produkty (xml nebo csv) a kdyby to bylo možné, tak i dosavadní objednávky a nějaká další data. Od systému prestashop bychom poté požadovali tyto funkce: xml import produktů (automatický z feedů dodavatelů), xml export na srovnávače (heureka, zboží, hyperzbozi,...), možnost SEO optimalizace (úprava meta informací, "dobré" url adresy), možnost integrace platební brány, integrace Ulož (výběr z odběrných míst), generování...
Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.
I'm currently seeking a competent IT Systems Administrator to join our large team. You'll primarily be responsible for network administration, server management, and software installation and updates. Key responsibilities will include, but are not limited to: - Managing and maintaining our network and server infrastructure - Implementing necessary software updates and installations Ideal candidates will have proven experience in a similar role, with a strong understanding of IT support services. They should be comfortable working in a team of more than five and collaborating with existing IT support members. The successful IT Systems Administrator will need to be proactive, responsible, and effective at communicating with non-technical team members. Demonstrated ski...
I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...
I'm seeking a talented logo and sign designer for my business. I need a large external sign in a modern style that represents the future. The design must visually stand out and help my business be identified easily. Ideal Skills: - Expertise in creating modern, clean, and slick designs. - Experience in designing large scale signage, greater than 4ft. - Excellent knowledge of using scalability in designs for different formats. Your primary task will be to: - Create a unique, modern, and futuristic design. - Ensure the design can be scaled up for a large sign but also be effective when scaled down for use in business resources—like letterheads and business cards. - Create a design that assists in identifying the location and the nature of my business. - C...
I need a skilled Arabic typist to enter data from PDF, into a single excel table .
I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.
I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.
I am looking to commission a skillful artist to replicate an impressionist painting in Dali style on a large canvas, with the painting dimensions being 60x60 inches. The desired color palette is soft and pastel. Ideal candidates would have: - Experienced in Dali-style, impressionistic painting - Knowledge working on large-scale canvas - The ability to accurately duplicate an existing image The success of this project will be determined by an accurate replication of this image in large painted format.
The report will consist of the following tasks: 1. Identify and justify your chosen global target market and present a market analysis that identifies the macro and micro trends and issues that are currently facing the industry in which your organisation operates and how these relevant factors may impact your market sector. 2. Evaluate and align the organisation’s current approach to expand and operate in relation to at least one competitor. 3. Propose, with justification a customer value proposition supported by academic theory/frameworks for the business strategy for your new ethical product, service, brand extension that addresses one or more of the identified global trends or issues. 4. Create an original customer persona for a specific, sustainable target segment, outlini...
I'm looking to commission the creation of a comprehensive database of IT working professionals. The main purpose of the database will be for recruitment purposes. Key Requirements: - The database should focus on IT pr...industry. - The data collected should be accurate, up-to-date and well-organized to facilitate efficient recruitment processes. Ideal Skills and Experience: - Prior experience in database creation for recruitment purposes, ideally within the IT sector. - Knowledge of the IT industry and the different roles and specializations within it. - Attention to detail and the ability to collect and organize large sets of data accurately. Please note that I have not specified the method to acquire the data, so I'm open to suggestions on the most efficient and et...
I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.
I'm looking for experienced web developers to build an e-commerce website for my business. Here's what you need to know: - Purpose: The main goal of the website is to sell my products online. I plan to list between 100 to 500 different items, so the website should be able to acc...any difficulties. - Functions: The website must include a shopping cart and a payment gateway. These features are essential to the operation of my business as they will allow customers to make purchases directly from the site. Ideal Skills: - Experience with e-commerce web development, specifically with shopping carts and payment gateways - Knowledge of best practices for listing and managing a large inventory of products If you have these skills and experience, I'd love to hear from you...
Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.
...spearhead my expansion plans into the California region. The focus of this role is to build contacts within the healthcare sector, specifically targeting medical device sellers. The job involves: 1. Building a contact list: - Researching and identifying potential partnerships within the specified industry. - Creating a detailed list of healthcare contacts in California, primarily from the medium to large-sized medical device sellers. 2. Cold calling: - Establishing initial contact and building relationships with key decision-makers. - Pitching our platform's unique selling points. The ideal problem solver for this endeavor would have: • Previous experience in B2B list building, especially within the healthcare sector. • Strong background in cold calling an...
I'm in search of an experienced Photoshop professional who can help me enhance the realism of a large collection of landscape designs. Key Responsibilities: - Use advanced Photoshop techniques to improve the realism of nature elements in the designs, such as trees, water, and skies. - Maintain a realistic style throughout the project without deviating into a specific mood or style. Ideal Skills and Experience: - Extensive experience with Photoshop, particularly in the realm of nature and landscape editing. - Strong attention to detail and a keen eye for realism. - Ability to understand and improve upon existing designs. Please note that this project involves enhancing the realism of the existing designs, rather than creating new ones. Your ability to bring out the natura...
We are looking for several motivated freelancers interested in creating simple and user-friendly websites on Odoo (1-4p). Proficiency in Python and experience with Odoo are required. We have a large number of Odoo projects to be completed per week, and if you are serious, we will offer you multiple projects per week. Please contact us. Thank you.
I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and desc...
I'm seeking expert assistance with English SEO near Fuengirola, ...be considered a perfect fit for the job. Skills and Experience: * Proven record in improving website traffic through content optimization * Proficient in English and understanding of local SEO practices * Prior work experience with various types of web content I'm based in the Fuengirola area and will be setting up a home based business. I'm a registered agent for a particular service from a large financial institution - business funding for small to medium SMEs. I'm looking for two things - initially a simple landing page to start and someone with the skill set to drive traffic to the page. Going forward there is the opportunity to add embedded finance solution to the web page with full API...
I am looking for a mobile app that will serve as a central communication hub for my large family. Key Features: - Messaging: The app should support both individual and group messaging. It should be intuitive and easy to use, as we have family members of all ages. - Video Calls: Though I didn't select this as my top priority, video calls are important to us. We often have family members who live far away and we want to be able to connect visually. Other Requirements: - The app should be lightweight and user-friendly, as not all family members are tech-savvy. - It should have a secure login system to protect our privacy. - As we are a large family, it's important that the app can handle a substantial number of users. Ideal Freelancer: - Proven experience in develo...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA ...
We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...
As discussed I have delivered the excel workbook. Thanks!
...mobile application that can convert CSV files into Wallet Cards for both iOS and Android devices. The main functionality I require from this app includes: - Customizable Card Design: The app should allow the user to customize the design of each generated Wallet Card. - Push Notifications: The app should have the capability to send push notifications for any updates or changes to the generated Wallet Cards. The Wallet Cards generated from the CSV files should contain the following information: - Cardholder's Name - Card Number - Expiry Date - Security Code - Initial Certificate Date The ideal candidate for this project should have experience in mobile app development for iOS and Android, familiarity with Wallet Card technology, and an understanding of CSV fil...
...the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of cli...
...who can help me with a one-time analysis. The dataset to be worked on is quite large, with over 1000 rows, so I need someone who is well-versed in handling and analyzing large datasets in this platform. Key tasks for this project include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within Google Sheets. - Profic...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.