Search data csv excel vbaงาน

I need assistance with filtering data based on date ranges within SQL queries for a database that uses a DD-MM-YYYY format. The ideal candidate would possess: - Proficiency in writing and debugging SQL queries - Experience with implementing conditions in SQL queries - Strong understanding of date formatting and how to filter data based on a given date range. Deliverable: I have an excel sheet extracted from sql server I need a query to have the punch in and punch out on the same row note sometimes the punch in and punch out is not in the same date

Buscamos un Especialista en Excel con experiencia comprobada en la creación de paneles o cuadros de mando. Desarrollará paneles de control que proporcionen información clave sobre diversas áreas de gestión de la empresa, incluyendo producción, productividad, compras, stock, contabilidad, ventas y más. Crear tablas dinámicas, gráficos y KPIs que proporcionen una visión clara y precisa del desempeño de cada área. Requisitos: Experiencia demostrable en la creación de dashboards y cuadros de mando utilizando Excel. Profundo conocimiento de funciones avanzadas de Excel, incluyendo tablas dinámicas, gráficos, macros, y fórmulas complejas. Habilidad para interpretar...

I am looking for passionate and experienced Excel experts who can optimize my Excel Gantt Planner (Calculette Rollout v13 - ) through several adjustments: Formatting Improvements: - **Color Coding:** Implement my provided color palette to create a more visually intuitive and aesthetically pleasing spreadsheet. - **Macros corrections** - **Calendar translation** >>>>>> I need what is in the PPTX file that is attached with the project <<<<<<<< Any ideas, improvements are welcome. + There is another Excel table (Suivi ) and I need a nice looking GANTT planner to be added to it (Project 2 Gantt ). Please DO NOT CONTACT ME to ask for more money than the budget I can afford.

I'm seeking an experienced data visualisation expert for the creation of an interactive D3.js project. Key Requirements: - Prior expertise in creating visuals from numerical data. - Strong proficiency in D3.js for advanced - may need to do data manipulation ising excel or python to get the data tonthe right format for visualisation (not simple bar or pie charts alone) - visualisation to be used in website - Proven skill in creating interactive data visualisations. I am aiming for these visualizations to be very interactive, allowing viewers to engage with the data in a dynamic way. The successful freelancer would ideally present a portfolio evidencing similar past projects. Working closely together, let's make data exci...

I am in search of a detail-oriented freelancer proficient in data entry. The project entails the following: - Inputting data for cooking, baking, and beverage recipes into online forms. - Error-checking and validating all entered data. - Ensuring all forms are filled out completely, following established procedures. Ideal experiences and skills include: - Proficiency in data entry and form filling - Familiarity with culinary terms and recipe formats - Strong attention to detail - Exceptional organizational skills. This project is perfect for individuals who are familiar with various types of recipes and have proven data entry skills.

Ich benötige jemanden, der mir eine Umfrage in Limesurvey erstellt. Die Fragen sollen sich auf das Interesse an Schulungen bezieh...eingefügt werden, kein Transfer von anderen Formaten notwendig. - Es soll dieses Typeform möglichst 1:1 übernommen werden und auch das Look & Feel gleich sein. → <> - Die Teilnehmer sollen nach Absenden der Umfrage eine E-Mail mit allen Antworten bekommen. (Buchungsbestätigung) - Die Schulungsorganisation soll eine Email mit allen Antworten bekommen. - Eine Excel-Liste mit allen Anmeldungen soll zum Download bereitgestellt werden aus Limesurvey Bitte stellen Sie sicher, dass Sie mit Limesurvey vertraut sind und eine ansprechende und logisch strukturierte Umfrage erstellen können. Ich freue mich auf Ihre Vor...

I'm seeking a skilled developer to create a web-based NGO membership software with a mix of pre-made templates and custom design. Functionality is key, and the software needs to easily handle: • Member and staff registration and login • Import and Export Membership with CSV/Excel format • Features for alerts via email and mobile SMS • Payment management • Comprehensive communication tools • Leads and member follow-up capabilities • Appointments and call management • Document management for customers • Creation and dispatch of quotations & invoices • Expense tracking • Staff management features • In depth accounting reports • Catalog or service management features • Features for alerts via email ...

