Vba csv jobs

The code requires refactoring to remove infinity in loop and condition to handle exception like row del etc. So I will update code according to this review.

I am looking for a freelancer who can help me with the computer system validation of a hardware device. Responsibilities:  Handling and monitoring QA Reviewer and CSV support team.  Monitoring execution of protocols, procedures, and policies to provide support for validation of computerized systems.  Assuring Regulatory Compliance, Understanding of risk based system validation approach.  Process excellence & understanding creations across levels.  Training facilitation of sessions i.e. CSV, QMS, DMS, 21 cfr, SDLC, ISO 9001:2015, GAMP-5, etc.  Analysis and Documentation related to Quality Management Systems (ISO 9001:2015).  Facing external audits, conducting internal audits and maintaining Regulatory compliance with Applicable guidelines.  Project Coordin...

I need a one-page website that effectively exhibits various types of data including text, numeric, and images. The information should auto-update from a pre-determined datasource. Visual display of the data may include tabl...including text, numeric, and images. The information should auto-update from a pre-determined datasource. Visual display of the data may include tables, graphs, or charts, although I will provide a sample page for exact visualization preferences. Successful candidates for the task should: - Have good understanding of frontend development and UI/UX - Be adept at handling data in various formats (Excel, CSV, etc.) - Show proficiency in automatic data updating Looking forward to bids from experienced freelancers interested in creating an interactive data-focuse...

I am looking for a freelancer who is proficient in scraping data from LinkedIn profiles. Since the specific information to be extracted wasn't defined, it should ideally cover basic profile information such as work experience, education, skills, and contact information. Ideal Candidate: Someone possessing sound knowledge in data scraping and familiar with ...skills, and contact information. Ideal Candidate: Someone possessing sound knowledge in data scraping and familiar with LinkedIn platform. Applicant Requirements: Despite not indicating the need for past work experience or detailed proposals, they would be appreciated and would strengthen your application. Data Delivery: The format for delivery of scraped data hasn't been specified, so options like CSV, Excel or JSO...

APPOINTMENT Automate the process of booking a Spain visa appointment at the BLS visa center in UK and China 1. Retrieving Gmail and SMS OTPs: Integrate the necessary APIs or utilize headless browser automation to retrieve Gmail and SMS OTPs automatically. This will enable th...detection, the bot will be able to handle such issues and ensure a smooth flow of the appointment booking process. 4. PHP Session Management: To handle PHP sessions, Implement cookie management techniques in the bot. By properly handling and maintaining session cookies, the bot will be able to maintain a consistent session state throughout the booking process. 5. detect open time and insert data from csv or xls file. web link for uk: web link for china:

I am looking for a skilled Excel expert who can help me automate my daily Excel tasks. The specific task that needs to be automated is data formatting. Requirements: - Proficiency in Excel macros and VBA programming - Experience in automating data formatting tasks - Familiarity with working with moderate data structures, including several data types and tables - Ability to follow a specific format or template for the macro The ideal candidate should have a strong attention to detail and the ability to deliver accurate and efficient solutions. They should also be able to suggest improvements or provide suggestions based on their expertise. If you have experience in automating data formatting tasks and are confident in your Excel skills, I look forward to hearing from you.

Expert VBA & VBA Form Developer Needed for Existing Form Modifications - Seeking an experienced VBA developer to modify an existing VBA form - Specific modifications required: enhancing functionality - Current issue with the form's functionality: not user-friendly - Desired timeline for modifications: one day Skills and Experience Required: - Expertise in VBA development and VBA form modification - Strong understanding of form functionality enhancement - Ability to improve user-friendliness of VBA forms - Efficient and timely completion of modifications within a short timeframe

Create a Power BI dashboard to analyze Azure costs using billing data. The dashboard should enable flexible cost analysis based on "env" and "app" tags, as well as filters for month/year, subscription, resource, and resource type. Project Steps Data Loading • Load Azure billing data from the appropriate data source. D...Resources Page • Create a page displaying resources within a defined time range in tabular form. • Add filters for "Tag env" and "Tag app." Resource Types Page • Create a page to explore cost analysis by resource type within a defined time range. • Include filters for "Tag env," "Tag app," and "Location." Key Requirements • Ensure interactivity within the dashboard. &bul...

