Vba refresh excel web query jobs
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
...customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - Customer profile page. - Future events. - Past events. - Event details - Info page. - Event details - Food orders. - Guest food order - single page. - Food menu. - Guest list. - Add an admin. - seating manage...
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video. Ideal Skills: - Proficient in creating macros in Excel and scripts in Google Sheets. - Strong understanding of data entry processes. - Able to follow visual instructions precisely. Please note, the exact source of the bold information will be provided in the video.
...seeking a web app developer to create a custom application for our logistics company. This app will automate the process of downloading quotations from shipping lines and airlines, displaying the data in a user-friendly format, and allowing for edits to create customer quotations. Key features of the web app include: - Advanced data processing: The app needs to handle complex tasks such as data extraction, transformation, formatting, and validation. - Manual upload function: This should allow users to upload rate templates from shipping lines via Excel or CSV files. - Format standardization: The app should assist in converting inconsistent rate formats from different shipping lines into a specific Excel template before upload. - Compatibility: The app needs...
I'm looking for a data analyst who can help me assess the performance of various projects based on Excel spreadsheet data. Your primary focus will be determining actual run rates, based on project entries and forecast dates, as well as identifying whether projects are ahead or behind schedule. Additionally, I would like you to provide both a written report and visual aids (charts and graphs) as part of your deliverables. Ideally, you should have a strong background in data analysis and visualization, with a good understanding of Excel. Experience with project performance analysis would be a plus. Please note that there are no set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm looking for a freelancer to source and add leads to an excel sheet based on specific criteria. Key Responsibilities: - Use LinkedIn to source leads based on current Job Title and Company Name - Include Name, Job Title, Company Name, and Email in the Excel sheet - Ensure that the leads apply to the industry and job function Ideal Skills and Experience: - Proficient in using LinkedIn/ search for lead generation - Detail-oriented with strong data entry skills - Familiarity with different levels of job titles within companies - Excellent communication and organizational skills - Proven experience in lead sourcing would be a plus The leads should involve the highest-level manager for that particular company within Drug Supply-Sourcing. The job titles and company names ...
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 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.
I'm seeking a professional auditing firm to conduct a performance 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. ...
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.
...portfolio with examples of successful branding, lead generation, and marketing campaigns, along with a brief proposal for how you would achieve the user acquisition goals. - bid ONLY what you would charge and use the phrase “I CAN DO THIS” so I know you read and understand job - be prepared to show proven track record of generating sales Task List for Freelancer and Website Optimization: Refresh the company logo, visuals, and messaging. Optimize the website for mobile and desktop conversions. Add a clear CTA for the 3-day free trial and bonus offers. Campaigns: Research and target ideal customer profiles with ads. Launch Google and Facebook ad campaigns within a small budget. Continuously test and optimize ad copy, visuals, and targeting. Generation and Outrea...
I'm looking for a skilled web developer to create a comprehensive and modern website/database platform for high school football teams, complete with individual player profiles. Key Features: - **Sleek Design**: The landing page should embody a modern and sleek design style. - **Player Profiles**: Develop profiles for individual players that include contact, academic, and athletic information. - **Media Uploads**: Implement functionality to upload unique pictures, videos, and documents for each player. - **User-friendly Filtering**: Enable robust filtering and sorting 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 membe...
...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 Excel table summarizing: Identified gaps in each category. Target demographics or regions. Recommended services/products to address these gaps. 3. Competitor SWOT Analysis A clear SWOT matrix for key competitors, highlighting strengths, weaknesses, opportunities, and threats. 4. Actionable Recommendations A standalone document with: Proposed services/products for each domain. Suggeste...
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 Address - Owner's Name (if available) - Delivery Platform - PO...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 organi...
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
...content creator to help launch a new taxi company in Greece. This project involves creating a new "Combination Mark" logo for the brand, redesigning two existing logos, and producing a range of digital content. Key Tasks: 1. Logo Creation: Design a unique logo for a new taxi company. The logo should combine the brand's name in custom typography with a line drawing of a taxi or ? 2. Logo Redesign: Refresh the logos for a private transfer company and a car rental company. 3. Social Media Content: Create engaging posts and stories for Instagram, in a variety of formats. 4. Video Content: Produce high-quality video content including explainer videos, product demos, customer testimonials, behind-the-scenes footage, and how-tos. (We can skip that if it puts the pric...
...simultaneously. - Strong communication and problem-solving skills. - Understanding or appreciation for body-positive movements and inclusive branding is highly valued. Duration & Commitment - Initial engagement for the next few months, with the potential to extend if it’s a great fit. - Flexible hours; workload may vary based on project timelines and deliverables. How to Apply Briefly tell us why you’d excel in this role and how your experience aligns with our mission. Share past projects or accomplishments that highlight your organizational skills, marketing insights, and AI-savviness. To confirm you’ve read the entire posting, please include the phrase “Confident & Authentic” in your proposal. We can’t wait to see what you’ll...
...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: - Proficiency in Microsoft Excel, p...
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.
...Performance Monitoring: Analyze campaign performance and adjust bidding strategies, targeting, and creatives. Ensure campaigns meet our KPIs, including ROAS, CTR, and CPA goals. Optimization: Refine audience segmentation and targeting for both platforms. Optimize the Performance Max campaign using asset group segmentation and feed-only strategies. Identify high-performing ad sets and scale them. Refresh and test creatives regularly on Meta Ads. Reporting: Provide weekly performance updates and insights. Offer actionable recommendations to improve campaign efficiency. Strategy Development: Suggest and implement strategies to improve account performance. Propose A/B tests for headlines, creatives, and ad placements. Requirements: Proven experience managing Google Ads and Meta A...
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...
...pages active and relevant. 3. Social Media Marketing and Advertising: • Effectively manage my social media presence by implementing targeted strategies to grow my audience. • Run targeted ad campaigns to attract potential clients and increase engagement. • Optimize and monitor campaigns to ensure maximum return on investment (ROI). 4. Ongoing Maintenance and Optimization: • Consistently refresh content to reflect updates in my business and to stay relevant to the target audience. • Provide strategic advice on improving page performance and achieving business goals. The primary objective is to ensure that my social media pages serve as powerful tools for attracting clients and promoting my renovation and construction services. I am seeking someone ...
I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database sec...focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query...
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 someone with expertise in Lead Generation, someone that uses Zoominfo and/or Salesgenie (Data Axle). Target Audience: Private Businesses within these counties of TX: Nueces, Cameron, Hidalgo, and Willacy c...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 will only accept Excel format) Ongoing for the right freelancer. **If this is unclear I ask that you communicate with me before awarding the project I’m open...
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
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 that I know you read the descripti...
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 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.
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.
I need a web-based platform that allows 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 ...
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'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
My WordPress website is experiencing plugin issues, leading to broken links and missing pages. - The most pressing concern involves the plugin...concern involves the plugin-related problems, which are causing broken links or missing pages, disrupting the site's functionality. - I need to update pricing and some wording throughout the site. - I want a design refresh for the homepage, Product/Service pages, and the About Us page. - The desired aesthetic is a modern and minimalistic design. Ideal skills and experience for this project include: - Proficiency in WordPress troubleshooting and plugin management. - Experience in website content updating and pricing revisions. - Strong background in modern and minimalistic web design. - Ability to resolve broken links or miss...
I'm looking for a skilled C# developer with experience in enhancing Windows services and working with APIs, particularly the Milestone Server API. The objective of this project is to enhance an existing C# Windows service to query the status of CCTV cameras via the Milestone Server API. Scope of work: - Implement a function that queries the status of CCTV cameras from the XProtect 2021 R2 Milestone Server API. - Develop an API within the Windows service that lists cameras and displays their status as either "online" or "offline". Key Requirements: - Proficient in C# and Windows service development. - Prior experience with the Milestone Server API is highly desirable. - Ability to create and implement APIs. Please note that if a camera is found to be offli...
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 tracking spreadshee...
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
