Vba extract data mdbεργασίες

Ψάχνω για έναν επαγγελματία ειδικό στο Excel που γνωρίζει VBA macros. Το κύριο αίτημά μου είναι να δημιουργηθεί μια μακροεντολή για την αυτοματοποιημένη δημιουργία προσ&...

Χρειαζομαι εναν επαγγελματια για γλωσσα προγραμματισμου VBA.

Σε ένα βιβλίο εργασίας ms excel 2016, αντλώ με ερώτημα δεδομένα από SQL SERVER, (που τροφοδοτείται από εμπορικό - λογιστικό ERP) και στην συνέχεια με συναρτήσεις παράγω δικά μου αποτ&epsilon...

To create key element from below link for infographic Designs. Link is about Dubai Expo 2020, you have to extract content(key element) from it. Kindly see the attachment for reference of infographic, so you get an idea about the key elements. I need this to be done in two hours.

I've inherited a project pushed to GitLab. I need to extract the 'Published' internal data (and types) within the Project application so I can identify what's available to 'Subscribe' to when creating a ROS node. The application is in C++. I'm a newbie to GitLab, so need to know how to do this and get guidance. The ideal freelancer will have: - Very Good Experience with GitLab - Experience in C++ - Familiarity with ROS (any version) - Ability to document clearly. Any format will do, PDF would be ideal. - Capable of identifying data structures and types.

The primary goal is to estimate blood pressure from PPG involves extracting true values for training from videos. The videos are in MP4 format, and I need ...primary goal is to estimate blood pressure from PPG involves extracting true values for training from videos. The videos are in MP4 format, and I need assistance from someone skilled in data analysis, machine learning and medical imaging interpretation. Please note: - The primary goal is to estimate blood pressure from PPG data. - The successful freelancer will need to accurately extract the necessary data from the provided videos. - PPG data analysis will be highly advantageous. - Proficiency in machine learning will be necessary for training the model with the extracted data. - The ppg...

...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch file shoul...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

I'm seekin...agents that can enhance our operational efficiency. The goal of this project is to develop comprehensive workflow automation solutions that can streamline our business processes and extract meaningful insights from a variety of data sources. Ideal Skills and Experience: - Proficient in AI and machine learning - Experienced in developing automation agents - Understanding of comprehensive workflow automation - Capable of handling diverse data sources Key Project Components: - Developing AI-driven solutions for automating critical business operations - Creating intelligent systems that can analyze and interpret data - Delivering projects that enhance operational efficiency and effectiveness Let's arrange a meeting to discuss this opportuni...

Hello, I am looking for a developer who. Puls create a little application where I place a PDF and it will use OCR function of ML KIT Text Recognation. It should be also possible to extract only parts by selecting some part of text and then with regex extract or with let him know right part of selected text who have a text identifier.

Looking for an experienced developer to writer a script and scrape a website for data attributes that gets sent to an API. Details to be discussed in chat.

I'm looking for a proficient web developer who can create a web scraper for a real estate website, specifically propertyfinder.com. The scraper should be able to extract comprehensive property details, agent information, size, pictures, bedrooms, and location. Key Requirements: - Extract data from - Save the scraped data in Excel/CSV format. Ideal Skills: - Proficient in web scraping - Familiarity with real estate websites - Excellent data handling skills. Please include examples of similar projects you've completed in your proposal.

...document processing workflow. A PDF document containing client information (e.g., name, address, and mortgage details) needs to be uploaded. Certain fields must be extracted, validated by a human, and then have the key data fields stored in a Google Sheet for future use. Objective: Design a solution for this process and implement a basic prototype or provide a detailed explanation of the steps you would take. Use a no-code automation tool where possible (eg: n8n) Instructions: Doc Upload Upload a PDF. You can take examples PDF from the internet. Extract key pieces of data (e.g., Name, Address, Mortgage Amount, mortgage number, lender name). Outline assumptions or edge cases you’d consider (e.g., handling missing fields, formatting issues). Doc Validati...

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I'm seeking a data entry clerk who can help me extract salah timetables from images and websites of approximately 50-100 mosques around the UK every month. This task involves: 1. Visiting the website of each mosque to screenshot the timetable for the current month. 2. Using any reliable tool to extract the data (I can provide access to ExtractTable if needed). 3. Copying and pasting the table columns into a provided template file. 4. Ensuring that the formatting is correct, with columns in the right order and times in 24h format. 5. Sending the completed file back to me. It takes approximately 2-5 minutes per mosque and so, I will pay £0.10 - £0.20 per file completed correctly. That means if you complete 50 timetables over 2 hours, you will ea...

