Vba grabs data excel file jobs
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.
I have a data entry task that needs to be completed on my computer using TeamViewer. Requirements: - The data entry involves mixed data (text and numbers) from scanned documents. - The final format of the entered data should be in an Excel spreadsheet. Ideal Skills: - Experience in data entry is preferred. - Proficiency in Excel is crucial. - Familiarity with TeamViewer is a plus. - Attention to detail is key, as the data is coming from scanned documents.
I need assistance with extracting data from a PDF and placing it into an Excel format I will provide. Key Requirements: - Data extraction from the PDF should be done according to specific column headers in the provided Excel format. - Minor data cleaning is needed during the extraction process. Ideal Skills: - Experience in data scraping. - Proficient in Excel. - Attention to detail for data cleaning.
...audit on my stock trading activity. The data consists of a few thousand line items in an Excel spreadsheet. Key Aspects of the Audit: - Return on Investment: Assess the profitability of my trades. - Accuracy of Trades: Determine if there were any errors or discrepancies in trade execution. - Transaction Costs: Evaluate the expenses incurred during trading and their impact on overall performance. Requirements: - The auditor must be an official auditing firm, ideally with relevant past experience. - Preference for firms based in the EU or US. - The auditor must be able to work with a specific report format that I will provide. Ideal Skills and Experience: - Extensive experience in conducting performance audits. - Proficiency in analyzing stock trading data. - Famil...
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
...options for user convenience. - **Data Export**: Provide functionality to export data in CV or Excel format. - **Public and Secured Access**: Create a combination of secured login for team members and staff, while allowing public access to certain features. - **Profile Visibility**: Ensure public access to basic stats, achievements and highlights of the players, along with general information. The ideal candidate for this project should have: - Extensive experience in web development and database management. - A keen eye for modern and sleek design. - Ability to implement robust filtering and data export capabilities. - Experience with creating secure logins for multi-tiered access. - An understanding of how to balance public and private data...
...publicly available data, such as user feedback, reviews, and industry reports, to support findings. 4. Provide Recommendations Suggest specific services or products to address identified market gaps. Recommend target audience segments and business models (e.g., subscription-based, freemium, partnerships). Include innovative tools or features that can differentiate our offerings from competitors. Deliverables The freelancer must deliver: 1. Comprehensive Report A detailed Word or PDF document covering: Market gaps in each category. Consumer pain points and underserved areas. Competitor analysis, including SWOT matrices. Industry trends and emerging opportunities. Include visual elements like graphs, charts, and matrices to support findings. 2. Market Gap Summary Table A concise ...
I'm looking for an expert in Excel or Win Calendar to help me organise multiple spreadsheets into a cohesive and easy to understand monthly calendar. The calendar needs to include: - Meetings and conferences - Promotional campaigns - Events - Program invitations - Media releases - Communication releases (both internal and external) Final deliverable: An Excel file that organizes all these activities by date per month and catergory. This calendar will be shared via Outlook and uploaded to our Teams folder. We have existing mulitple Excel spreadsheets that need to combined in one comprehensice Attention to detail and accuracy is extremely important. Ideal skills and experience for this job: - Proficiency in Excel, including advanced functions -
I'm looking for a freelancer to compile a comprehensive list of restaurants in specified areas that utilize GrubHub and DoorDash for food delivery. Key Requirements: - Gather information about each restaurant, including: - Name - Address - Phone Number - Email A...POS System - Whether they offer online ordering with delivery on their own website - The specific areas will be explained in detail with the chosen applicant. - Organize the information in a spreadsheet with separate columns for each piece of information. Ideal candidates should have experience in data collection, familiarity with food delivery platforms is a plus. Attention to detail is crucial as the accuracy of the information is essential. Skills in using Excel or similar software for data...
Please Sign Up or Login to see details.
I need a captivating logo Design for a luxury custom home building company called " Jetstone Homes " Greetings Freelancers, We are excited to announce a contest for designing a logo Design for a luxury custom home building company called " Jetstone Homes " . We're looking for a design that grabs attention, communicates our brand identity effectively, and stands out. . I want it to be luxury/Minimalistic finish. Company Name: Jetstone Homes Color Scheme: The text in Black or white with a small accent color (Burgundy or maroon) Design Requirements: Eye-catching and attention-grabbing design. minimalistic (hint of color)
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm encountering 404 web page errors when attempting to email an Excel worksheet from a network share drive. This issue is hindering my ability to send important reports and needs to be resolved as soon as possible. Ideal Skills and Experience: - Proficiency in troubleshooting network issues - Expertise in Excel and email systems - Understanding of web server error codes - Experience with resolving 404 errors - Familiarity with network share drives error: Failed to load resource: the server responded with a status of 404 ()Understand this errorAI Failed to load resource: the server responded with a status of 404 ()Understand this errorAI Failed to load resource: the server responded with a status
...marketing strategies that align with our core values. - Work with AI (e.g., ChatGPT) to generate on-brand content ideas, promotional copy, and strategic marketing angles. - Conduct market research on current trends, potential brand partnerships, and new opportunities for expansion. - Utilize AI tools to gather insights and present data-driven recommendations for improvement. - Assist with day-to-day business needs such as file organization, digital asset management, and light data entry. - Prepare succinct updates and reports on project statuses. - Offer fresh ideas for giveaways, special promotions, or collaborations that emphasize our mission of authenticity and self-love. - Identify ways to use AI technologies (beyond ChatGPT) to improve workflows, automate tasks...
I am currently facing issues with my QuickBooks file. We are able to operate for the most part, but the verify data tool continually informs me that we have errors and the file rebuild tool is able to repair them. Quickbooks support was not able to help. We are preparing to migrate to quickbooks online so we need a clean file. I'm looking for a professional who can help diagnose the issue and solve it. Ideal skills: - Expertise in QuickBooks - Data recovery experience - File repair skills
...critical task involving two Excel files. The project involves copying data from the L Block excel schedule into the 2-week look ahead file. Key Responsibilities: - Accurately copy and paste information up until approximately 12/27/25. - Ensure that dates match in both documents. - Retrieve necessary vendor information from column F in the scheduler file. Important Notes: - Both files already contain the required dates, so no additional dates need to be added. - It is crucial to maintain the same formatting as in the L Block file; do not alter the format of the dates in the 2-week look ahead file. - Rows 6 to 18 in the 2-week look ahead file are hidden; do not unhide them during the copying process. Ideal Skills and Experience: ...
I am encountering a problem with my thermal printer not being detected by Odoo 17. This issue is hampering my operations and needs to be resolved promptly. You should be able to fix issues during live call/zoom. You also help with excel file import to Odoo for accounting. Ideal Skills: - Odoo 17 expertise - Thermal printer troubleshooting - System connectivity solutions Please reach out with proposal starting word Import, so I know you read it correctly and if you can help resolve this issue.
I need an Excel template to catalog my extensive stunt equipment inventory. The template should be able to accommodate different categories of equipment, track multiple details for each piece, and provide a summary page with totals for each category. Key Requirements: - Listing of equipment across approximately 100 categories, each with its own page. - Individual listing of items (e.g. 500 carabiners). - Summary page detailing total quantity and value of each type of equipment. Details to Track for Each Piece: - Quantity and value - Condition and location - Size - Inspection date - Description Ideal Skills and Experience: - Proficiency in Excel - Prior experience with inventory management templates - Strong attention to detail - Ability to create user-friendly and efficie...
I'm looking for a professional Excel expert to create a custom PPM maintenance schedule spreadsheet for me. Key Features Required: - Custom frequency: Inspections will not follow a standard 6 or 12 month schedule, but will be tailored to specific needs. - Contractor details: All contractor names, contact details, and yearly or six-monthly costs must be included in the same sheet. - Inspection dates: The sheet should track the date of inspection and the next scheduled inspection. - Automatic scheduling: If I select a 365-day frequency, the spreadsheet should automatically schedule the next inspection one year from the first. - Conditional formatting: Inspections due in a month should be highlighted in amber, while overdue inspections turn red. - Advanced features: I need autom...
I'm seeking an Excel expert to create an intricate report for monitoring headcount targets across seven business leaders within our organization. The report should consist of three tabs: 1. Open/Approved Reqs 2. Filled Reqs 3. Pending Review Ideal Skills: - Proficient in advanced Excel functions - Experience in creating complex formulas or macros - Ability to integrate visual aids such as charts into the report The report will necessitate the incorporation of complex formulas or macros, so a freelancer with advanced Excel capabilities is a must. Additionally, the report should feature charts to visually represent the data, making it easier to digest and interpret. If you have a strong background in data analysis and visualization, and you're ...
...and/or Salesgenie (Data Axle). Target Audience: Private Businesses within these counties of TX: Nueces, Cameron, Hidalgo, and Willacy counties. - Revenue between $500,000 and $1,000,000 - Private entity (Not publicly traded) - Construction, manufacturing operations industries. Data Requirements: - Owner Name and Title - Company Name - Valid E-mail address - URL if available - Location - Revenue - # of employees - Industry Timeline: Please share anticipated timeframe to complete this request. Proof of concept: Must provide valid information and confirm access to tools to retrieve data. Skills and Experience: - Proven experience in Lead Generation. - Access to data tools needed. - Capable of retrieving and formatting the data in MS Excel...
I need a professional data analyst to extract monthly inventory data from SAP into a refreshable Excel sheet. Key Requirements: - Pull stock levels and pricing data from SAP - Create an Excel sheet that can be easily refreshed with new data each month Ideal Skills and Experience: - Proficiency in SAP - Advanced Excel skills - Previous experience with inventory data extraction - Strong attention to detail
Project Title: Data Entry Specialist Project Description: We are seeking a highly accurate and detail-oriented Data Entry Specialist to join our team on a freelance basis. The ideal candidate will have excellent typing speed and accuracy, strong attention to detail, and the ability to work independently and efficiently. Responsibilities: * Accurately enter data into spreadsheets, databases, and other software applications. * Perform data cleaning and validation tasks, including identifying and correcting errors. * Maintain data integrity and accuracy throughout the data entry process. * Follow specific instructions and guidelines for each project. * Meet deadlines and maintain a high level of productivity. Qualifications: * Excellent typing s...
I'm looking for a meticulous data entry professional to assist with extracting specific information from a PDF document and inputting it into an Excel worksheet. Key Responsibilities: - Extract specific data from the PDF, including Mechanical equipment, spaces served, and airflow rates. - Input approximately 800-1000 lines of data into a single Excel sheet with categorized columns. - Use a pre-defined format for column headers in the Excel sheet. Ideal Skills: - Proficient in Excel, with a strong attention to detail. - Previous experience in data entry and data extraction from PDF to Excel. - Ability to follow instructions and adhere to a pre-defined format. Include the word "Potato" in your response so...
...31,47; White: 255,255,255), and ensure it’s optimized for 3D printing with your Bambu Labs printer. The final product will be delivered in a format such as .STL, ready for upload to your printer. The estimated timeline for this project is around 7 days depending on the revisions you may need. The total cost for this project will be 100$, which includes the model modifications, color mapping, and file optimization. Once you approve this proposal, I’ll start working on the project, and after providing the initial version, I’ll make any necessary revisions based on your feedback. I’m also excited to assist with any future projects where you need 3D models created from 2D images, so please feel free to reach out anytime. Thank you again for considering me. I l...
I'm looking for an Excel expert to help me extract inventory data from multiple Excel sheets. The extracted data should be organized into a new Excel sheet. Ideal Skills and Experience: - Proficient in Excel with deep understanding of data manipulation techniques - Experience in data extraction and organization - Attention to detail to ensure data accuracy - Ability to deliver work in a timely manner.
I need a script for AutoCAD MEP that automatically transfers data from my Excel spreadsheet to space properties. The data is in an XLSX file and includes room names, numbers, and HVAC specifications. - Ideal candidate should have a strong background in AutoCAD MEP and scripting, with experience in data integration from Excel. - Please note, I'm not certain if custom mapping is necessary for this project. Your expertise in determining the best approach would be valuable.
I need a skilled professional to create a CDR file for my rubber stamp. The project involves: - Creating a CDR file from my logo design - Adhering to my specified color scheme Ideal candidates should have: - Previous experience in creating CDR files - Strong background in logo design - Excellent attention to detail
I need a freelancer to convert text data from 1-5 PDF files into Excel. The ideal candidate should have experience in data entry and conversion, with attention to detail to ensure accuracy.
I need assistance with probability calculations in Excel for my statistics class. Specifically, I'm struggling with conditional probability and need someone expert in this area to guide me. Ideal skills for this project include: - Proficiency in Excel - Strong understanding of conditional probability - Experience with probability calculations - Ability to explain complex concepts in a simple manner
Develop a Financial Allocation Model Job Description We are looking for an experienced freelancer to create a financial model in Excel or Google Sheets to allocate income statement data across multiple countries based on predefined rules. This model will streamline monthly reporting, enhance accuracy, and simplify processes for analysts. Skills Required Advanced Excel Financial modeling experience must Understanding of allocation methodologies and data analysis. Deliverables A working allocation model with clear instructions for use. Documentation of logic and any encountered issues.
...me to import Excel workbooks directly from my PC. The platform should enable me to select specific information from various columns across different workbooks and consolidate them into a new Excel workbook. Features: - Ability to import multiple Excel workbooks - Selective data extraction from different columns - Consolidation of selected data into a new workbook - Option to filter certain values based on text and numeric criteria - Capability to apply exact match filtering for specific numeric values Skills and Experience: - Proficiency in web development - Strong knowledge of Excel and data manipulation - Experience in creating data processing platforms - Understanding of filtering criteria based on text and numbers - Ability t...
I'm looking for a freelancer who can help me create an Excel sheet to manage match schedules. This isn't just a simple schedule, but a comprehensive table of teams and their selections. Key Features: - A visual calendar for easy understanding of match schedules - Inclusion of team logos in the table Ideal Skills: - Advanced Excel skills - Experience in sports data management - Ability to create visually appealing and functional spreadsheets I want the final product to be a user-friendly and detailed Excel sheet that can help me keep track of upcoming matches and team selections.
I am in need of a PowerShell script that will facilitate the transfer of large files from my Windows PC to a FileZilla FTP server. This script should come with an automated scheduling feature, allowing for regular, timed transfers. It should also be set up to skip existing files on the FTP server to prevent unnecessary overwrites. Ideal Skills and Experi...server. This script should come with an automated scheduling feature, allowing for regular, timed transfers. It should also be set up to skip existing files on the FTP server to prevent unnecessary overwrites. Ideal Skills and Experience: - Proven experience in PowerShell scripting - Familiarity with FileZilla FTP server - Previous work involving automated scheduling in scripts - Understanding of file transfer protocols and erro...
I'm in need of a professional who can create a detailed engraving file for a large wooden surface. This project involves a combination of text and graphics. It would need to be 6 engraving ready files, one for each child. It would look similar to the attached picture from last year. I have the attached artwork to help make this project easier. Thank you
I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.
Multiple analytical works and updating of codes and VBA
I'm looking for an Excel expert to assist with formatting my pilot logbook spreadsheet. The logbook is used to track flight data, and I need help with both cell formatting and calculations. Key Requirements: - Expert level knowledge in Microsoft Excel - Experience in spreadsheet formatting, including cell formatting (e.g., colors, borders) and data organization (e.g., sorting, filtering) Specific Tasks: - Help with Formulas and calculations - Help calculating total flight hours and flight time by aircraft type - Create a formula for inputting an aircraft registration and having the corresponding aircraft type appear in the next cell. Ideal freelancer should have: - Strong attention to detail - Prior experience with pilot logbooks or similar flight track...
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.
I have a 22-page PDF that needs to be converted into an Excel workbook. Each page of the PDF should correspond to a separate tab in the Excel file. The project involves reformatting images and adding specific information. Specific Tasks: - Convert each page of the PDF into its own tab in the Excel workbook. - Reformat the content of images on each page into text within Excel. - Add ordering information and my logo to the bottom of each page. - Transform images into text using OCR (Optical Character Recognition). Ideal Skills: - Proficiency in Excel and PDF conversion. - Experience with OCR software or tools. - Attention to detail for accurate transcription and formatting.
To export PDF with enhanced data from excel sheet and chatgpt integration. The goal is to automate this process including data extraction, data enhancement, pdf export
More details: What specific tasks do you need help with in Microsoft Excel? Data analysis What type of data analysis are you looking for? Market research analysis Which financial metrics are you most interested in analyzing? Cash flow
I'm seeking an experienced developer to create an Excel-based chatbot for me. The chatbot needs to handle natural language processing (NLP) to enable intuitive user interactions. Key Skills Needed: - Proficiency in Excel and chatbot development - Experience with natural language processing (NLP) - Ability to create user-friendly interfaces - Strong communication skills for understanding project requirements
I'm seeking a skilled Excel expert to create an interactive, monthly reusable Excel document based on the Georgia ST-3 form. I've got a PDF version, but I need a tailored Excel one with formulas to compute specific totals. Key Requirements: - The layout should be similar to the PDF but does not need to match exactly. - Formulas to total Sales Tax and State Tax - Inclusion of a 'Clear' button to reset data - Pre-filled templates for each month Ideal skills for this job include advanced Excel proficiency, experience with tax forms, and a good eye for detail.
...Python developer to automate the transfer of data from Excel to PowerPoint for me. This task includes transferring data and creating slides, generating charts and inserting them into the slides, and formatting the slides based on templates. Specific Requirements: - Data Transfer: Text data, numerical data, and charts/graphs need to be transferred from Excel to PowerPoint. - Slide Organization: Each Excel sheet should correspond to one PowerPoint slide. Ideal Candidate: The ideal candidate for this project would be someone with extensive experience in Python, as well as familiarity with working with Excel and PowerPoint. Strong attention to detail is a must, as the slides need to be formatted according to specific template...
We need to make work an Excel Add-in working in Office 365 or Excel 2016. It works in Older OS & Excel versions but not in newer versions.
I'm in need of a seasoned bookkeeping professional who can assist with my various bookkeeping tasks using Microsoft Excel and the accounting software, Xero. Tasks will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Skills and Experience: - Proficient in Microsoft Excel - Prior experience in bookkeeping and managing accounts - High attention to detail for accurate data entry and bank reconciliation - Familiarity with QuickBooks is a plus My bookkeeping process is standardized, so the main requirement is to assist with the execution of tasks rather than setting up a new system.
I'm in need of a dedicated professional who can conduct thorough online research and compile the gathered information into organized spreadsheets and documents. Ideal skills and experience for the job: - Proficient in online research - Strong skills in Microsoft Excel and Google Sheets - Ability to create clear and comprehensive documents - Experience in market research and competitor analysis - Excellent understanding of customer insights