Vba grabs data excel file jobber

I need an Excel sheet to track my child support payments. The primary data points to monitor include payment amounts and dates. Additionally, I need the sheet to calculate and summarize total payments received, as well as providing a monthly and yearly summary. Ideal skills for this project include: - Proficiency in Excel - Ability to create complex formulas - Experience with data tracking and summarization The formatting of the sheet should be in a standard table format, without the need for any color coding or custom headers and footers.

I'm looking for an expert in data visualization to help me code some line charts in my existing spreadsheet. Key Requirements: - Create line charts from existing sheet data. - Implement a dual data selection system: some data will be chosen automatically based on predefined rules, while other data will be manually selected by the user. - Ensure that the charts are complex enough to accurately represent the data while still being user-friendly. Ideal Skills: - Advanced Excel or Google Sheets skills. - Strong coding knowledge, particularly in spreadsheet programming languages. - Experience with data visualization and creating complex charts. - Ability to understand and implement predefined rules for data selection.

I need a freelancer to help me with two tasks. Part 1: I need a complete list of email contacts from a local government website. The data needs to be organized in an Excel spreadsheet, including the names, titles, email addresses and contact numbers (where available). Part 2: Using a provided email address, you will send out 50 emails daily until the entire list is exhausted. Ideal Skills: - Proficiency in data entry and Excel - Experience with email marketing - Attention to detail - Ability to follow instructions precisely Please note, I expect the number of emails to exceed 1000.

I'm looking for a Virtual Assistant who is eager to learn and doesn't need to have any prior experience. This role will primarily focus on organizing files for a medical company, creating documents in Excel or Google Docs/Google Sheets, and assisting with various tasks. Key Responsibilities: - Organizing files categorically - Creating reports, spreadsheets, and presentations Ideal Candidates Will: - Have a basic understanding of Excel and Google Docs/Google Sheets - Be willing to learn and take initiative - Have strong organizational skills

I'm looking for an experienced web scraper to gather data on pendants from the Jewelry Unlimited website. The data should include: - Title and description of the pendants - Price and availability - Images The data should be delivered in an Excel file, categorized by type (e.g., religious, miscellaneous). Ideal Skills: - Proficient in web scraping - Excellent data categorization abilities - Familiarity with Excel Experience with e-commerce data scraping is a plus. Please provide a sample of your previous work if available.

I'm looking for an expert in data visualization to help me code some line charts in my existing spreadsheet. Key Requirements: - Create line charts from existing sheet data. - Implement a dual data selection system: some data will be chosen automatically based on predefined rules, while other data will be manually selected by the user. - Ensure that the charts are complex enough to accurately represent the data while still being user-friendly. Ideal Skills: - Advanced Excel or Google Sheets skills. - Strong coding knowledge, particularly in spreadsheet programming languages. - Experience with data visualization and creating complex charts. - Ability to understand and implement predefined rules for data selection.

Power BI presentation and source file as sent

...a Windows-compatible web app to automate data entry and web scraping. Key Responsibilities: - Design an interface for data input - Automate data filling into specified fields on the given webpages - Scrape the resulting data into an Excel file (XLSX format) - Ensure subsequent searches add to the database, overwriting previous similar entries Webpages to be used: - - - Data for testing: - ID type: Company - UEN: 614H - Vehicle number: XD9577M - Date: today The ideal candidate should have: - Extensive experience with web scraping and data automation - Proficiency in creating Windows-compatible

See chat for instructions

I'm in need of a proficient data entry specialist, who can handle mixed data types (both text and numerical) from online databases. Key Responsibilities: - Source and collect mixed data from various online databases - Accurately input the data into an Excel spreadsheet Ideal Skills and Experience: - Proficient in Excel and data entry - Experience with online data sourcing - Attention to detail and accuracy

I am encountering an iOS build error in my project related to the gRPC-C++ module. The error specifically states: module map file '/black_portal/ios/Pods/Headers/Private/grpc/' not found This issue appears to be related to CocoaPods and the gRPC library integration in the iOS project. The developer will need to debug and resolve this issue to ensure that the project builds successfully on iOS. Scope of Work: 1. Debugging the Issue: Analyze the Podfile and Pod dependencies for potential misconfigurations. Check the installation and configuration of gRPC-C++ in the project. 2. Resolving the Problem: Fix the missing issue by either regenerating the module map or correctly linking the library. Ensure that the Pods are properly integrated and build without