I'm looking for a freelancer who can help me pull a list of my Microsoft Teams channels into a SharePoint list. Key Requirements: - Utilize the Microsoft Teams API to extract the data - Pull only the channel names from Teams - Implement a system that updates the SharePoint list upon the creation of a new Teams channel. Note: I already have a trigger set for this. Ideal Skills: - Proficiency in Microsoft Teams API - Experience with SharePoint and its integration capabilities - Familiarity with scripting for automation

I'm seekin...agents that can enhance our operational efficiency. The goal of this project is to develop comprehensive workflow automation solutions that can streamline our business processes and extract meaningful insights from a variety of data sources. Ideal Skills and Experience: - Proficient in AI and machine learning - Experienced in developing automation agents - Understanding of comprehensive workflow automation - Capable of handling diverse data sources Key Project Components: - Developing AI-driven solutions for automating critical business operations - Creating intelligent systems that can analyze and interpret data - Delivering projects that enhance operational efficiency and effectiveness Let's arrange a meeting to discuss this opportuni...

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basi...

I'm in need of a skilled data scraper to extract information from a variety of sources. Website Scraping: - Text content - Links Social Media Scraping: - Data from Facebook - Data from Twitter - Data from Instagram The ideal freelancer for this project should have extensive experience in web scraping and social media data extraction. Proficiency in programming languages such as Python is a plus.

I'm seeking a proficient web scraper to extract contact details from the provided website. Ideal Skills: - Proficient in web scraping tools and software. - Experienced in data extraction from company websites. - Deliver the extracted data in Excel format.

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

I'm in need of a skilled web scraper to extract property listings from PropertyFinder. The project involves capturing essential details such as property descriptions, prices, locations, sizes, and pictures. Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Prior experience in scraping real estate data - Ability to handle large datasets - Attention to detail for accurate data capture - Familiarity with handling images in data scraping

I need a program/software to streamline the process of creating consistent Safety Data Sheets (SDS) from various source files. Each file is a PDF or Word document, and the program should extract relevant text elements and fill them into a Word Document template. Key Responsibilities: - Extracting text elements: The software needs to identify and pull out the title and headings, paragraphs and descriptions, as well as tables and data fields from the source files and fill in the correct sections. No text should be lost. - Template filling: The extracted information should be inserted into a predetermined Word Document template.I also have the Indesign working file as well. Please note that the source files will be uploaded manually, so the software should be user-fri...

What is 167 * 4? Please answer this question to confirm that you’ve read and understood the job description and the requirements outlined. . . I am looking for someone with access to multiple Apollo accounts to extract leads using specific filters that I will provide. The filtered results should total approximately 150,000 contacts. The leads must be downloaded and compiled into an organized Excel file for easy access and use. My budget for this project is $50. If you successfully complete this task, there will be an opportunity for ongoing work with unlimited similar projects every month.

...Step 7: Data Extraction Extract key information from the selected studies. Use a structured table with columns for: • Study Title • Authors • Year of Publication • Research Objective • Methodology • Key Findings • Limitations Step 8: Analyse and Synthesize the Data 1. Descriptive Analysis: Summarize publication trends, geographical focus, industries covered, and methodologies used. 2. Thematic Analysis: Identify recurring themes, frameworks, and critical findings. 3. Identify Gaps: Highlight areas lacking research or requiring further exploration. Step 9: Report the Findings Write your SLR as a structured paper with these sections: 1. Introduction: Define the scope and importance of the review. 2. Methodology: Explain your SLR pr...

...Classification: The main task at hand is to develop an algorithm that can efficiently classify different textures present within the digital photos. - RGB to HSI Conversion: A specific requirement for this project is the conversion of RGB images to HSI (Hue, Saturation, Intensity) format. This is crucial for the texture classification process. - Feature Extraction: Utilizing machine learning techniques to extract relevant features from the images will be key in improving classification accuracy. Ideal candidates for this project should have: - A solid background in machine learning. - Proven experience in image analysis. - Familiarity with RGB to HSI conversion techniques. I am looking for someone who can deliver high-quality work, adheres to deadlines, and communicates effect...

Extract data from website and export in excel sheet

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 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 w...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 accu...

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 will be able to deli...