I'm currently working on a book project that features 50 newspaper articles I've written. To ensure my work's credibility, accuracy, and ensure no copyright issues, I need assistance in ...assistance in tracing back the original source of each article. Key tasks will include: - Determining the original source of every article - Verifying the accuracy of the information in the articles - Identifying the newspaper title, publication date, and the URL of each original publication All the gathered information must be recorded in an Excel workbook. Experience in data research, data entry works, and strong proficiency with Excel would be crucial for this project. Knowledge of journalism, media law, and an understanding of copyright law would be ...

I am in search of a freelancer skilled in multiple aspects of digital marketing for a B2C project. The chosen professional must have in-depth knowledge and experience in the following areas: - Social media management: Mainly Facebook and Instagram. This will involve creating engaging content, growing and monitoring our social communities, and implementing strategies to increase brand presence. - Search Engine Optimization (SEO): The task would include everything from keyword research and link building to competition analysis to enhance our website's visibility on search engines. - Google Ads campaign: The freelancer will have to manage our Ad campaign, choosing the right strategies and carefully tracking performance for constant optimization. As the focus is ...

...green screen and the translated word + audio pronunciation. The flashcard should appear in greater and greater intervals (more and more rarely) as they answer correctly. If they answer wrong, the card appears again in the same session (due cards). This algorithm for spaced repetition is very important - Users are integrated with the Wordpress users they already have - I need to be able to import a csv file with two columns (English word and translation) and they have to be able to be sorted in different decks that are linked to lessons. And I need to be able to view a list where I can upload image and audio file for each. EDIT: Actually we should use Dall-E API to generate all the images. And use ChatGPT API to come up with a prompt first for an image that fits the word - It shou...

I'm seeking a talented individual with strong data entry skills to digitize contact information from 125 business cards into an Excel spreadsheet immediately. Details: - Data to be entered includes: ENTER THESE FIELDS BUSINESS FIRST NAME LAST NAME POSITION PHONE CELL PHONE FAX EMAIL WEBSITE ADDRESS CITY STATE ZIP CODE Ideal Skills: - A keen eye for detail as accuracy is paramount - Prior experience with data entry projects - Proficiency in Excel - Excellent time management skills to ensure prompt project completion Note: Only bid if you can start immediately. I'm on a tight deadline and need this task completed posthaste.

I'm looking for an expert in Microsoft and Visual Basic for Applications (VBA) to streamline my repetitive financial data entry tasks. Key Tasks: - Develop a VBA script to automate the entry of financial transactions Ideal Profile: - Proficiency in programming with Microsoft and VBA - Previous experience in automating data entry, preferably financial transactions - Strong attention to detail to ensure accuracy in data entry automation - Basic understanding of financial transactions for effective development of the automation system The successful freelancer will create a simplified and efficient data entry process that eliminates the manual input of financial transactions. Attention to detail, speed, and efficiency are vitally impor...

...(multiple linear regression) to predict startup profits (). The following steps should be done and need to be explain the code using # comments 1. Read the dataset from the csv file and put input data in X and output data in Y. 2. Deal with missing and categorical data (Data cleansing, even if there are no missing data) . 3. Divide data into four subsets (X_training, Y_training, X_test, and Y_test). 4. Train the learning model using (Linear regression algorithm) 5. Make a list of predictions Y_pred and compare it with Y_test. Explain what do you remark? 6. Make a prediction for a given data sample. 7. Without using "predefined functions" Find the following: 7.1. Total deviation of the regression line 7.2. The equatio...

I am looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.

Necesito a alguien que sepa bien de fórmulas de excel para hacer una planilla que cuente con: - Porcentajes automáticos - Checkboxes Trabajo a realizar HOY. Si no tienes disponibilidad para comenzar de inmediato por favor no ofertes. Presupuesto $10

I'm seeking a skilled Excel specialist to develop an efficient reporting system derived from our Core Banking System. Key Responsibilities: - Enable data extraction, both manual and automatic, for maximum flexibility. - Integrate fundamentals like Financial and Regulatory reports. - Incorporate functionality for Ad hoc reports based on unique user requirements. - Ensure the system is adept to update the aforementioned data on a daily basis. The freelancer best suited for this task will have exceptional skills in Excel, and experience developing similar banking or financial reporting systems. Appreciation for detail and understanding of financial and regulatory protocols are also desired.

I am in search of a skilled sales officer to join our team at Yes Bank, specifically within the credit card department. The ideal candidate will be responsible for: - Lead Generation: Creating a robust pipeline of potential customers. - Customer Acquisition: Successfully onboarding new clients to our credit card services. - Sales Target Achievement: Meeting and surpassing outlined sales targets regularly. The perfect fit for this role is an individual with the following qualifications and experience: - Sales Experience: Proven track record in a sales environment. - Excellent Communication Skills: Ability to engage effectively with potential customers. - Microsoft Excel: Proficient in using Excel for data management and reporting purposes. This role offers the...

...can offer a fresh angle on common topics. • Always think on a new angle / approach to attack the keywords subject, by using use data, graphs, synthesis data and key takeaways, focus on Quality. • Engage with my Audience; Make a Recognizable Impact, Ensure my content makes a noticeable difference in my audience's knowledge or experience. • Cite my Sources Properly: When using information, facts, quotes, or ideas from others, citing my sources not only ensures originality but also adds credibility to my content • Article will need to pass Ai originality test and score above 70% Human. • Keep the low quality content out, Craft the articles for people, not the search engine. 1. Expository Writing: Providing informative content, explanatio...

I need an expert typist to input assorted data - text, numbers, and dates - into a multi-columned Excel sheet. Key Tasks: - Manually enter a vast amount of structured data, extending over 50 columns and rows - Ensure accuracy as the consistent structure should be maintained across all filled cells Ideal Candidate: - Proven experience with high-volume Excel projects - Exceptional attention to detail for accuracy - Ability to follow a strict data structure - Familiarity with varied data types - specifically text, numbers, and dates.

As a growing brand in the cosmetics market, I need a striking packaging design that appeals to a universal audience. My products are not confined to any particular age group, thus the design should be attractive to teens, adults, and seniors alike. The scope of this project is the packaging design only. A design brief will be provided upon project commencement. To excel in this job, you should ideally have: - Proficiency in Adobe Creative Suite, especially Illustrator and Photoshop. - Prior experience in packaging design, specifically for cosmetics. - An understanding of global trends and demographics. - A knack for creating designs that are both trend-forward and timeless. Your portfolio should demonstrate your versatility and ability to design for a contemporary, universal au...

I'm in need of a prof...The intended features of the plugin include: - Create a dedicated database to store Gravity Form field data. - The ability to export and import the stored data in CSV format. - Adding a new form by importing CSV files. - Updating field data through a CSV import. - Storing a 'Number with Calculation' field specifically in the separate database. - Storing all field in the separate database. Moreover, the plugin should be able to perform addition calculations on the number field. Ideal candidates should have proven experience in WordPress plugin creation and management, a good understanding of database architecture and be familiar with Gravity Form Plugin operation. Experience with handling CSV file form...

I'm currently confronted with damaging search results - appearing on the first page of google that I'd like to relegate to the third page or beyond. Despite identifying the detrimental search terms, I haven't yet employed any strategies or techniques to achieve this. I am seeking a specialist with a strong grounding in: • Search Engine Optimization techniques • Online reputation management • Content creation and marketing The objective is to douse the damaging search result's visibility and regain control over my online reputation. So, experience in this domain is crucial.

scrape data from autotrader using python and export it into csv file

...can create any offline service with dynamic form so admin can create unlimited service IT service- 1. Website design (Show portfolio) 2. Graphics 3. Google reviews 4. Social media handling 5. Android/ios app 6. Facebook / instagram like increase Wallet: 1- Recharge (with payment gateway / offline method) 2- Transition Reports 1. Download all reports (excel/pdf) Commission Phase 3- Developer Mode 1. Developer add any new page or change menu 2. Add new graphics 3. Add training videos 4. Update script to latest version if changes anything 5. Server status 6. Change theme color 7. Change Google AdSense 8. Change any users password 9. Google analytics/ webmaster add 10. Download backup automatic daily or manual Announcement role 1. Add ...

...Generate engaging Articles, text, video (with subtitles and voiceovers), and image content. - Perform automatic content posting (with editing option before distribution) My objective it to: 1. Create a blog Article/post on my site though: A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a 900 -1300 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) ✔Check point 1 : Option to edit the article (on wordpress), after article approval: the article will be uploaded to the site, then we will go to: 2. Create Social media Text posts f...

I am in need of a skilled Joomla developer to implement a custom component/module that will search through all of the content of my website's pages - including the homepage. The site has been built on Joomla 4 with SP Page Builder. Key Requirements: * The search function must be able to index and search for specific content elements - namely, page titles, embedded images, and all text content. * The search results must be displayed in a clearly organized grid view. The results should not only show relevant page titles but also the associated images and a snippet of text content. * All pages on the website, including the homepage, should be included in the search functionality. Ideal experience and skills involve knowledge in Joomla development, p...

Hi Sophia B., Please go over Excel and make sure that English and Ukrainian are attached. SLA is Tuesday, March 19th. Thank you, G

I am looking for a professional who can efficiently extract and copy all information from an Airtable sheet to Excel. Key responsibilities: - Copy/Extract all data from the Airtable sheet: - Copy data to Excel without any modifications

I'm in search of an expert research writer. Though the specific topic was not indicated, an experienced freelancer capable of creating high-quality content on various subjects within science, history, or literature is highly desired. Key Requirements: - Proven research writing experience in either Science, History, or Literature - Excellent writing and editing skills in English - Ability to meet deadlines Kindly include your experiences and expertise in research writing when sending your proposals. Looking forward to working with you.

I'm in need of professional assistance to create a 12 months sales projection forecast excel spreadsheet for my events management business. I'm particularly interested in a comprehensive understanding of the industry trends impacting these forecasts. Ideal candidates for this job would have: - Previous experience in building forecast sheets in events management industry - A deep understanding of industry trends Your task will include: - Analyzing my forecasted sales data - Highlighting key industry trends - Providing detailed findings which relate these trends with sales forecasts. Please note your experience with events management and data analysis in your bid!

I am in need of a proficient Excel Expert for data filtering and formatting. You must exhibit exceptional skills in the mentioned areas: - Filtering: Your role will include filtering my data sheets as per specific conditions. Mastery in this area is a must. - Formatting: I need my numbers formatted in a general fashion for proper import. Therefore, a comprehensive understanding of number formatting is necessary. This project requires advanced working knowledge of Excel and a meticulous eye for detail. For successful completion, you need to display exceptional proficiency in Excel's data filtering and a deep understanding of general number formatting.

I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.

More details: What type of data sources will the dashboard and analytics be based on? Database, CSV files, API endpoints, Telecom signaling feed like ss7, diameter, gtp, volte, 5G Which telecom signaling feeds would you like to integrate into the dashboard and analytics? SS7 (Signaling System 7), Diameter, GTP (GPRS Tunneling Protocol); VoLTE (Voice over LTE); 5G, Http2 What specific metrics or data points would you like to track and analyze from the telecom signaling feeds? Call setup success rate, Message latency, Network congestion; Protocol errors; Signal strength, Signaling performance and tracing, AI based user interface to fetch and populate dynamic dashboards and reports based on customer needs

Work requirement is to work on excel files to get DCF working

I am in urgent need to improve my company's online reputation in Google search in two locations: Hyderabad and Jaipur. I want to elevate my company's presence by ensuring our website is listed prominently. Tentative tasks required are: - Search engine optimization (SEO) to magnify our visibility in the targeted cities - Tracking and implementation of proper keywords - Detailed monitoring of progress and adjustments if required Ideal candidates should include: - Extensive SEO expertise, particularly with Google search - Experience in online reputation management - Demonstrated ability to effectively increase web traffic The project should start immediately and we need to see substantial results as soon as possible. Therefore, only those who can invest a g...

I have a text document consisting of raw data that I urgently need converted into a CSV file format. The fields to be populated from the text document into the CSV file consist of 'Field name,' 'apiName,' and 'Description.' Ideal Skills and Experience: - Proven experience in manipulating and converting data file formats - Proficiency in parsing information from different file formats - Ability to work at a fast pace while maintaining accuracy and attention to detail. Please be aware that I require this project to be completed as soon as possible.

This project is about creating a professional yet creative business profile (information memorandum) for a business brokerage, powered by an easily updatable Excel back-end. I'm looking for someone with strong document design and spreadsheet expertise. At the moment we have the attached document that is both out of date (design wise) and requires 100% data input from staff. I am wanting a document that answers can be imported directly from excel. The generated profile will be about 20-25 pages long and include approximately 60 distinct data fields, these fields will be collected from each client and answers stored in an excel sheet. The idea being - we need a beautiful document that can have easily duplicated merge fields. - Company name and sum...