I'm looking to purchase detailed data from all seasons of US Shark Tank. The data should include full texts of conversations between entrepreneurs and investors, as well as all other relevant variables. The ideal format for this data is Excel or CSV files. Key Requirements: - Full transcripts of all Shark Tank discussions - All other pertinent data points from the show - Data delivered in Excel/CSV format Skills and Experience: - Proficiency in data collection and analysis - Familiarity with Shark Tank and understanding of its data - Ability to organize and present data in Excel/CSV files

I'm seeking an experienced data analyst or Excel expert to set up a Weekly Sales and Stock Intake (WSSI) model in Excel. Key Requirements: - The WSSI should incorporate sales data, stock levels, and purchase orders - The model should facilitate data import from CSV files - Prior experience with WSSI or similar forecasting models is highly preferred - Strong Excel skills are mandatory, knowledge of data visualization tools is a plus. Please provide examples of similar projects you have completed in your proposal.

I'm looking for a professional with advanced Excel skills, particularly in using Pivot Tables. I have a dataset related to our sales and I need someone who can analyze this data and generate insights on our monthly sales trends. Ideal Skills: - Extensive experience with Excel, particularly Pivot Tables - Proficiency in data analysis - Ability to derive insights from complex data sets Please provide a quote and a brief overview of your relevant experience. Thank you!

I'm seeking an expert in data mining and lead generation to find email contacts of Purchase Managers of companies ( I have data of the companies in excel format) Requirements : - 1) I have a ready list of name of companies ( 236 entries) 2) Find out email of purchase managers or generic email id from their website or other place on google and make a list of the email ids. The successful freelancer will have the opportunity for ongoing work as I expand my outreach efforts.

I'm in need of cyclone to merge the file. to make the 3d Revit If you have the experience, please reach out. Skills and experience required: - Proficiency in Cyclone 9.4 - Experience with data processing, model creation and project setup (preferred) - Ability to provide clear, concise assistance

I'm looking for an Excel expert to create a complex, formula-driven data entry sheet for our production line planning. Key Requirements: - The sheet should primarily assist in production scheduling. - It must be able to take into account machine availability as a key data input. The machine availability will be tracked through manual entry, so the sheet needs to be user-friendly and intuitive for this purpose. Ideal skills include: - Advanced Excel skills, particularly in creating complex formulas. - Experience in production planning. - Ability to design user-friendly interfaces in Excel. This project will greatly enhance our production efficiency, so I am keen to work with someone with a proven track record in similar projects.

I'm in need of a skilled professional who can assist with extensive Excel data entry and analysis. Key tasks will include: - Data cleaning and organizing: Sorting through large sets of data to ensure accuracy and completeness. - Formulas and calculations: Applying appropriate formulas and performing calculations as necessary. - Creating charts and graphs: Visualizing data in a clear and concise manner. Ideal candidates should have significant experience with Excel, particularly in data entry, cleaning, and analysis. Proficiency in using complex formulas, as well as creating informative charts and graphs, is crucial.

I'm in need of an accountant who can extract specific transaction details from my bank statements and organize them into an Excel spreadsheet. The information is primarily for personal tracking and budgeting. Ideal Skills and Experience: - Proficiency in financial analysis - Experience with bank statement reviews - Excellent Excel skills - Attention to detail Specific Requirements: - The extracted data should only include the transaction descriptions.

I need 4 PDFs containing bank transaction data converted into 4 Excel sheets. All records should be intact and transactions should be structured properly in a standard table format. The Excel sheets should have the same columns as the PDFs. Ideal skills for this job include: - Proficiency in Excel - Experience with data conversion from PDF to Excel - Attention to detail to ensure all records are intact

I need an ASP.NET website that integrates with a database. This site will allow users to log in and upload documents (such as PDFs and Word files), ...documents (such as PDFs and Word files), with functionalities for viewing and deleting their uploaded files. Key Features: - User authentication via a username and password system - Two roles: Administrator and Standard User - File upload, view, delete functionalities - Ability to categorize uploads by section and type of work It is essential that I receive the complete source code along with the deployed website. The ideal candidate should have strong skills in ASP.NET, database management, and user authentication systems, with prior experience in creating similar file management websites. Public view without login as well a...