...generate new math exercises with answer key. To do so, we can use a chatbot API like the one from chatgpt. First we need to extract each exercise with its number. For example the first exercise is : Number: "NO2" Exercise: "Si je pense à un nombre, je lui retranche (-12) et je trouve 3. Quel est ce nombre?" Here is the exercise is not well written, so we can use an AI API to rewrite it: Number: "NO2" Exercise: "Si en pensant à un nombre, en lui retranchant (-12), on trouve 3, quel est ce nombre ?" Often there is unnecessary content between the exercises that needs to be removed. Each exercise with its number has to be stored in a Python huge list. Then we need to extract the answer of each exercise which is insi...

I need to identify the creator of a specific PDF file. The PDF will be uploaded to the platform. The task is solely to extract the name of the creator from the PDF file's metadata. Ideal skills for the job include: - Proficiency in handling PDF files - Attention to detail - Ability to ensure confidentiality and respect for privacy.

I need assistance typing a product list from scanned documents. The list contains over 501 products. For each product, you'll need to extract and type the product name, price, and description. This project requires: - Strong typing skills - Attention to detail - Ability to work with scanned documents Please ensure you have a good understanding of the requirements before bidding. Thank you.

I need a proficient web scraper to extract car models and prices from various car rental websites, specifically Hertz, Avis, Sixt, and Budget. This data will be collected on a weekly basis.

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 need a WordPress developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should

I'm seeking a talented writer experienced in crafting Wikipedia articles to create a biographical piece about a public figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional resea...figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional research and writing skills - Ability to adhere to Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biography I can provide a wealth of resources including: - News articles - The official website of the subject - Interviews Your task will be to sift through these materials, extract the most relevant information, and present it in a manner that's suitable for Wikipedia. Please ensure to maintain a neutral point of view and adhere to Wikipe...

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'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fe...

I'm seeking an automation expert to help extract product information from an FTP server and update my Shopify store. Key Requirements: - Extract product information from the FTP server - Automate the process to ensure regular updates on Shopify Ideal Skills and Experience: - Proficiency in data extraction from FTP servers - Experience with Shopify updates - Automation expertise - Familiarity with product information management. Note: The specific product information to be extracted and updated, as well as the format of the data on the FTP server, will be discussed further. Please bid if you have relevant experience and can provide references.

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

I'm looking for a skilled web scraper with API development experience. The task involves extracting product information from three specific websites. Key Requirements: - Extract product descriptions from specified websites - Develop an API to facilitate this - Present data in a user-friendly JSON format Ideal Skills: - Strong background in web scraping techniques - Proven experience with API development - Attention to detail - Ability to work independently If you've successfully completed similar projects in the past, I would love to hear from you!

...striking pop art style inserts. * Text/Graphics: Display of our band name and album title, using preferred fonts and open to evolving styles. * FX Styles: VHS Aesthetic, Dark Noire, Glitchy, Vintage MTV, Pop Art (like the old Batman TV visuals). Materials Provided: A mix of live show photos and VHS-digitized footage, ranging from crisp to vintage blur, via Dropbox. Bonus Skills: 1. Ability to extract usable snippets from low-profile films and YouTube visuals. 2. Capability to animate still images using AI technology. Please share your ideas and cost estimates for bringing this vision to life. Thanks! Johnny Xmas...

...parsing to help me complete a backend workflow in Bubble. The goal is to process data from QuickBooks Online’s Balance Sheet API and store specific values, such as "Total Bank Accounts" and "Total Accounts Receivable," in a Bubble database. I already have: - A working API connection in Bubble that returns the JSON response. - A backend workflow triggered by the API call. What I need help with: - Extracting specific values from the returned JSON response, such as: "Total Bank Accounts" and its corresponding balance. "Total Accounts Receivable" and its corresponding balance. - Mapping these extracted values to fields in a Bubble database Thing. - Ensuring that the backend workflow correctly processes and saves the data. Key De...

...Overview: Looking for a Python developer to create a YouTube channel caption extraction bot with specific requirements for handling large-scale video processing. Project Requirements: Create a bot that processes YouTube channel video pages (e.g., @TheCookingFoodie/videos) Core Functionalities: Process all videos from a channel's video page Extract and save: Video titles Video URLs Closed captions (CC) Save data in text files named after each video Process videos chronologically (oldest to newest) Handle 1000-2000 videos per channel Technical Specifications: Language: Python Implementation using Python requests or YouTube-specific libraries Error Handling Requirements: Handle video page loading failures with refresh capability Log videos without CC to Implement

I need a skilled Python developer to create a web scraper for me. The scraper should be able to extract structured data, like tables, from various e-commerce websites. The project requires a deep understanding of web scraping techniques and best practices in Python.