Excel vba query spreadsheet jobs

I am in need of a Tableau expert to develop a project that visualizes our employee hierarchy and access levels. The project should include the following: 1. A "Top Office" table that encompasses all higher management i...them; supervisors and managers can see their respective employees; and employees can only see their immediate boss. 3. Access control settings that allow for 'Editable for specific roles'. This means that only designated individuals can edit certain parts of the project. Data for this project will be sourced from Excel spreadsheets. It is critical that the freelancer has profound experience with Tableau and is able to create a comprehensive and clear visualization. Familiarity with Excel and understanding of hierarchical structures in a ...

Subject: Requirement for Advanced Freight Management Excel Dashboard Dear I hope this message finds you well. I am looking for an advanced Excel solution for our freight forwarding operations. Below are the specific requirements: 1. Data Entry Form: A user-friendly dashboard to enter shipment details, such as: Arrival and departure times. HBL and CFS manifest details. Railing status, delivery order status. BL (Telex/Original) status. Each shipment should create a unique job number automatically. 2. Centralized Database: All data should be stored in a master Excel sheet, capturing all shipment details. 3. Search and Filter Functionality: Ability to search by job number, BL number, or other fields. Upon searching, display all related details for the sp...

I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.

...OF WHAT I NEED, THIS INFORMATION MUST BE ACCURATE. I HAVE LOST A LOT OF MONEY WASTING MY TIME ON PEOPLE WHO CAN NOT PRODUCE WHAT I NEED.. I AM DOING MORTGAGE FORECLOSURE EXCESS PROCEEDS THIS WILL BE A PERMANENT POSITION WITH ADDED BONUSES. I AM A NEW COMPANY AND NEED AN HONEST HARD WORKER TO RODUCE WHAT I NEED, I NEED SOMEONE THAT IS WILLING TO GROW WITH MY COMPANY AND ME. I WILL NEED AN EXCEL SPREADSHEET WITH THIS INFORMATION, I AM WILLING TO WORK WITH ANYONE WHO CAN DO THE JOB I AM CURRENTLY LOOKING FOR MORTGAGE FORECLOSURES AND 3RD SALE TAX LIENS THAT HAVE BEEN SOLD WITH IN THE LAST 90 DAYS, THEY MUST BE TWO SEPERATE LIST OR LABELED. I NEED THE FOLLOWING INFORMATION, DATE OF FORECLOSURE OR TAX LIEN SALE FORECLOSURE ADDRESS OWNERS NAME EMAIL ADDRESSES PHONE NUMBERS OPEN...

I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail

I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling

I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.

... Email Creatives: - Creating engaging visuals and layouts for email campaigns. - Ensuring designs align with brand identity and resonate with our target audience. E-commerce Listings: - Assisting in creating and updating product listings with optimized visuals. - Ensuring images and descriptions are consistent across platforms (e.g., WooCommerce, eBay, and Google Shopping). Requirements: To excel in this role, you’ll need: - Proficiency in Photoshop or similar design tools. - A strong portfolio showcasing creative design skills, particularly in e-commerce or digital marketing. - Familiarity with social media ad design best practices (especially Facebook/Instagram). - Experience with e-commerce platforms (WooCommerce, eBay) is a plus. - Excellent attention to detail and t...

I'm seeking a freelancer with robust XLS and data analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to i...analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to identify trends in customer satisfaction. - Pinpoint the most common complaints from the feedback. - Extract suggestions for improvement from the customer feedback. - Create a compelling and clear presentation from the analysis. Ideal Skills: - Proficient in Excel for data analysis. - Experienced in creating presentations in PowerPoint. - Strong analytical skills to interpret customer feedback data. - Ability to present data in a clear and e...

I'm in need of a skilled developer to scrape phone numbers from www.yellowpages.com.au. The data should be categorized into Plumbers, Electricians, HVAC companies, Roofers, and other trades. Key Requirements: - Delivering the data in an Excel spreadsheet - Including the Company name and Website URL along with the phone numbers - Formatting the phone numbers in International format for easy dialing Ideal Skills: - Proficient in web scraping and data collection - Experienced in using Excel for data organization - Knowledgeable in categorizing trade-related companies

