Vba extracting data mdb spreadsheet jobs

I'm looking for a skilled developer who can create a program that will facilitate the sending of multiple emails from an excel spreadsheet, with a PDF attachment. Key requirements include: - Using Gmail as the email service provider. - The emails will be sent to multiple recipients with the same content. - The frequency of sending emails is irregular. The main responsibilities of the program are: - Extracting email addresses and any other necessary information from the spreadsheet. - Attaching a PDF to each email. - Sending out the emails. Ideal skills: - Proficiency in Python or similar programming language. - Experience in working with Gmail API. - Proven track record in developing email automation tools. Please note that while personalization is not current...

I'm looking for an experienced app developer to create a Windows-based application for engineers to perform quick checks on wall thickness calculations, pipe support adequacy, and support span for non-metallic piping. I have a spreadsheet with the required calculations The main functionalities of the app should include: - Wall thickness calculations - Pipe support adequacy check - Support span for non-metallic piping Furthermore, these functionalities should operate based on standard engineering calculations and formulas, specifically - ASME B31.1, ASME B31.3, and ASME B31.4. Ideal freelancers for this project would have prior experience in developing engineering tools or apps, a solid understanding of the mentioned engineering principles, and proficiency in Windows app deve...

I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accounted fo...

I need trustworthy and diligent assistance with a data entry project. This involves managing text-based data from spreadsheets and documents. - Responsibilities: The primary responsibility will be organizing the provided materials and grouping them by type. - Ideal Skills and Experience: The ideal candidate will have exceptional attention to detail, efficient typing skills, proficiency in Excel or other spreadsheet software, and an ability to distinguish between various types of documents. Experience in data entry would be a plus. Your hard work and organization skills will be vital in successfully completing this project. I look forward to collaborating with a professional who will uphold the standard of this project by providing excellent and timely result...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import

I'm seeking a professional who can assist me with populating a Google Sheets spreadsheet with text data from existing databases. This is for the purpose of conducting detailed data analysis. Key Responsibilities: - Locate and extract image links from existing databases - Ensure accurate and error-free input into the Google Sheets - Paste the image links into the right product row Ideal Skills and Experience: - Proficient in using Google Sheets and extracting data from databases - Strong attention to detail to ensure data accuracy - Familiarity with data analysis techniques is a plus - Ability to organize and structure data effectively for analytical purposes I'm looking for someone who can work efficiently and provide hi...

...scraper who can extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as ...

I'm seeking a dependable freelancer for a weekly web data extraction task. The primary purpose of this extraction is for market research analysis. Key Responsibilities: - Conduct weekly web data extraction for market research purposes - Deliver the extracted data in an Excel spreadsheet format Ideal Skills and Experience: - Proficiency in web scraping and data extraction - Previous experience with market research data - Strong attention to detail and reliable turnaround time

I have a substantial amount of survey data, all neatly organized in a spreadsheet. I am looking for a professional with experience in descriptive statistical analysis to help me make sense of it. Key requirements are as follows: - Expertise in descriptive statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed descripti...

Help with repetitive data entry tasks. As a potential programmer, this project involves creating a local program capable of extracting a single line of data with multiple fields from a Google Sheet and transferring it to 10+ different multi-page website forms that require unique login information. Additionally, the program should generate PDF documents on the target websites based on the transferred data and save them with named files corresponding to the original Google Sheet. It is crucial to incorporate error handling, data validation, mapping, and security measures into the program. If you are interested in working on this project, please provide details of your relevant experience and approach for ensuring its successful completion. The program mus...

...Requirements: - Aggregating Business Ratings: The system should specifically focus on collecting the business ratings of security installation services available on Google. Data Points: The key data points that need to be collected include each business's overall rating and star reviews listed on Google SERPs. for Ideal Candidate: - Proficient in Web Scraping: Experience extracting and aggregating data from websites is essential. - Familiar with Google API: Knowledge of Google's API for harvesting ratings and review stars would be a plus. - Data Analytics Skills: Ability to process and analyze large amounts of data efficiently. - Rich Results and Schema Markup Please provide examples of similar projects you've worked on, and ...

Hi This is Ed. I need a new spreadsheet we are using with U.S. Government Contractors. It is similar to the project that we did last week and may be able to use that model and tweek it to work. The cells will have to be identifiable so it can be vetted that the calculator is working correctly.

I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.

Please Sign Up or Login to see details.

I require an expert in web scraping. The project involves extracting content, images, and product details from Amazon, eBay, and Craigslist. Key Project Requirements: - Extracting text content, images, and product details from Amazon, eBay, and Craigslist - Timely completion is crucial - the deadline is set as ASAP Skills Required: - Proficiency in web scraping tools and techniques - Experience in scraping from various types of e-commerce websites - Ability to deliver results quickly and efficiently This is a time-sensitive project and I'm looking for a professional who can deliver high-quality work promptly.

...researcher who can delve into a provided spreadsheet of businesses for analysis. The data is varied and comprehensive, including but not limited to customer demographics, product descriptions, and pricing information. This is exclusively a RESEARCH project, and will take some time. Because of this I WILL ONLY PAY HOURLY. If you require a fixed price/contract, do not bid, I will not give you the job. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges based on the data This pr...

I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted lead...

I'm in need of a skilled web scraper who can extract product details from Website 1 and deliver them to me in an Excel spreadsheet. Key requirements: - Extracting specific product details from Website 1. - Organizing and delivering this data in an Excel spreadsheet. Ideal skills and experience: - Proficiency in web scraping. - Strong understanding of data organization and delivery methods. - Experience in working with Excel for data delivery. Your role will be crucial in helping me access and utilize specific product data from Website 1. The neat and organized delivery in Excel will ensure I can efficiently work with this information.

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself....

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

...and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's on-brand. - User-Friendly Experience: As well as being visually appealing, the tracke...

I need help with a data entry task that involves extracting data from various websites and inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understa...

...call log that I need digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Str...

I have a requirement for an experienced photo editor familiar with image compositing. The task at hand involves: - Extracting a person from their existing photographic context - Re-positioning them onto a new nature scenery-based background. - Crucially, the original lighting and shading on the person should be preserved as much as possible despite the change of background. Expertise in Adobe Photoshop or similar software is required, along with a strong understanding of lighting, shading, and color balance to seamlessly integrate the person with the new nature-themed background.

We need to develop a script that will massively create descriptions for ~5000 products in a Google spreadsheet. Descriptions should be created via GPT-4 with processing of the product photo, title and current description.​

...a Google Slides presentation with data from a Google Spreadsheet. Here's what I need: - The script should update only specific slides within the presentation. - These specific slides will be identified by their slide numbers. - The data to be updated will vary, and may include both text and charts/graphs. Ideal skills and experience for this project include: - Proficiency in Google Apps Script, particularly with regards to Google Slides and Google Sheets integration. - Experience with updating specific slides in a Google Slides presentation. - A good understanding of how to handle and update different types of data within Google Slides, including text and graphical elements. The successful freelancer will need to understand the varying nature of the ...

I have a calculator within my ...and provide me with the necessary data. Key Requirements: - I need to obtain the input values, calculated output, and form submission data from the decoded calculator. - The calculated output should be displayed in a text format only. - The calculator should not require any further editing or changes in its functionality after decoding. Ideal Skills and Experience: - Proficient in WordPress and experienced with GP Forms. - Strong understanding of data extraction and interpretation. - Excellent attention to detail to ensure accurate data retrieval. - Capability to provide the data in a clear and organized manner. Please note that the calculator should remain functional and usable after decoding, just with the added capab...

...absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual reports. - Graphical visualization of absence da...

I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.

I'd like to have a Google Sheets-based Fixed-rate mortgage EMI calculator created. The calculator should require users to input the loan amount, interest rate, and loan term, and then provide the EMI for that mortgage. In addition, the calculator should also include: - An Amortization Schedule - An Extra Payment Calculator - An Affordability Calculator I am looking for an experienced spreadsheet professional who can create these functionalities in an easily understandable and user-friendly format. This project requires a strong understanding of mortgage calculations, Google Sheets and financial formulas. Please reach out if you have the relevant skills and experience.