1) Need to migrate Total hmi functions and graphic interface (GUI) 2) remote (.csv) file upload functionality 3) data loggin /report generation 4) bowl on/off function on home screen it self 5) auto on full screen on power up ( with no close option) data loggin (my sql/MS SQL) 1) data log for no of successful profile run/ force stopped with profile names /time stamps 2) data log of relay/motor trigger ( total numbers not related with profiles) 3) data log of errors 4) 100 steps data loggin as in hmi screen 5) auto export of temperature data also with recipe name and time stamp 6 seconds

...for an experienced data cleaning specialist to organize and clean CSV files exported from our CRM system, FreshChat. These files contain conversations between our agents (team members) and clients (students). The goal is to structure this data effectively for use in developing a machine learning bot. Responsibilities: Clean and organize approximately 100 CSV files exported from FreshChat. Extract and clearly define questions and answers from conversation logs. Structure the data in a machine learning-friendly format. Collaborate with our team to understand specific data requirements for the ML bot. Ensure data integrity and confidentiality. Requirements: Proven experience in data cleaning and organization, particularly with CSV files. Understanding of machine lea...

I need a solution that logs(or not) in to given web site (e-commerce web site) and crawls chosen content(products) in a CSV file. Showld be also downloaded the images of the products and in the CSV file to have properly addressed these images. This CSV file later will be used to import these products with their images, titles, prices etc .. to another e-commerce web site.

... Programming Language Preference: - I prefer the website to be developed using Python, PHP, or JavaScript. Please let me know which language you are most comfortable with and provide examples of your previous work in that language. Data Storage Preference: - I would like the data to be stored in an Excel format. Please let me know your preferred method of storing the data, whether it's using a CSV file, an Excel spreadsheet, or database integration. Fetch and Update Frequency: - The website should fetch and update the YouTube video views every 5 minutes. This means that the website should automatically retrieve the latest view count from YouTube every 5 minutes and update the data accordingly. Ideal Skills and Experience: - Proficiency in Python, PHP, or JavaScript, depen...

I am looking for a VBA expert who can refine and adapt existing code to automate repetitive tasks in Excel. The project needs to be completed within 1 week. Specific Requirements: - Refine and adapt existing VBA code to automate repetitive tasks in Excel - Ensure the code is efficient and error-free - Create custom user forms for improved user experience Ideal Skills and Experience: - Strong proficiency in VBA programming - Experience in automating tasks and data analysis in Excel - Ability to refine and optimize existing code - Knowledge of creating custom user forms If you are a skilled VBA developer with a proven track record of delivering high-quality and efficient solutions, I would love to hear from you.

...configuring the website using a provided WordPress template and integrating a suite of specified plugins. Scope of Work: Customize the provided WordPress template to align with our brand and specifications for selling US-Based B2B prospects and B2B data. Set up a system for monthly subscription management, including payment processing and customer account maintenance. Implement the WordPress Product CSV Import Suite for uploading and managing B2B leads database ( on the backend- will be using the Dreamhost SQL database). Configure and optimize provided WordPress plugins to ensure full functionality of lead generation and e-commerce features. Prepare the site structure for easy content upload by our team, with the flexibility to make content updates and expansions as needed. Ens...

I need Excel to call me on the phone when a certain condition is met. I don't know if it can be done with vba code or if an add-in is needed

We are looking for a statistician to analyse our data and create visual diagrams using data visualization tools. We also require the use of appropriate statistical tests to analyse the data. More details about the job can be found in the following link. Thank you for your consideration.

I have very little experience in VBA. I downloaded a file from a YouTube video (Excel for Freelancers) and have put together most of the work for an Inventory Management system on Excel. I keep getting some errors and cannot see what I have done wrong.

...Only the first response is valid. 3) Each user who responds will either gain or lose points depending on their answer. Before moving on to the next question, I need to be able to display the various rankings. Perhaps the simplest way is to export the results to a basic CSV file, save it on the server with a name like "1-1csv," and set up a page that processes the ranking through the CSV. We can create these pages beforehand, and they will be navigable from the website. So, for each question, we need to be able to export two CSV files: one for the question ranking and another for the overall ranking. The MOST CHALLENGING part for me is assigning scores based on response time. Before exporting the points, we could add a button to double or triple the sco...

I am in need of a skilled VBA expert who can assist me with automating Excel processes. I have a clear process flow that needs to be automated, and I am looking to have this completed within a short-term timeline of one month. Skills and Experience Required: - Proficiency in VBA programming - Strong knowledge of Excel functions and formulas - Experience in automating Excel processes - Attention to detail and ability to accurately analyze data - Ability to meet deadlines and work efficiently

...integrated with any existing databases or systems. The main goal of this project is to develop a custom application that meets my specific requirements. The ideal candidate should have experience in Visual FoxPro and be able to handle custom application development tasks. Task#1. a *.prg to sequentially read a vfp table. Storing data from recno(1) and updating recno(2). etc. Task#2. I have a wide csv file, 300 fields that I would like to build a table with. I don't have the time or need to identify all 300 fields initially. Looking for a way to dynamically load this data.. and at later date add fieldnames and attributes. ** If this is possilbe ** ? The timeline for completing this project is ASAP. I am looking for a developer who can start immediately and deliver the...

hi i want someone who can scrape website list of certain website type in csv file

I am looking for a freelancer who can scrape specific information from website...websites and convert it into CVs. The ideal candidate for this project should have the following skills and experience: - Expertise in web scraping and data extraction - Proficiency in converting scraped data into CSV files - Familiarity with scraping data from specific websites - Attention to detail to ensure accurate and complete information extraction - Ability to handle large amounts of data efficiently The project requires scraping names, addresses, phone numbers, and other relevant information from specific websites. The scraped data should be organized and converted into CSV files for easy access and analysis. If you have the necessary skills and experience for this project, please subm...

I am looking for a freelancer who can scrape text from a website and provide the data in CSV format. The project does not have a strict deadline, but it should be completed within 2-3 weeks. The URL of the website to scrape is - There is a total of 40539 posts There is a json to use, An example page with data, - All data on this page from "24hr Malmö AB" to "Bokslut: 2022-12" should be included in the final datafile, using columns for each of the datapoints. Requirements: - Experience in web scraping - Proficiency in data extraction from websites - Knowledge of CSV format and data manipulation - Attention to detail and accuracy in scraping the required information

I am looking for a freelancer who can help me set up approximately 1500 complex keywords on Google Alerts. These keywords are in boolean logic with AND, OR, and quotation marks. I have the list of keywords in a CSV file and I would like to explore if there is an automated way to set up these alerts using the CSV file. Ultimately this list will be refreshed every month so there needs to be a mechanism for this. Requirements: - Experience with Google Alerts and setting up complex keywords - Knowledge of automation and ability to create a script for future automation (if required) - Familiarity with programming languages, preferably Python or JavaScript, but any language will work If you have the skills and experience to assist with this project, please reach out to me.

We are looking for an experienced VBA developer to create a custom script for Microsoft Excel. The task involves analyzing a data set within a single column, which consists of approximately 800 rows of numerical values. Your goal is to write a VBA script that can efficiently identify and extract the highest and lowest numbers from the given range. Requirements: Proficient in VBA programming for Excel. Strong understanding of data manipulation and analysis. Ability to create efficient algorithms for identifying the highest and lowest values. Experience working with large datasets in Excel. Attention to detail to ensure accurate results. Clear communication skills to understand and implement any additional project specifications. Instructions: The data set is located ...

Project Description: Bill of materials (BOM) rearrangement using Python I need a skilled Python developer to help me rearrange the current format of my Bill of Materials (BOM) in CSV format to reflect a hierarchical structure. Current BOM Format: CSV Preferred Format: CSV The project needs to be completed as soon as possible. Ideal Skills and Experience: - Strong proficiency in Python - Experience working with CSV files and data manipulation - Familiarity with hierarchical data structures - Attention to detail and ability to accurately rearrange the BOM - Ability to work efficiently and meet tight deadlines