I am in need of an experienced Excel specialist who can create a financial modeling matrix for me. The matrix should be capable of performing ROI calculations and Net Present Value (NPV) calculations. Ideal skills and experience for the job: - Proficiency in Excel, particularly in creating complex models - Experience in financial modeling - Ability to incorporate specific financial formulas into the matrix - Understanding of ROI and NPV calculations. I WILL PAY $30 TO FULLY COMPLETE MY MATRIX AFTER YOU SUCCEED THE FIRST STAGE PLUS A BONUS WHEN I GET PERSONAL GUARANTEE PLUS UNLIMITED REVISIONS

I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. I am attempting to create and fill a WORD template by completing a form in Microsoft Lists....am attempting to create and fill a WORD template by completing a form in Microsoft Lists. The form must then be changed to a PDF and emailed. I am presently using a Plumsail action but would like to get rid of it. One of the flows is the same as previously stated but fills an Excel template instead. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and recti...

I am seeking a professional query letter writer with experience in the fiction and fantasy genre. My manuscript targets adult readers and is ready for submission to literary agents. - Ideal Skills: Exceptional writing, understanding of query letters, knowledge of the fantasy genre, experience with adult fiction - Requirements: A well-crafted query letter that showcases the manuscript's appeal to agents and its potential in the market.

I am seeking a professional query letter writer with experience in the fiction and fantasy genre. My manuscript targets adult readers and is ready for submission to literary agents. - Ideal Skills: Exceptional writing, understanding of query letters, knowledge of the fantasy genre, experience with adult fiction - Requirements: A well-crafted query letter that showcases the manuscript's appeal to agents and its potential in the market.

I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

Found the Selected Data from One Excel file on the Other File. Both files are provided for reference. "Scores" sheet, find the same song on the

I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of employee shifts.

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.

...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple table - The project is in E...

I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.

Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and cata...looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research an...

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

I'm seeking an expert to help with my spreadsheet. The project involves formula adjustments and formatting changes, specifically applying conditional formatting. The ideal freelancer should be adept at adding new formulas and fixing existing ones.

I have a project to be completed in Financial Modelling througn excel.

I'm looking for a professional to create a detailed business expense report for me. The report should be in a spreadsheet format, specifically Excel or Google Sheets. I have the spreadsheet template already and need help entering the data and attaching the receipts. Key Requirements: -Enter the receipt data, vendor, amount, location and distance from 4314 Airport Blvd, austin tx. Need the receipts copied then attached or attached in some way. - The spreadsheet should be well-organized by month, easy to navigate, and ready to submit for approval. Ideal Skills: - Strong proficiency in Excel or Google Sheets. - Excellent attention to detail. - Previous experience with creating business expense reports. Please provide examples of similar projects yo...

I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.

I'm seeking an expert to assist with converting my Excel tables and data into HTML. This project will also require the conversion of my Excel charts and graphs into static images for HTML display. Skills needed: - Proficient in Excel and HTML - Experience in data conversion - Ability to create static images from Excel charts and graphs - Attention to detail to ensure all tables and data are accurately converted

I'm seeking a web developer to create a small-scale HR management system. The application should allow the addition of new employees, inc...mark their own attendance. - Salary Management: The system should allow employees to download their salary slips. - Data Upload: There should be an option to upload employee data in bulk via Excel. - Email Integration: The system should be configured to send offer letters through Gmail. Ideal Skills: - Web Development: Proficiency in creating interactive and user-friendly web applications. - HR Software Knowledge: Prior experience with HR management systems would be beneficial. - Email Service Integration: Experience with Gmail's API for automated email sending. - Data Handling: Skills in setting up Excel data uploads for large...

I am looking for a skilled Python or JS developer with expertise in web scraping, Selenium, and HTML parsing to enhance and complete a job scraping tool for the Adzuna job portal. Project Goals: code must fetch all job listings from Adzuna for a given search query URL (e.g., ). Handle cases where JSON-LD data is missing by falling back to HTML parsing to extract all relevant details. Current Issues: my code scrapes some job data (titles, descriptions, company names, etc.), but many fields remain blank. Not all job listings are fetched; the script currently stops at ~157 jobs out of ~410 listed. Fallback HTML parsing is insufficient, leaving many fields incomplete. Requirements: Comprehensive Data Extraction: Fetch all job listings from