I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.

...document that I'd like to have recreated in Google Sheets. This newly created spreadsheet should have an additional summary page. Key Requirements: - I require the spreadsheet to have automatic calculations. For example, I'd like the sheet to automatically sum up the tasks, highlight overdue tasks and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the s...

We are seeking an experienced NLP Engineer to develop a robust resume parsing solution for our website. The ideal candidate will have a strong background in Natural Language Processing (NLP) and machine learning techniques to accurately extract and structure information from resumes. Responsibilities: Develop and implement NLP algorithms to parse and extract relevant data from resumes. Ensure high accuracy in extracting information such as personal details, education, work experience, skills, and more. Integrate the parsing solution with our website to provide seamless user experience. Continuously improve the parsing accuracy through machine learning and feedback loops. Collaborate with our development team to ensure smooth integration and functionality. Requirements: Pro...

I am in need of a tool that can effectively extract information from Telegram groups and channels for lead generation purposes. Key Requirements: - Extracting phone numbers: The most crucial information I need are phone numbers for potential leads. Purpose: - The extracted phone numbers will be used for WhatsApp marketing. Ideal Skills: - Proficient in data extraction from Telegram - Experience in lead generation - Knowledge of WhatsApp marketing Looking forward to receiving bids from experienced freelancers who can fulfill these requirements.

...looking for a highly-skilled individual to take on a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professio...

...to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow easy expansion for adding new sales data, inventory items, saved BOMs, assemblies, types or categories. **Skills Required:** - Demonstrated experience in BOM and Inventory system development. - Advanced Excel Macros and VBA skills. - An analytical approach with a focus on delivering simple and functional solutions. Candidates are encouraged to share examples of previous similar projects. This project aims to deliver a straightforward solution that sup...

Hello, I want a development. I want a touchscreen interface to control a custom vending machine. I need someone who has already worked on the MDB protocol for payment. My request is that a customer can access a touchscreen with 2 to 8 pictures. He select a picture, it send via the MDB protocol the payment request and if payment is accepted it launch a small PLC siemens logo program. I need a manager interface to change the prices, the number of sales available for each product and the photo of the product. We will load at the beginning all the possible photos so no need to add photos in the user interface. I need to be able to access from a browser to basic informations (number of products available, last sales, temperature...)

I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.

I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and c...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm in need of a dedicated freelancer who can assist with cold calling local businesses. Your role will involve not only making these calls but also tracking the outcomes. If you're successful in this, there will be a continuous flow of work for you. Key Responsibilities:...outcomes achieved - Ensure the primary goal of each call is to increase sales Key Requirements: - Proven experience with cold calling and sales - Ability to effectively track and report call outcomes - Strong communication and negotiation skills - Self-motivated and results-driven - Experience with spreadsheet software for tracking I'm open to the freelancer using any industry for the cold calling. The primary aim is to boost sales via this campaign. All outcomes should be well-documented on a ...

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

...researcher who can delve into a provided spreadsheet of businesses for analysis. The data is varied and comprehensive, including but not limited to customer demographics, product descriptions, and pricing information. This is exclusively a RESEARCH project, and will take some time. Because of this I WILL ONLY PAY HOURLY. If you require a fixed price/contract, do not bid, I will not give you the job. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges based on the data This pr...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I need an experienced web scraping expert who can help me scrape relevant data from a specific website on a daily basis. Key Details: - I'm looking for data in text format including headlines, product descriptions, and any other relevant information available on the site. - There is no requirement for authentication to access the data, so the process should be straightforward. - The extraction needs to happen daily, so you should be able to set up a recurring scraping process. Skills and Experience: - Proficiency in web scraping tools and techniques. - Experience in extracting text data from websites and setting up automated daily scraping routines. - Good understanding of data formats and storage to deliver data in a usable format. ...