I am looking for a web scraping expert to help me gather racing results and information from one website. The ideal candidate should have experience in web scraping and be able to extract ...scraping expert to help me gather racing results and information from one website. The ideal candidate should have experience in web scraping and be able to extract specific data such as racing results and information from the website. The project needs to deliver a standalone tool that I can use on Win 11 to srape the website allowing me to input the desired date and return an Excel sheet (csv) with all the results for that date, with columns and data ordered and formatted. If Freelancers are interested, let me know and we can discuss, and, if appropraite, I can provide samples of what ...

I am looking for a Hivepress expert to help me upload 800k listings onto my Hivepress site from .csv files. Listing Upload Method: You can use the hivepress plugin I already have installed to upload the .csv listings. The issue is I dont know what the max limit is per bulk upload. Listing Details: - The listings in the .csv files contain full detailed information. Categories and Tags: - There are no specific categories or tags that need to be assigned to the listings. Ideal Skills and Experience: - Proficiency in Hivepress and experience with uploading large quantities of listings. - Knowledge of scripting and automation techniques. - Attention to detail to ensure accurate and complete listing uploads.

...PLUS user who can help me describe a series of illustrations. The illustrations are all related to a specific theme. I need the descriptions to be detailed, including emotions, symbolism, and context or historical references. Because chat gpt will mess up the file with the description this needs to be checked, this is very important... Descriptions need to look like this since I use them in a csv file format: Filename,"description" You need to select about 70 images from each episode. Let me know how many episodes you can do for you bid. Skills and experience required: - Proficiency in using CHATGPT PRO to generate accurate and detailed descriptions - Strong understanding of emotions, symbolism, and historical references in illustrations - Attention to detail to en...

I am looking for a freelancer who can assist me in migrating my MS Access database to RDS MS SQL. The current database size is less than 100MB. There are specific tables and relationships in the database that r...assist me in migrating my MS Access database to RDS MS SQL. The current database size is less than 100MB. There are specific tables and relationships in the database that require special attention during the migration process. However, I do not require assistance in creating the CSV upload file. Skills and experience required for this project: - Strong knowledge and experience in migrating MS Access databases to RDS MS SQL - Expertise in handling tables and relationships during the migration process - Familiarity with CSV upload files and their integration with MSS...

Title: WhatsApp Contact Information Scraping Description: I am looking for a freelancer to help me scrape my personal WhatsApp data. I specifically want to extract contact inf...have: - Experience in web scraping and data extraction - Proficiency in working with WhatsApp data - Familiarity with scraping tools and techniques - Strong knowledge of data formats, especially Excel or CSV Deliverables: - Scrape and extract contact information from my WhatsApp chats - Convert the extracted data into Excel or CSV format for easy analysis and manipulation Note: - The project is for personal use and not related to any business or enterprise. - Only contact information needs to be extracted, not chat messages or media files. - The final deliverable should be in Excel or CSV fo...

I am looking for a data analyst who can help me with competitor analysis for my e-commerce business. The ideal candidate should have experience in analyzing customer reviews,Inventory,Product variation from different co...analyzing customer reviews - Knowledge of e-commerce industry and competitor analysis - Attention to detail and ability to identify key insights from large datasets - I need python or Vb code to run myself. In future I will increase number of competiors and data frequency. -It would be good result gives different plots,Different KPIs and suggestion of best selling products based on my data. Sample csv data file is attached here. I have this type of data for particular interval. If you have the skills and experience necessary for this project, please submit your...

I am in need of a data analyst who can assist me with cleaning and preprocessing a medium-sized dataset (between 1GB and 10GB) in Excel/CSV format. The project will require approximately 4 hours of work. Skills and Experience: - Strong background in data analysis and processing - Proficiency in Excel and/or CSV file formats - Experience with data cleaning and preprocessing techniques - Familiarity with statistical analysis methods - Ability to visualize data in a clear and meaningful way If you have the necessary skills and experience, please submit your proposal.

VBA Macro Code Modification for Basic Excel Application Project Details: - I am looking for a VBA expert who can help me modify existing VBA macro code in Excel. - The task involves making changes to the basic level VBA code. - The VBA macro code is specifically for an Excel application. - The ideal freelancer should have strong knowledge and experience in VBA programming. - The freelancer should be proficient in Excel and have a good understanding of macros. - Attention to detail and the ability to understand and modify existing code is crucial for this project. - The freelancer should be able to work efficiently and deliver the modified code within the given timeframe. - Experience with debugging and troubleshooting VBA code is a plus. - ...