I'm a beginner in Power Queries, seeking a tutor to guide me through data transformation and merging queries. Together, we'll improve an existing Excel file for better data organization. Sessions will be over Zoom, which will be recorded for future reference. Ideal skills and experience include: - Proficiency in Excel, particularly Power Queries - Prior experience in online tutoring or teaching - Ability to simplify complex concepts - Strong communication skills - Patience and understanding towards beginners

I need assistance with manual data entry of customer information I receive via emails. Requirements: - Proficient in data entry - Able to handle and convert data from emails into Excel - Detailed-oriented - Able to maintain confidentiality

I'm seeking a professional who can assist with extracting performance data of Brazilian investment funds from the Refinitiv platform. The data should be specifically focused on performance indicators and delivered in Excel format. Key Requirements: - Access to the Refinitiv platform - Ability to extract performance data of Brazilian investment funds - Proficiency in Excel for data delivery - Capability to perform this task on a yearly basis The ideal freelancer for this project would have experience with data extraction from financial platforms, particularly Refinitiv. Understanding of investment fund performance metrics is a plus. Please bid only if you have access to the required platform and can deliver the data as specified.

I am seeking a seasoned Ruby on Rails (ROR) developer with a minimum of 4 years of experience, specifically with Rails 4/5. The ideal candidate will have a strong sense of ownership, a can-do attitude, and a collaborative spirit. You will be working closely with designers, product managers, and other software developers to deliver compe...within ROR. - Experience with system architecture and efficiency. - Strong drive, ownership, and team-oriented mindset. - Proficient in standard CS fundamentals (data structures, algorithms, complexity analysis). - Strong English proficiency. - Systematic debugging and problem-solving skills. The application will need to pull data from various sources including databases, external APIs, and CSV/Excel files. Your expertise in ROR is crucial for thi...

I need help configuring New Relic on my Linux server. The New Relic PHP agent is already installed, but I need help with monitoring MySQL and Apache. Key monitoring tasks: - MySQL: Performance metrics, Query analysis, Error tracking - Apache: General health and performance - Php performance data, average response time, max execution time in peaks, peaks of memory usage and how much memory is used then. - response data from third party applications monitored. Ideal candidates for this project should have extensive experience with New Relic, Linux servers, PHP, MySQL, and Apache. The ability to analyze and interpret performance data is essential.

Scope involves creating a web applica...Web Application Features: User Input Form: Allow users to select or input: Event Type: Birthday, Anniversary, Graduation, etc. Recipient Details: Relationship (Mother, Father, etc.), Age, Interests (e.g., books, gadgets). Gift Preferences: Gift category (e.g., Electronics, Fashion). Gift style (e.g., Modern, Classic). Price range. Amazon Product Search Integration: Use the provided user data to query Amazon's API for relevant product suggestions. Retrieve and display products on the web application, including: Product name. Image. Price. Affiliate link for purchasing. Product Display: A clean and intuitive UI to showcase the recommended products Prerequisite Third party Amazon API for the affiliate link on every product will be provide...

I'm in need of a Zoho Books professional who can assist with the setup and configuration of Zoho Books, specifically focusing on data import and migration, as well as customization and integrations. Key Requirements: - Importing large Excel files containing product information into Zoho Books - Customizing and integrating Zoho Books to suit my business needs - Initial setup and configuration of Zoho Books Ideal Skills and Experience: - Extensive experience with Zoho Books - Proficiency in data import from Excel to Zoho Books - Ability to customize and integrate Zoho Books - Previous experience in setting up Zoho Books

I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data

Hello, I a...Documentation on: o The project structure o The installation and deployment process o The API endpoints used 3. Assistance with the initial deployment to the Play Store and App Store (optional). ?️ Required Skills: • Expertise in React Native (native components, navigation, AsyncStorage, etc.). • In-depth knowledge of Laravel and REST APIs. • Experience with Axios, React Navigation, Redux, or React Query. • Experience in deploying mobile applications on Android and iOS stores. ? Estimated Duration: I am open to suggestions regarding the time required to complete this project. Please provide me with a time estimate. ? Budget: Please include your budget proposal for this mission. I am willing to discuss it based on your experience and the quality o...

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.

Hi i created a quote for this project

I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.

...telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....

Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo