Search excel file vbscriptcông việc

I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of utmost pr...

I'm looking for an experienced SEO professional to take my website, which ...already on Google's first page, to the next level. My goal is to improve ranking for several keywords, including those related to products, my location, and services offered. Key responsibilities: - Formulate and execute strategies to optimize keywords - Perform ongoing keyword discovery and optimization Ideal candidate will possess: - Proven SEO experience - Knowledge of ranking factors and search engine algorithms - Up-to-date with the latest trends in SEO I must stress that I've previously implemented SEO strategies. I'm not just looking for an improvement in ranking, but a sustainable SEO strategy that ensures continuous top page ranking. Your expertise in creating such strategie...

I'm looking for an individual proficient in data entry, email management, online research, and making phone calls. Your daily tasks will primarily involve: - Performing data entry tasks using Microsoft Excel - Managing email communications effectively and promptly - Conducting online research as required - Making certain phone calls when necessary -Schedule is 9am-3pm CST (Monday-Friday) In addition, experience with project management software 'Click Up' will be highly favored. A strong work ethic, attention to detail, and excellent communication skills are fundamental for this role. The selected candidate will be expected to perform these tasks on a daily basis. Your ability to meet deadlines and work independently will contribute significantly to the smooth operat...

I need a excel data sheet typist frequent in basic as well as skillful skills. There's no error in the formats and also professionally done with great effort.

Hey! I have experties on statistical analysis.

We are looking for a freelancer to scrape product information from Website and organize it in an Excel spreadsheet. Key Requirements: - The script should extract all text content and images displayed on the homepage need be add to excel file

...constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are added and finally sent to the customer. A second Excel file must also be created for production so that they know which parts are required for construction. 7. Synchronise article and customer master data between Majesty and Odoo. Majesty can only export the data using an Excel file and has no API. 8. Design customisation so that configurations that have already been made are collapsed, so that the page...

IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracker Employee Attendance Tracker and Payroll Exce...

Read a JML/JSON (see the example) file created by Selenium IDE and save it into an Access Database (.mdb) Requirements: 1) The application is a Windows desktop application 2) Development language: C# .NET latest version 3) The application will be called ImportBotJob 4) The application must include all of the components to run on a PC without Office installed.

I'm looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. - Strong communication skills and a proactive approach to project management. I'...

I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel: The freelancer should have excellent skills in using Excel for data cleaning...

In need of a detailed-oriented freelancer for an alphanumeric data entry ...freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entry position will be...

I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you find are high quality and in either JPG or SVG formats. Your work will be integral in the c...

I'm looking for a skilled expert experienced in Quickbooks and Wordpress development. The tasks needed are: - Integration of Quickbooks Stocks with my WordPress site - Displaying real-time stock qty. on the site - Allowing users to search for stock information on the site The integration should be performed seamlessly without affecting the site's current functions. Although the design style was not specified, it should be user-friendly and intuitive. Ideal candidates should have prior experience in Quickbooks and WordPress integration.

I'm looking for a PowerBI expert to set up a dashboard for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - Resource Allocation: Demonstrating how resources a...

I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.

We are looking to collect the current prices for 5 specific procedures from local clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up on the caller ID. Start immediately. Pay is $250. Do not bid higher, as we will not...

I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.

I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.

I require a proficient CAD designer to craft a stl file from provided images for my 3D printing project. I have exact dimensions that need to be adhered to, ensuring it aligns perfectly with my plans. Specifically, the project will involve: - Transforming 2D images into a 3D stl file - Utilizing exact measures given for the 3D model Ideal skills and experience: - Proficiency in CAD design and 3D modelling - Experience in creating stl files for 3D printing - Excellent attention to detail Please note, I can validate the 3D printability of the final stl file myself, so this will not be part of the task.

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. I...

...three-pronged job involving: 1. Entering Contact Information: You will input a myriad of contact details into an Excel spreadsheet. Accuracy is paramount. 2. Updating Databases: You'll be responsible for ensuring that all existing data is up-to-date. If a discrepancy is noticed, you will correct it. 3. Transcribing Documents: Transcription services are required. You need to accurately transcribe information from diverse documents. In addition to the aforementioned tasks, this job involves email verification for all entries; without exception. Needless to say, your keen attention to detail would be required to spot and correct any errors. The ideal candidate would have past experience with Excel spreadsheets, database management, and transcription. Excellent typing ...

...analysis. Achieve monthly targets of 150 salons signed and 3,000 app downloads to qualify for performance bonuses. Provide real-time geolocation updates during field movements. Candidate Requirements: Minimum 2 years of experience in B2B sales, preferably within the beauty, wellness, or tech industries. Strong understanding of sales strategies and customer relationship management. Proficient in Excel and capable of managing basic sales data analysis. Exceptional communication and interpersonal skills. Ability to commit to BookBook's unique brand and sales approaches. Must be organized, self-motivated, and capable of working under pressure to meet sales targets. Compensation and Incentives: Monthly salary of £2,000 after taxes. Promising £4,000 compensation follow...