...in outside limit of a path ( > x meters ) which are given in another csv. so script will take 2 csv as input ..one which will be used to make a geometry and another to check if those points lying outside the geometry which is made by x meter enclosing bounds. I can explain in detail with example. I have seen that the same is a simple task But i want someone to help me provide a script quickly which i can execute on around 100+ files and get accurate results. I will be running this on a local system with decent configuration and not on cloud. Desired Output: I would like the script to call a function and generate a CSV file containing the coordinates of the point outside the polygon.

I am looking to hire VBA developers who can assist me with creating custom macros for a complex project with many steps. The ideal candidate should have experience in automating Excel functions and debugging and troubleshooting existing VBA code. The project has a tight deadline and needs to be completed within a week.

Project Description: We are seeking a skilled individual to fix a Python script. The code has previously been developed, but due to recent changes in the website's API, it requires necessary adjustments. This code scrapes the latest job postings from a specific job website. It goes through the website, collects information about the jobs listed there, and saves this information to a CSV. It also keeps track of which jobs it has already found, so it doesn't repeat the same ones. Skills and Experience Required: – Proficiency in Python programming. – Proven expertise in web scraping techniques. Please feel free to ask any questions or seek further clarifications about this task. Budget: $50

I am looking for a freelancer who can create a FB Groups Data Extractor for me. The specific information I need extracted from the Facebook groups is member names and email addresses. I would like the data delivered in a CSV file format. Additionally, I would like the data to be cleaned and refined, with sorting and removal of duplicates. Ideal Skills and Experience: - Experience with web scraping and data extraction from Facebook groups - Proficiency in working with CSV files - Strong attention to detail to ensure accurate data sorting and duplicate removal

Need an Expert VBA Developer who understands Office Scripts. We have several automation projects that we need to work on using VBA, but then transition them to Office Scripts. We need to work in the UK based shift and the person should be available during the UK hours. 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have knowledge of Office Scripts 4. Candidate should have problem-solving and leadership skills

I am looking for a skilled VBA developer to help me with a project. The goal is to extract specific text data from a Word file and organize it in a specific format in Excel using a VBA macro. Requirements: - Proficiency in VBA programming - Experience with extracting text data from Word files - Ability to organize data in Excel based on a specific format Key Details: - The project requires extracting text data only from the Word file. - The extracted data needs to be organized in a specific format in Excel. - The macro should be set to run automatically. I need a very simple and understandable code which a VBA beginner level person can understand. Creating a Macro code that will bring the comments from the attached word document into the excel attached for ...