Looking for a virtual assistant to utilize the GoHighLevel Social Planner to schedule a month's worth of content, on a monthly basis. Your tasks will include the following: - Filling out a CSV template that we'll provide - Scheduling content according to the template - Ensuring all content is correctly and timely dispatched Ideally, you have experience with GoHighLevel's platform and a keen eye for detail, since you'll be handling a great deal of information. A background in administration would be useful too. Efficiency and accuracy are key, so your time-management skills will also be crucial.

I'm seeking a talented graduate graphic designer capable of creating an appealing, bright, and colorful...And for version two upload it to a standard free media player so subscribers can get it into email. This needs to be print ready and i need fast turn around with few if any back and forth questioning. - Strong grasp on modern design principles and decisiveness - Ability to translate both informal and professional tones visually - Ability to engage with a young, professional demographic To excel in this task, ideally you will have: - Prior experience in designing for print media especially newspapers - Ability to deliver innovative and playful layouts minimalistically - Fluency in Adobe Creative Suite or similar tools I look forward to seeing your fresh, dynamic, and ...

I need an expert to modify my existing Excel spreadsheet and transform it into a fillable PDF form. The interactive form will contain a description field, checkboxes, date field, price fields, perhaps one calculation but that isn't necessary. I have attached a sample of the excel file. There may be a few changes. Does this sound like something you can do? Here's what I'm looking for: - Ideal Skills: Extensive experience with Excel and PDF form creation is a must. - Experience working with custom fonts and graphics that will need to be duplicated onto the form -Experience: Please include any previous work involving the conversion of an Excel file into a fillable PDF form. Please note that the data that needs to be captured in the fo...

Looking for a professional financial analyst adept in scrutinizing balance sheets. - Your primary task will be financial statement analysis, specifically focusing on the balance sheet. - Proficiency with Excel spreadsheets is crucial as all data will be provided in this format. Ideal Skills: - Comprehensive knowledge of financial statement analysis - Expertise in Excel - Proven experience in financial analysis, particularly balance sheets. The perfect freelancer will have a keen eye for detail and the ability to draw insights from financial data. Budget is 50$

I'm seeking an experienced mobile app developer to build a Flutter ap...application that mimics the functionalities of the Airlines Wego application. The goal is to deliver an application that offers users the ability to search for flights. Key App Functionality: • Allow users to search flights by date and time. Enhanced Search Results: • The search results should include filtering and sorting options, specifically; - Ability to filter flights by the latest arrival time. - Enable sorting flight results by the duration of the flight. Skills and Experiences: • Extensive experience in Flutter development. • Proven track record in creating flight search functionalities. • Ability to implement advanced search f...

I need assistance in creating a VLookup formula in Excel to fetch matching data from another worksheet. Having already identified the columns, the formula should be designed to fetch data from the specified columns. Freelancers with extensive experience in Excel formulas and in particular, the creation of VLookup functions, are highly preferred. Knowledge, skill, and proficiency in Excel spreadsheet manipulation are essential.

Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet

I require a tool or script that can effectively convert my checking account bank statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter shoul...

I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.

I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.

I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.

I am in need of an expert who can effectively import complex Excel sheets into MS PSA Project Service for a more consolidated and efficient approach to data management. Key Deliverables: 1. Importation of Excel Sheets: - This includes financial data, project tasks, and resource allocation. Your experience in managing and handling these types of data is crucial. 2. Data Structure: - I require all Excel sheets to be consolidated into a single worksheet. Your knowledge in navigating MS PSA Project Services and Excel will be important to ensure that the data will be structured correctly and in a user-friendly way. 3. Permissions: - Every group should have full control over the project's MS PSA, including viewing, editing...

I am searching for exceptional talent to create a dynamic crypto website to develop a Decentralized Application (Dapp) that operates ...dynamic crypto website to develop a Decentralized Application (Dapp) that operates on a Content Management System (CMS) intended for the general public. My vision for this powerful Dapp is to incorporate an Artificial Intelligence (AI) driven search prompt engine. This will serve to enhance user interaction and improve the overall efficiency of the CMS. Ideal Skills & Experience: • Proficient in Python • Dapp Development • CMS Integration • AI Search Optimization The ideal candidate should understand how to integrate the smart contract and secure data storage features tied to our Dapp, with an emphasis on u...