I'm seeking an expert to revise an annual financial model for a Saas Startup. The successful bidder will be tasked with modifying revenue projections, adjusting expense figures and adding new financial metrics. The final version of the model should be delivered as an Excel spreadsheet. This project requires deep knowledge of financial analysis, Excel forecasting tools and financial metrics. Familiarity with financial models and proven track record in creating or modifying them is essential.

...can boost the SEO and performance of my Shopify store. Emphasis is mainly on: I'm in need of a well-versed Shopify SEO expert who can focus on driving more traffic to my website. Your core tasks will be centered around elevating my store's organic visibility through comprehensive SEO for all elements, including - on page SEO, off page SEO, site mapping, product SEO, collection SEO, and Google search console. Ideal skills and experience include: - Expertise in Shopify SEO - Strong background in content creation and distribution - Proven ability to drive increased site traffic - Experience prioritizing products for SEO enhancement Prioritising my best sellers, I am excited to collaborate on this targeted approach to increasing traffic to my site. Successful freelance...

I urgently require a skilled SEO expert for my website. - Proficiency in SEO and Google's ranking system

...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...

Estoy buscando un asistente virtual y administrativo para realizar las siguientes actividades operativas en un negocio: Revisar y agregar datos en documentos de Excel. Elaborar reportes en Excel. Gestionar la agenda de proyectos. Revisar y agregar tareas de proyectos en el calendario. Redactar minutas y resúmenes de juntas. Establecer prioridades de actividades. Registrar datos generales como facturas, órdenes y proveedores en el sistema ERP. Crear manuales de procedimientos en Word. Herramientas de manejo: Excel a nivel avanzado. Loop o Notion. Conocimiento de los procesos de un ERP. OneDrive (administración y manejo de archivos). OneNote y Word.

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

...developer to launch a Usenet search engine website. This is a unique opportunity for someone with hands-on experience in building secure, efficient and user-friendly search platforms. Here's a snapshot of what's on my wish list: Skills and experience: - Knowledge of HTML (as stated, but ideally also Python, JavaScript or PHP). - In-depth knowledge of NNTP (Network News Transfer Protocol) - Good track record of creating well-documented, bug-free code - Ability to implement basic security measures to protect user data Project specifics: - Search engine is already functional, only improvements and a few customizations will be needed - Changes and adjustments are needed in the admin area, e.g. editing newsgroups and adjusting retention - A simple API for the...

I need a website that effectively represents my plumbing services online. Essential features include:...I’m looking for a freelancer with the following skills and experience: - **Web Development**: Experience in creating websites from scratch, particularly for service-based businesses. - **Booking System Integration**: Expertise in incorporating booking platforms. - **Web Design**: Strong aesthetic sense tailored to professional services. - **SEO**: Knowledge of SEO best practices to ensure local search visibility. - **Communication**: Open and effective communicator for clear understanding of project needs. This project is ideal for a freelancer who can create a compact yet comprehensive online presence, which showcases my plumbing services and simplifies the appointment-bo...

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me ...

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project is to ob...

...schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a comprehensive Excel spreadsheet that includes the name and address of each school, along with their exact distance from the nearest Tube sta...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I'm looking for an expert in ISO file creation specifically for Raspberry Pi. The task involves creating an ISO file that I can burn onto a microSD card. You will just send me the completed iso file. You'll need to refer to instructions from the following link: The process should be followed meticulously to ensure the ISO will work perfectly with my Raspberry Pi. The ideal candidate should have: - Proficiency in ISO file creation - Experience with Raspberry Pi projects - Familiarity with Windows operating system Please note that I should be able to burn this iso to microsd card, pop it into my Raspberry Pi, and see it up and running. The login info for the accounts that need to be created will also be sent to me.

I'm looking for a skilled developer with experience in Docker, NGINX and security protocols to bolster the security of my API backend. Key Requirements: - Implement Firewall Protection: I need a firewall setup around my Docker file and NGINX like WAF to prevent unauthorized access and malicious activities. - Malware Detection: An efficient malware detection mechanism needs to be integrated to scan for and eliminate threats within my setup. - DDoS Prevention: The implementation should include tools and configurations to mitigate risks related to DDoS attacks. Specific OWASP Top 10 Concerns: - Injection: I'm concerned about potential vulnerabilities that could lead to code or data injection attacks. - Cross-Site Scripting (XSS): The setup must effectively protect against ...

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

...seeking treatment abroad, I'm in need of a professional to create a comprehensive website. Key Requirements: - The website will offer multiple file upload functionality. This feature is crucial for applicants, enabling them to securely submit their medical files and records. - The primary target audience for the website will be individuals seeking medical treatment abroad. User Interface: The user interface should be designed to be simple and user-friendly. The goal is to create a seamless, intuitive experience for patients and applicants as they navigate the site. Ideal Freelancer: - Prior experience in developing websites with multiple file upload functionality is key. - Understanding of the healthcare industry, particularly in the context of medical tourism,...

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.