Vba extracting data mdb spreadsheetงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

I need you to fill in a spreadsheet with data. ทำงานค้าขายตามตลาดนัด

...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills t...

...freelancer who can work with OpenStreetMap data to extract specific elements and format them into a .csv file. Key Requirements: - Extracting Geographical locations: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber, Latitude, Longitude. If available the Community and the Code of the Community The dumpfile is on: The Download and Format-Process should be automated and if possible triggered with a download Button on an HTML Page. By clicking on the Download button, the process of formating the OSM into .csv is startet. Coding of .csv should be UTF-8 Ideal Skills: - Proficiency with OpenStreetMap data and extraction tools. - Experience in formatting data into .csv files. This is a monthly project

I am looking for a professional who has experience in data scraping to extract email addresses of senior level employees in the Building Industry, specifically from the United Kingdom. This task involves collecting the email addresses of 100 senior level employees. Key Requirements: - I need the first name, job title, and email address of each employee. - All the email addresses should be from the United Kingdom. The ideal freelancer for this project should have: - Experience in data scrapping and data mining. - Proficiency in tools and techniques for extracting data from web sources. - Attention to detail to ensure the accuracy of the collected information. - Familiarity with the Building Industry and the job titles associated with senior level roles i...

We're in need of an experienced Data Science Engineer. The ideal candidate should have a strong background in data science, machine learning, and data analysis. Key responsibilities: - Data cleaning: The candidate should be able to clean and preprocess large datasets. - Data analysis: The candidate should be proficient in analyzing data and extracting actionable insights. - Machine learning modeling: The candidate should have experience in building and implementing machine learning models. Although specific programming language requirements were not provided, proficiency in Python, R, or Java would be a strong advantage. This project does not specify a particular industry domain, but any prior experience in Healthcare, Finance, or R...

I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.

I need a freelancer to collect data from online. It is simple job of data search and collection from crowdsourcing website. Would provide spreadsheet with details, all you need to fill the details. We are into venture financing. Job Description: Name LinkedIn profile. contacts (if possible) Attached spreadsheet for your reference. Regards, R

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

...functional and streamlined tracking spreadsheet for multiple facets of a construction project. Ideal candidates should be well-versed in project tracking/reporting, with a profound understanding of construction processes, including: - Timeline: The ability to articulate project deadlines and various stages of the construction in a clean, easy-to-understand calendar view. - Material Inventory: Significant experience creating systems for tracking material usage, including real-time updates, order monitoring, and being able to predict future needs. - Work Progress: Demonstrate a robust understanding of work progress tracking across multiple work fronts, and be able to visualize the progress in a tangible way for stakeholders to understand. The Spreadsheet should have multip...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Pro...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

...applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate, and provide it as well. Start the search from most recent and search backwards in time.

I'm looking for an expert in conducting targeted client and business partner data mining. My focus is on establishing strategic alliances, hence, we need to gather contact information of third party businesses and potential partners where we can market our services. Initial data collection to be from the greater Palm Beach Florida region. Key Tasks are: - Research and compile a spreadsheet of company and social media contacts - Verify the accuracy and relevance of the data - Organize and present data in a usable form Ideal candidate would have: - Strong data mining skills, with a focus on research and social media platforms - Proven experience in similar projects - Attention to detail to ensure data accuracy - Experience in stra...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm looking for a talented freelancer who can assist with scraping automobile ads from website. Key Requirements: - Scraping specific automobile ads. - Extracting ad titles, descriptions and prices. The ideal candidate should have: - Experience in web scraping. - A strong understanding of data collection from websites. - Attention to detail to ensure accurate extraction of data. Please note that the exact websites and the car details are not provided yet, so the freelancer should be able to work with changing parameters.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your st...

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

...need a comprehensive list of all meet-ups, conferences, and trade-shows related to mutual funds, real estate, wealth management, and financial planning that are going to be held in Ahmedabad, Surat, and Vadodara. Key Requirements: - The data must encompass a wide range of events across these financial sectors. - Only events in the cities of Ahmedabad, Surat, and Vadodara should be included. Submission: - The final deliverable should be in a spreadsheet format, making it easy for me to analyze and organize the data. Ideal Freelancer: - Experience in event data collection would be a huge plus. - Familiarity with the financial sector, particularly mutual funds, real estate, wealth management, and financial planning, will be beneficial. - A detail-oriented fr...