I have a simple project where I have a labor planning tool that is used for manufacturing tools to collect data and plan their next years labor. See the attached excel file. I would like to use some AI prompts to evalaute the historical data entered and then populate the data input cells on the right side of the excel sheet instead of them being manual entires like they currently are.

I'm looking for a reliable freelancer to help me with a data entry project for 600 clinics. The task involves entering specific contact details into an Excel spreadsheet. Data Entry Requirements: - Inputting the phone numbers and email addresses of the clinics. Ideal Skills: - Proficiency in Excel - Attention to detail - Previous data entry experience - Ability to maintain confidentiality and handle sensitive information responsibly. I expect the work to be done accurately and within a reasonable timeframe. Please include your estimated time for completion in your bid.

I'm in need of a professional letterhead for my company, E & CO GROUP PTY LTD. This letterhead will primarily be used for formal business communication, so it needs to convey a sense of professionalism and corporate identity. Key...communication, so it needs to convey a sense of professionalism and corporate identity. Key Requirements: - Use of the company logo and colours - Inclusion of the company address and contact details, as well as the company tagline and logo - Layout featuring a header and footer Final Deliverables: - The letterhead formatted in both a Word document and an Excel file, both set to A4 size Ideal Skills: - Graphic design - Proficiency in Microsoft Word and Excel - Experience in corporate branding Please provide examples of similar w...

I'm looking for a skilled Excel expert to create a single, dynamic Excel sheet for tracking my inventory counts on a weekly basis. The sheet should update automatically based on the values I input for each week. Key Features Required: - The data should be displayed in tables - The tables should include detailed line items, not just summaries Ideal Skills: - Proficient in Excel, including knowledge of dynamic functions and table creation - Prior experience with inventory tracking Excel sheets would be a plus - Able to create clear and easy-to-understand tables

I'm looking for a professional with expertise in data extraction and analysis, particularly from Ahrefs. You need to have an Ahrefs enterprise access. Please mention when submitting proposal that you possess Ahrefs enterprise access. Key Requirements: - Monthly extraction of organic traffic data and keyword analysis for a specific website. - Data should be organized and delivered in an Excel spreadsheet. Ideal Skills: - Proficiency in using Ahrefs. - Strong data analysis skills. - Excellent spreadsheet skills. Please ensure your bid reflects your understanding of the task and your capability to deliver high-quality work.

I need a skilled 3D modeler who can convert a mechanical part into a 3D STL file for 3D printing. Key Requirements: - Proficient in 3D modeling software - Able to understand and translate mechanical parts into 3D models - Experience in creating STL files for 3D printers I have exact measurements for the part, and they are in inches. Please reach out if you have the expertise to assist with this project.

I'm in need of an Excel macro that can compare two separate Excel sheets. The macro should highlight the differences in the various data sets. Ideal freelancers for this project should have extensive experience with Excel and be proficient in writing macros. Please provide examples of similar work you've done in the past.

I need a comprehensive Excel database of Insurance Brokers in Victoria and South Australia who sell Cyber Insurance. - The database should include: - Company names - Websites - Addresses - Contact persons (specifically those handling cyber insurance) - LinkedIn profiles of the contacts, if possible - Your search methodology should include: - Public business directories - LinkedIn - Industry-specific websites Skills and experience ideal for this project: - Proficiency in Excel - Experience in data research and web scraping - Familiarity with the insurance industry, particularly cyber insurance, is a plus.

I have a CSV spreadsheet containing a couple of hundred companies. I need additional information for each company, specifically the NAICS Code, Phone Number, and Address. The primary source for this information will be the respective company websites. Ideal Skills: - Proficient in data collection and web scraping - Excellent attention to detail - Familiarity with NAICS codes Experience: - Previous experience in data enhancement projects - Experience with working on Excel and CSV files Please provide your quote for this project.

I'm seeking an experienced professional to assist me with design presentations, specifically creating slides, visual layout and design, and integrating renderings and elevations. You must be proficient with Excel, Canva, Revit, CAD, Sketchup, and SmartDraw. Your main responsibilities will include: - Assisting with design presentations - Create CAD and 3D Renderings - Creating visually appealing and professional presentations Experience in interior design and the use of the specified software is a plus. You should have a keen eye for detail, strong organizational skills, and the ability to work under deadlines.

Busco un componente para una página web que permita mostrar en pantalla completa un archivo .dwg (plano 3d) precargado y que sobre él se tengan 2 modos de trabajo: *Edición* - Tipo un editor CAD, además de poder navegar en el plano precargado con las herramientas típicas de CAD (rotación, zoom, etc), se pueden colocar marcadores (imagen, gif, punto de referencia para texto dinámico) en cualquier punto del plano y con el tamaño y orientación deseada; mismos que pueden guardarse generando un nuevo .dwg quedando actualizado para el modo Visualización. *Visualización* - Tipo un visor CAD, solo se permite la navegación en el plano con las herramientas típicas de CAD (rotación, zoom, etc) en la qu...

Vennligst Registrer deg eller Logg inn for å se detaljer.

I need an IT expert to help support our organization's information and communication, spe...expert to help support our organization's information and communication, specifically with our social media campaigns. The ideal candidate should have experience with: - Setting up and managing IT communication systems (like email systems, internal chat, and video conferencing tools) - Developing and executing social media campaigns - Stakeholder engagement through IT communication - Data Modeling and excel sheet analysis. - PowerPoint short presentations. Please note, while I primarily require support for social media campaigns, the ability to bolster internal communication and awareness is also key. The chosen freelancer will help enhance our IT communication and support...

I need the attached map with all lines and shapes as open and editable vector file. Text is not required. The map needs to be 100% accurate.

I'm seeking a proficient freelancer for daily data entry and management of financial transactions. The data will need to be organized and maintained in Excel spreadsheets. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of managing financial data Requirements: - Daily updates - Keeping track of financial transactions in a timely manner Experience: - Previous experience with financial data entry and management is preferred.

Necesito poder modelas un sistema que me automatice la recopilacion de precios de las paginas de internet de las marcas de vehiculos, las organice en un excel y pueda mostrarme tendencias y gráficos sobre las variaciones de los precios. Ojala guardando récord de la historia y la evolución de estos en el tiempo.

I'm in need of cyclone to merge the file. to make the 3d Revit If you have the experience, please reach out. Skills and experience required: - Proficiency in Cyclone 9.4 - Experience with data processing, model creation and project setup (preferred) - Ability to provide clear, concise assistance

Trabajo inmediato. Necesito un administrador de comunidad para administrar las redes sociales durante el horario de publicación en (España), puedes programarlo. Sus funciones mensuales serán las siguientes: Planificación de contenido para: -16 historias mensuales aprox. -12 publicaciones mensuales. - Informes mensuales de Metricool. Es esencial conocer Excel, ya que ahí es donde se llevará a cabo la estrategia de marketing y se desarrollará el contenido. También deben tener un buen conocimiento de Canva, tenemos una cuenta Pro para que puedan usarla. Y conoce a Metricool para emitir informes. Trabajo a largo plazo. Deben comentar sobre la propuesta si son especialistas en esto y aquellos que conocen el marketing digita...

I am in need of an experienced Excel professional to assist in creating a spreadsheet for a court exhibit. Ideal skills for this project include: - Proficiency in Excel, particularly in document creation. - Experience in creating spreadsheets for legal purposes or court exhibits. - Attention to detail and ability to ensure the document is accurate and presentable. The project entails: - Using Excel to create a spreadsheet that will serve as an exhibit in court. - Ensuring the spreadsheet is clear, concise, and suitable for presentation in a court setting.

I need a straightforward edit in my Acrobat Illustrator file. One specific word in the body text needs to be changed to a new word or phrase. Requirements: - Change one word in the body text - Replace it with a specified word or phrase - Maintain the original font style Ideal Skills: - Proficiency in Adobe Illustrator - Attention to detail - Experience with Acrobat Please note, it's essential to keep the font style the same as the original text. The job is simple and should not take much time. I'm looking forward to your bids.

I have a PDF file that I need converted into a vector and AI file for print materials. This task is strictly about conversion, no adjustments or enhancements are needed. Ideal skills for this job include: - Proficiency in Adobe Illustrator - Experience in vector file creation - Understanding of print material specifications. Please only bid if you can guarantee high-quality, print-ready files.

I'm seeking an Excel expert for comprehensive statistical data analysis. The primary focus will be on descriptive statistics. Your role will involve: - Using Excel to conduct various statistical analyses - Interpreting and summarizing the data effectively Ideal skills and experience for the job include a strong proficiency in Excel, experience with statistical analysis, and the ability to communicate findings clearly.

...expert in Excel to enhance my existing spreadsheet for railway locomotive comparison and assist with some data entry. Task 1: Spreadsheet Enhancement - Modify the current spreadsheet to allow for the comparison of multiple locomotive classes within one graph. - This will involve creating new drop down selections for the graphs, which currently only illustrate one class. Task 2: Data Entry - I will provide photographs of historical datasets which need to be transcribed into an additional tab on the spreadsheet. - The data points to be compared include both the mileages and the availability of the locomotives. Ideal Skills: - Excel expertise, especially in graph creation and data manipulation. - Attention to detail for accurate data tran...

I hope you're doing well. My name is HARSH, and I am proficient in Excel with intermediate-level skills. I am currently looking for part-time freelance opportunities and would love to offer my expertise to help with your Excel-related tasks. Here are some of the services I can provide: Data Entry: Accurate data entry and organization. Data Analysis: Analyzing data using pivot tables, formulas, and charts. Reporting: Creating custom reports and dashboards in Excel. Automation: Automating repetitive tasks using Excel macros and VBA. I am dedicated to delivering high-quality results efficiently and on time. If you need assistance with any Excel-related tasks, I would be happy to help. I look forward to the opport...

I'm in need of a tailored Excel calculator designed to assess the net profit/loss of my fleet of cars. This tool should accommodate varying levels of vehicle utilisation, weekly income and finance costs. Key Features: - The calculator should factor in lease payments as the primary finance cost. - Weekly revenue calculations should be influenced by rent duration and service charges. - Please ensure it's user-friendly and intuitive so I can easily interpret the data. Ideal Skills: - Advanced Excel proficiency. - Previous experience with financial modelling. - Understanding of vehicle rental economics would be a plus. Will provide a full list of all fixed costs and variable costs.

I need a Talend expert to develop a reject logic for my JSON files. This will involve both schema and content validation. The freelancer will be responsible for setting up a system where any files that fail validation are rejected and quarantined. Key requirements: - Both schema and content validation of JSON files - Quarantine files that are missing...will be responsible for setting up a system where any files that fail validation are rejected and quarantined. Key requirements: - Both schema and content validation of JSON files - Quarantine files that are missing required fields, have invalid field values, or structural errors Ideal skills: - Proficient in Talend 7 / higher - Strong understanding of JSON files and data validation - Experience with error logging and file q...

I have a mixed-data Excel file currently organized in a single column. The data is partially structured but predominantly scattered. My goal is to have the data neatly organized into three distinct columns: dates, descriptions, and amounts. Key requirements: - You should have a good understanding of Excel and its functions. - You must be able to interpret and manipulate mixed data types. - Experience in data cleaning and structuring is highly desirable. - Attention to detail is crucial as the dates are in a non-standard format. - Ability to provide a clear, structured output from initially random data. Ultimately, I need this project to result in a tidy, useful Excel file that I can use for further analysis.

Project - Clean the data, identify and analyze issues, and create the required dashboard. For missing values and outliers, calculate the yield as the weighted average of the past 5 days. Objective: Use the provided dataset containing daily yield data for 100 fish types over September and October 2024 to create a dashboard. Requirements: Dropdown for Fish Type: Create a dropdown menu to select a specific fish type from the list of 100 types. Dropdown for Date: Create a dropdown menu to select a specific date within the range of September 1, 2024, to October 31, 2024. Task 1: Display the corresponding yield value based on the selected fish type and date. i.e if Fish type Dropdown = Fish_1 and Date Dropdown = 2024-09-06 then output should be 36 Task 2: Add a chart that dynami...

I need a professional who can check if and how we can extract specific data from the Warehouse API. The focus will be on identifying individual suppliers and his inventory on this platform. Marketplace provides an excel file that contains a list of all products. To get a list of products from a specific supplier, we need to add one product to the cart, then press the show products button for that supplier and only then we can download a small excel file with the products of that supplier. Using the API, I want to get xlsx / csv file containing all products (about 260,000) with an additional supplier code. Perhaps using the API, you also need to add a product to the cart to find out who the supplier is and then get a list of their products. Then ...