Provide the VBA code in an Excel sheet to control an excel graph: => Manual inputs to the VB code in an Excel form: -Range of rows to graph: ex if I enter 250-1240 only row from 250 to 1240 will appear on the graph with horizontal axis showing values from 250 to 1240. -Graph all columns checked: list with checkboxes of all columns within the table. The columns being checked are graphed on the Y-axis. Check all/ none button available. The X-axis column is always the "Index" column. -Additionally to those being checked, graph all columns whose header in row 1 contains a given string. Ex: if "2251" is manually entered in the form, graph columns in the table whose header contains "2251" (4 columns). Multiple strings can be entered (separated with com...

create a simple mobile app using react native (i have dotcom and hosting already) , signup using manual email and gmail API, login. profile setting : full name , light/dark mode, birth date , domicile and Indonesian ID card number (manual input by user) all profile must According to Indonesian ID card. Profile setting (burger menu) from dashboard I can create, and remove and put banners on...: full name , light/dark mode, birth date , domicile and Indonesian ID card number (manual input by user) all profile must According to Indonesian ID card. Profile setting (burger menu) from dashboard I can create, and remove and put banners on the polling page (only 1 page). Polling choices can be image too not only text all polling result and users recorded in hosting database or better a .cs...

READ CAREFULLY! Hello, need Excel VBA script which will transfer these data from PDF TO EXCEL: - Invoice number - Invoice date - VAT CODE - Invoice amout The invoice format may be different, there is like 10-20 different sellers invoice templates, need to recognize all of them, attaching last month invoices to check. Invoices: As one freelancer told, this is possible and i want sript work like this: "Tool will do automatically, you just need to Brower and import pdf file folder where all pdf files are saved" If you can't do it, please do not bid!

I have a business critical VB.NET written by me that needs to be modified. Currently it reads and writes ticket info to Zendesk via API as well as application data to/from local CSV files. It looks like we imminently need it to be updated to work with the ticket module from HaloPSA (via API as well). As a second, optional task, I'd also like it to be converted to using a hosted SQL database instead of CSV files... At this stage I'm really looking for the cheapest option to get the new functionality, so I'm really looking for someone to modify the existing code. The main reason I'm after the cheapest option now is that in 5-6 months we might well look to redevelop the app as a web application, or we might look to extend the desktop app functionality - bu...

...Title: VBA Debug Description: I am currently experiencing a logic error in my VBA code for an Excel application. I am looking for a skilled professional who can help me debug and resolve this issue. Specific requirements: - Proficiency in VBA programming and experience with Excel applications - Strong problem-solving skills to identify and fix logic errors in the code - Ability to work with sample data sets provided by the client for testing and debugging purposes Ideal skills and experience: - In-depth knowledge of VBA syntax and debugging techniques - Familiarity with Excel functions and formulas - Experience in troubleshooting and resolving logic errors in VBA code - Strong attention to detail and ability to effectively communicate and collabora...

I am looking for a Python developer to help me convert image files (in pdf) to CSV using the Pandas or any other library in python. The ideal candidate for this project should have experience with image processing and data manipulation using Python. Requirements: - Convert image files to CSV using Python and Pandas - align columns with numbers and text - Ensure accurate and reliable data extraction from the images - Handle different image formats and sizes - Optimize the code for efficiency and speed Skills and Experience: - Proficient in Python and familiar with the Pandas library - Strong knowledge of image processing techniques - Experience with data manipulation and extraction - Attention to detail and ability to handle complex data structures Because the data will be...

I am looking for an experienced VBA programmer to assist me with my Program Office project. The main tasks for this project include automation of processes and report generation. Skills and Experience: - Strong proficiency in VBA programming - Experience in data analysis and process automation - Knowledge of generating reports using VBA scripts The project will involve modifying existing VBA scripts as well as developing new scripts from scratch. Timeline: The project has a moderate timeline of 1-2 weeks, so it is important that the freelancer can work efficiently and deliver within the specified timeframe. If you have the necessary skills and experience in VBA programming and can meet the project requirements within the given timeline, please subm...

I am looking for a freelancer who can create Excel macros to automate data extraction from an application to an Excel file. Specific tasks that need to be automat...freelancer who can create Excel macros to automate data extraction from an application to an Excel file. Specific tasks that need to be automated include data entry, data analysis, and report generation. I have a sample file that the macros should be applied to. The timeline for this project is within a week. Ideal skills and experience for the job include: - Proficiency in Excel macros and VBA programming - Experience in data extraction and automation - Attention to detail and accuracy in data entry and analysis If you have the necessary skills and can deliver within the specified timeline, please submit your...

I am looking for a VBA expert to help me with a project involving a database saved on major ask it that the tool should display the data from database to User-Form and the project requires the following functionalities: - View, Edit, and Update the database. The VBA project needs to be compatible with Access 2013 or later. Ideal skills and experience for the job include: - Proficiency in VBA - Experience working with databases - Knowledge of Sharepoint - Familiarity with Access 2013 or later.

I possess a ChatGPT 3.5 Turbo API account and am seeking to develop a user-friendly desktop application utilizing this API. The application will include a button for importing multiple prompts, with each corresponding to a cell in the "Input" column of a CSV file. The CSV file is organized with three columns labeled "Code," "Input," and "Output," serving as the primary data source. As the bot processes the prompts, it dynamically updates the "Output" column in the same CSV file with the corresponding results. Additionally, the application will provide real-time information on the percentage of completion and the number of prompts processed out of the total input prompts. Could you please provide an estimate of the devel...