I have 50-100 articles that I need data extracted from. The data to be extracted includes brand name, country of origin, franchisor's company name, person's name, title, franchisee's name, company name, their person's name, contact details, and the country. Skills and experience required: - Excellent data entry skills - Proficient in reading and understanding articles - Attention to detail to ensure accurate extraction of data - Familiarity with working on a project that requires extracting specific information from multiple sources.

I need immediate assistance with inputting data from a website into a spreadsheet. Ideal Experience: - Proficiency with data entry - Ability to work quickly and accurately - Familiarity with spreadsheets - Experience with online data capture - Strong attention to detail - Ability to meet tight deadlines

...tracking visitor data, and can help me in capturing contact information of potential customers who do not complete any forms on the site. Key Requirements: - Advanced Visitor Data Collection: The system should be able to capture details like device type, referral source, behavior patterns, and time on page for all visitors. - Contact Information Extraction: The primary goal is to extract the contact details (Name, Address, Phone, and Email) of the visitors who do not submit any form on the site. Ideal Skills and Experience: - Proficiency in Third-Party Tracking Services: The selected freelancer should be well-versed with various third-party tracking services and should be able to recommend and integrate the most suitable one for my website. - Expertise in Visitor Da...

...expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with dates arranged horizontally....

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I'm looking for a skilled data entry specialist to join my team for 2 weeks on a full-time basis, dedicating 8 hours a day to the project. The work primarily involves extracting and entering text data from online databases into a structured format. This data will be used for further analysis and insights. Key responsibilities include: - Extracting text data from various online sources - Accurate and fast data entry - Ensuring data quality and consistency - Meeting daily and project deadlines ONLY IF YOU ARE SERIOUS ABOUT AND CAN DEVOTE 8 HOURS FOR 2 WEEKS THEN ONLY APPLY.. PAYMENT IS 3500 FOR 2 WEEKS. Please apply ONLY if you're capable of dedicating full-time hours for 2 weeks, have a reliable internet connection, and c...

Join our team as a Python Selenium Web Scraper responsible for developing scraping scripts using Python and Selenium. You'll gather data from diverse websites, utilizing your expertise in web technologies, HTML, CSS, and JavaScript. Key responsibilities include analyzing website structures, extracting and cleaning data, and collaborating with team members to integrate data into existing systems. Ideal candidates possess proficiency in Python, experience with Selenium, and a strong understanding of web technologies. This role offers competitive compensation, flexible work hours, health benefits, and opportunities for career growth in a dynamic, collaborative environment

I'm on the hunt for a knowledgeable and experienced audio annotation team to selectively annotate background sounds within my audio files. These annotations must be captured and delivered in a succinct spreadsheet format. Key Responsibilities: * Accurate identification and annotation of background sounds, disregarding any musical content * Compilation of annotations into a well-organized, manageable spreadsheet Ideal Skills & Experience: * Proven experience in audio annotation, specifically with background sounds * Proficient in utilizing spreadsheet software for data compilation and presentation * Strong attention to detail, precision is essential for this role * Familiarity with a wide range of background sounds * Ability to work under deadlines ...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I am looking for a mid-level QA Tester from India, with experience in both mobile and web applications. The ideal candidate for the job should have: - Experience in testing iOS and Andr...for the job should have: - Experience in testing iOS and Android platforms, as well as web portals - Capable of performing functional and design testing - Proficient in testing user registration, login/authentication, and other functionalities as per the logic - Ability to carry out thorough functionality testing as per the given requirements - Ability to report bugs and issues in the Google Spreadsheet with proper description and snapshots Please note that mid-level experience is a must for this role. The chosen candidate is expected to ensure the quality and performance of our mobile app and w...

...on a monthly basis. The project involves: - Collating and organizing data: The dashboard should cover Attendance and leave records, Training and development, as well as metrics like age, experience, tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately...

...sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency in Excel, and previous experience sha...

I'm in need of an expert who can carry out a task that in...a task that involves eavesdropping on Thuraya satellite communications using a Hack RF receiver. This task is for research and analysis purposes. Your main responsibilities will include: - Real-time eavesdropping on Thuraya satellite communications. - Extracting specific information including location data, voice communication, and details of data transfers. The ideal freelancer for this project should have: - Proficiency in working with satellite communication systems. - A strong understanding of Hack RF receivers. - Experience in data extraction and analysis. Please be sure to include any relevant experience in your proposal. This is a complex task that requires specialized skills, so releva...

I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.

Project Description: I am looking for a skilled Data Analyst to help develop a system for classifying email messages as SPAM or HAM. This involves downloading data from a public source, processing it to extract and compute various features, and analyzing these to determine patterns indicative of SPAM. Responsibilities: Download email data from a specified public archive. Create R functions to extract and calculate over 20 variables from each email, such as the number of recipients, percentage of capitals, and URL presence. Analyze this data to explore variable relationships and determine SPAM/HAM status. Generate visual representations of the data and analysis findings. Provide a detailed report on the methodologies used, results obtained, and insights g...

I'm seeking a professional who can help me leverage Azure OCR Document Intelligence in order to automate the data entry process for a set of invoices. Requirements: - Utilize Azure OCR for extracting text from invoices - Implement an automated system for data entry based on the extracted text Integration: - I require the system to be integrated with my accounting software. Ideal Skills: - Proficiency in working with Azure OCR Document Intelligence - Strong experience in automating data entry processes - Prior work in accounting software integration is a plus

The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!

I need an expert in data capturing to mine specific information from websites and organize it efficiently into spreadsheets. The ideal candidate should be meticulous and comfortable with the following: - Data Capturing: The primary task involves extracting and compiling data from various websites. - Web Research: Ability to navigate and find required data efficiently. - Spreadsheet Proficiency: Experience with spreadsheets and data organization. Please bid if you have a strong eye for detail and a proven track record in data entry and web research.

...requirements for this task are as follows: - The extracted photos need to be saved as a single PDF document. I don't require individual image files. - The resolution quality of the extracted photos must be high - 300 DPI or more. Please ensure this whilst extracting as it's essential for the final output. - The photos extracted should ideally follow a random naming convention. The order doesn't necessarily need to adhere to the page number or alphabetical rule. The ideal freelancer for this task would have experience in handling image data extraction, particularly from PDF files, and should be adept at maintaining high-quality outputs. Familiarity with PDF and image editing software is highly desirable. Your ability to follow instructions and pay attent...

...in jpg format, each with GPS metadata. I need an expert to convert this metadata into Google Earth points. Key requirements: - **Automatic Generation:** The points should be created by extracting metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** Experience in creating KML files and working wi...

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Seleni...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

I require an experienced data analyst conversant with Excel to create a detailed spreadsheet and comprehendible report about compression pay between LPN & RN nurses, as well as nurse supervisors. Key data points to include: - Hourly pay rates of each role - Years of experience in each position - Total number of employees in each role - Comparison of compression pay between the nurse employees and nurse supervisors The compression pay should be calculated using a ratio comparison method, highlighting the variation in detail. I am also looking for a detailed analysis in the report explaining the compression shown. Required skills: - Proficient in Microsoft excel - Experience in generating analytical reports - Strong attention to detail - Understanding of th...

Hello, I'm looking for someone to create a Google Sheets spreadsheet filled with YouTube URLs that meet the following criteria: * License: Must be Creative Commons licensed. * Visuals: - Full face visible, speaking directly to the camera; the rest of the body can be included. - Only one person in the shot and speaking throughout the entire video (no cuts to other people). * Quality: High definition (HD or better), not grainy. * Editing: Minimal editing; should be a single take (intro and fade out are acceptable). * Audio: Clear speech; background noise or music is okay if it does not overpower the speech. * Occlusions: No obstructions, such as hands or microphones, in front of the face. * Emotion: Videos displaying significant emotional expression are preferred...

...xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Excel is a must for this project. - **Data Entry Specialist**: Experience in...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.