Lookup vba excel 2007práce

Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...

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.

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

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í.

datae

datae

mise en forme

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

Napraviti Excel VBA program

...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...

Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.

I'm looking for a Excel expert who can help me automate the extraction of data from 3 different PDF formats. Requirements: - Create 3 different Power Query scripts to extract both text and table data from PDFs located in a specified folder. - The extracted data should be saved into multiple Excel files. - Implement simple data transformations such as sorting and filtering after extraction. Ideal Skills: - Expertise in Excel, Power Query and PDF data extraction. - Experience in creating scripts for data automation. - Knowledge of simple data transformation techniques.

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

I need help with web scraping from a specific e-commerce website. The g...e-commerce website. The goal is to gather comprehensive data for product analysis. Key Data Points: - Product details - Pricing information - Stock levels - Minimum order quantities - Delivery times - Specific product information as detailed on the sites The extracted data should be delivered in an Excel format. Ideal Candidate: - Proficient in web scraping tools and techniques - Excellent data analysis skills - Familiar with e-commerce platforms - Able to deliver clean, well-organized data in Excel Looking forward to your proposals. The website would be the following and we would like to see the details for all manufacturers listed:

More details: What specific tasks do you want the macro to perform? Data analysis, Data formatting Do you need the macro to run automatically under certain conditions? No, I'll run it manually What level of user interaction do you foresee with the macro? Simple prompts and inputs

...every subscriber - Be authentic and chat like the girl would - Improvise fictional sp1cy scenarios and build rapport with top spenders Requirements needed: - You need to be able to chat fluently in English - A laptop/computer with reliable internet - Comfortable with sp1cy content and engaging in improvised fictional conversations - 0F Chatting experience is a MUST - Familiar with Excel Spreadsheets (This is what you will use to track your sales and commission) - - - Able to work from 8pm-1am AEDT 6 days/week (These hours may change) Payment: - AUD$4/hr + 3% Commission on all of your sales and tips generated - Your commission is uncapped and there is potential for wage increase based on proven excellence. - Paid weekly every Wednesday Hours: - 5hrs/per day...

I'm in need of a skilled professional to assist with data collection and verification from a trade fair website. The aim is to enhance my sales outreach efforts. Tasks will include: 1. Checking the exhibitor page for company names and existing contact details 2. Searching for missing information on the internet 3. Finding and adding LinkedIn prof...contact details 2. Searching for missing information on the internet 3. Finding and adding LinkedIn profiles of individuals in top and mid-management positions within these companies Ideal candidates should have: - Excellent research skills - Proficiency in data collection and verification - Familiarity with LinkedIn and able to identify relevant profiles - Understanding of sales outreach processes Excel format will be given to co...

...tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this servi...

...mentioned sectors with validation via Linkedin / Zoominfo. - Generate 50 leads and gather key contacts, focusing on top level executives and department heads in healthcare organizations, private hospitals and fintech firms. You could choose a market and go from there, 200-5000 employees enterprises must be targeted. - Deliver a well-organized contact list for potential business outreach with emails ( excel ) Ideal Skills: - Proven experience in lead generation and market research using LinkedIn and similar tools. - Strong understanding of how to conduct market research and leads generation. - Excellent data organisation and presentation skills. - Strong communication skills for potential follow-up correspondence. Please submit your proposal if you have the required experien...

I need a freelancer to convert a larage 25mb .apkg file from AnkiNotes into an Excel file. there is around 1765 words of vocabulary (german to english) Requirements: - Extract the metadata from the .apkg file, such as tags and creation dates. - Organize the extracted data in the Excel file with the German in one column and the English equivalent in the other. - Use standard headers in the Excel file with German and English columns. - if there is audio or images, remove it, i just want the translations

I need a freelancer to convert a larage 25mb .apkg file from AnkiNotes into an Excel file. there is around 1765 words of vocabulary (german to english) Requirements: - Extract the metadata from the .apkg file, such as tags and creation dates. - Organize the extracted data in the Excel file with the German in one column and the English equivalent in the other. - Use standard headers in the Excel file with German and English columns. - if there is audio or images, remove it, i just want the translations Ideal Skills: - Proficiency in data extraction and Excel. - Familiarity with AnkiNotes or similar software. - Attention to detail to ensure the data is accurately converted and organized.

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer...

I need a mobile application developed mark... Key Features: - The app will target one company , so it needs to be user-friendly and accessible. - Although the specific types of survey questions already available and determined , the app should be flexible enough to incorporate various question types like multiple choice, open-ended, and rating scale. - both language English/Arabic the platform - response analysis should be PowerPoint, excel - IOS/ANDROID APP Ideal Skills: - Proficiency in mobile app development with a focus on e-commerce. - Experience in creating survey tools within apps. - Strong understanding of UX/UI principles to cater to the general public. Your bid should reflect your understanding of these requirements and your ability to deliver a high-quality, funct...

Hello Detailing the Proposal for smooth Project Workability is all the data (pnj shared on message) 2. We need to have this well formatted in a professional dashboard look with ease on visual interpretability 4. Filtering Across individual Locations

...language detection and CRM integration for lead management. Additionally, the AI can be trained using the user's voice to add a personalized human touch to conversations. Calls will be made using SIM-based calling instead of VoIP for reliability and cost-effectiveness. 1. Lead Management Integration with CRM: Import leads directly from our CRM system. Manual Import: Upload leads using Excel files or CSV format. Manual Entry: Allow users to input numbers manually. 2. Call Modes Manual Calling: Enable users to make calls directly through the app. AI-Powered Automatic Calling: AI should initiate calls on behalf of the user, engaging leads in natural, human-like conversations. - SIM-Based Calling Reliability: Calls are made using SIM-based telephon...

...following steps: * converting the hard copy films into the required file format ready for YouTube uploading; * uploading each film to the Channel * copypasting wording for the desciption of each film on each individual film page. This content will be provided in an Excel spreadsheet so this step will involve copypasting, *not typing in the copy content from scratch, and not creating and copywriting the content yourself* * copypasting the associated key words for each film as YouTube 'tag words' (also provided in the master Excel spreadsheet) Requirements: 1. Proven experience in setting up and creating YouTube Channels. Your YouTube Channel experience can be from any industry sector. (If you happen to be interested in art films then you might enjoy the work as...

I need a Python-based solution to convert tabular data from image files into Excel. The solution should include a simple front-end app with specific features. Key Requirements: - The front-end app should allow users to upload image files containing structured data and download the resulting Excel sheet. - The data in the images consists of handwritten format i want data to extracted in specify way numbers are in format of 6688/10 5853/5 and so in . I want numerators should be sorted in one column with title model no and denominator should me in next column with quantity App should have API key as well so that i can integrate ion my existing application the conversion process needs to accurately capture the structure of the data. - Proficiency in Python, specifically in...

I'm looking for a professional who can create a tailored Excel spreadsheet for me. The primary focus of this project is to automate the process of report generation through the use of macros. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel - Proficiency in creating and programming macros - Experience with task automation in Excel - Understanding of report generation processes

I'm seeking a freelancer to assist me in compiling data on the manufacturing industries in China. The focus of this project is to gather information on 20,000 companies from each of these countries. ...industries in China. The focus of this project is to gather information on 20,000 companies from each of these countries. Key Requirements: - Data Points: The data should include company names, email addresses (and variations such as 'email 1', and 'mix emails'). - Format: The final data should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Previous experience in data collection and analysis. - Familiarity with the manufacturing industries in China. - Proficiency in Excel and data management. - Attention to detail and ability to...

I am looking for a skilled Virtual Assistant whose primary responsibility will be data entry. The tasks will primarily involve working with Excel for scheduling and calendar management as well as email sending through outlook. Ideal Skills and Experience: - Proficient in Excel - Detail-oriented for accurate data entry - Good organizational skills for managing tasks - Reliable and self-motivated - Email management: Sorting, prioritizing and responding to emails as appropriate. - Calendar scheduling: Organizing appointments, meetings and events. - Travel arrangements: Planning and coordinating travel logistics. - Job booking: Assisting with scheduling and booking tasks. - Checklists: Maintaining and updating task lists. - Completion rates: Tracking and reporting on task comp...

I'm looking for someone to create 2(two) previously named Twitter (X) lists, each containing 500 accounts (so a max of 1000 for the 2 lists). The specific criteria for organizing these lists are in the excel attached. Ideal Skills: - Proficiency in using Twitter - Ability to create and manage lists (you create them with the account you have) - Understanding of social media metrics p.s: Lists would look something like this. Experience: - Prior experience in social media management - Familiarity with Twitter's interface and features - Proven track record of creating organized and useful Twitter lists p.s: Whoever finishes this first, I will give more work as I need more lists done. Make sure you space them out, so twitter does not limit you from

I'm looking for an Excel expert who can assist me with pivot tables and advanced formulas. If you are skilled in creating and customizing pivot tables, using advanced Excel functions like VLOOKUP, INDEX/MATCH, and combining multiple data sources, then you are the freelancer I need. Ideal Skills and Experience: - Proficiency in Excel, particularly with pivot tables and advanced formulas - Experience in creating and customizing pivot tables - Expertise in using advanced Excel functions (e.g., VLOOKUP, INDEX/MATCH) - Ability to combine multiple data sources - Strong attention to detail and organizational skills

This semester you will be completing ...interpreting/summarizing data, and creating data visualizations. Open the following Word document and Excel workbook and save them (with your name) to your desktop. You need both to complete the assignment. Follow the instructions included in the Word document to fill in the Excel worksheet and then use those results to complete the bottom section of the Word document. Once completed, please submit both to Canvas. Data Analysis and Visualization Data Analysis and Visualization Data Analysis and Visualization Activity Excel Data Analysis and Visualization Activity Excel Once you've completed the activity, please save your Word document and Excel workbook, and submit each below.

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

...in e-commerce and digital marketing. • Excellent written and verbal communication skills with the ability to adapt to different audiences. • Strong understanding of budgets, targets, and product pricing. • Proficiency in analysing sales data and making data-driven recommendations. • Self-motivated and proactive with exceptional organisational skills. • Proficient in Microsoft packages including Excel and PowerPoint. • Knowledge of graphic design is an advantage. Join our team as an Amazon Account Executive and take your career to new heights! Apply now and be a part of a dynamic and innovative organisation that values your skills and offers growth opportunities. We offer a competitive salary package and a vibrant work culture that encourages collab...

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

...House API () with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval process. Additional Notes: Include instructions on how to use

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the s...Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and Dir...

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...

...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...

Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...

...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience