Macro extract file name zip file excel jobs

I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.

I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED

I need an expert in web scraping who can extract email addresses of faculty professors from various university websites in the educational sector. Ideal skills and experience: - Proficiency in web scraping tools and software - Previous experience in data extraction from educational websites - Excellent attention to detail to ensure data accuracy - Knowledge of data privacy laws and ethical considerations in data scraping - Ability to deliver the work in a timely manner

I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail

I have created a voting system using HTML and JavaScript. I can save votes in local memory, but I need assistance to ensure votes are saved to a file correctly. Key Requirements: - Expertise in JavaScript and HTML - Experience with file handling in JavaScript - Problem-solving skills to identify and rectify mistakes in my code Your task would be to help me correct my current implementation so that votes are saved to a file whenever the form is saved, instead of being lost after the session ends. The current system saves votes in local memory, but I need your expertise to help me save them in a file instead.

I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experience wit...

I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.

...Superstore Objective: To scrape and extract all relevant data from the above website for internal use. The extracted data must be well-organised, accurate, and easy to navigate for future reference. (Wordpress based but do not want to use the WP plugin) Scope of Work: 1. Data to Scrape: • Product details (e.g., product names, descriptions, specifications, features, images, pricing, and PDFs, if available). • Blogs and articles (titles, content, and associated metadata such as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs...

I'm looking for a professional to create a SketchUp file for an architectural design project. The file should represent the basic layout and structure, without the need for detailed building features or high-detail furnishings. Ideal Skills: - Proficiency in SketchUp - Understanding of architectural design - Ability to create basic layouts Experience: - Prior work with architectural SketchUp files - Experience with creating models for conceptual planning or client presentations Please note, the primary purpose of this project is not yet determined, so flexibility and creativity in your approach will be highly valued.

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm looking for a freelancer who can transfer contact details from multiple web pages into a spreadsheet. Key Tasks: - Extract contact details from approximateley 50 web pages - Populate a spreadsheet with the information as specified Please refer to the attached spreadsheet for specifics on the contact details to be collected. Web site is on the spreadsheet. Please make sure you are able to access the site and understand the project before bidding.

Project Title: Advanced Telegram File Uploader Bot Project Description: I want to create a Telegram file uploader bot with advanced features that allow the admin to upload single or multiple files and generate unique download links for users to access these files. Below are the detailed features and requirements: Core Features: 1. File Uploading: Single-file upload. Batch upload (multiple files at once). 2. Download Link Generation: The bot should generate unique download links for each uploaded file or batch. Links should allow users to download the files directly via Telegram. 3. File Management: The admin should have the ability to add files to an already uploaded batch. Admin should be able to modify or delete files and batches. ...

I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.

I have an Illustrator (AI) file that needs to be converted to a Corel Draw (CDR) file. The primary purpose of this conversion is for further editing, so it is crucial that all editable elements, like text and layers, are preserved in the process. Key Requirements: - Convert AI file to CDR format - Ensure all editable elements are preserved - Specific fonts and text styles must be retained The AI file contains specific fonts and text styles that need to be preserved in the CDR file. Please only apply if you have experience with both Adobe Illustrator and Corel Draw and can ensure a seamless conversion of the file without any loss of quality or functionality.

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.

As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.

...plants, furniture, lamps) to ensure the final result looks as realistic as possible. Requirements: Wall Transparency: Remove the wall color completely, making it transparent. Ensure smooth and precise masking around objects in front of the wall. Shadow Retention: Extract and preserve the shadows on the wall from objects like furniture and decor. Adjust the shadows so they remain realistic when placed over different wall colors (use appropriate blending modes, e.g., Multiply, if needed). Output Format: Deliver the final file as a high-resolution PNG with transparent wall areas. Additional Notes: The lighting and shadows must appear natural and seamless in the final PNG. Edges around objects (e.g., plants, furniture) must be clean and free of artifacts or leftover wall...

Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken languages. The documents in question inv...

I'm looking for an AutoHotKey, PowerAutomate or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: The script should capture events from a foreground window and replicate them in a background window with a 10-second delay maximum. e,g - we have two ms paints running, we draw something on a ms paint in foreground, the same is automatically drawn on mspaint in background. - this can happen with 10second lag or less - both background and foreground windows are maximized. Ideal candidates should have significant experience with AutoHotKey, and ideally have previously developed similar scripts. Good understanding of Windows applications and ability to implement variable time delays is a must.

I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.

I'hankm looking for a pPDF, Word. T y Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft Excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective drop-down lists. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

respond with vocaroo audio recording stating your experience in order to be considered ...each hour. Maintain accuracy and timeliness in all reporting tasks. Schedule: 9:00 AM to 5:00 PM EST, Monday to Friday. Requirements: Basic understanding of bookkeeping (no extensive experience necessary). Strong attention to detail and time management skills. Ability to follow a structured schedule and meet deadlines consistently. Reliable internet connection and proficiency with tools like Excel, Google Sheets, or similar. What We Offer: Supportive team environment with opportunities for growth. Training and resources to help you succeed in the role. Competitive pay for your time and effort. If you’re organized, dependable, and ready to commit to a full-time schedule, we’d love...

I'm looking for a Data Scraper to pull restaurant data from Google Maps. The data fields should include Business Name, City, State, Email, and Phone Number. Key Responsibilities: - Use Python and scraping tools to gather data - Automate processes for efficiency - Validate data accuracy and compliance with legal guidelines - Deliver the data in Excel format Qualifications: - Proven experience in web scraping - Proficiency in Python and scraping tools - Strong attention to detail for data validation Please send your resume and past project samples to [insert contact].

I need assistance with an Excel spreadsheet. The project involves data analysis, particularly performing statistical analysis. Ideal Skills: - Proficiency in Excel, particularly with formulas and data analysis tools. - Experience with performing statistical analysis in Excel. - Ability to assist with sorting and filtering data, as well as creating pivot tables.

...should extract the payment link and send it to a specified Telegram group or chat via Telegram Bot API. Key Requirements: Secure Login & Session Management Implement a login form within our web application. Handle session cookies, tokens, and any necessary authentication details to maintain the user’s logged-in state with VFS Global. Appointment Scheduling & Group Bookings Parse/scrape the appointment scheduling pages to identify available time slots. Allow users to enter multiple passport details (group bookings). Confirm the chosen appointment time(s) via the relevant POST requests. Payment Link Extraction After confirming appointments, automatically retrieve the payment link from the response or subsequent pages. Provide a reliable method (HTML/JSON parsing)...

Dear Freelancers We need someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over the years -number of the invoice and how much invoice they paid over the years too Invoices are .doc (so you can copy/paste) easily We give access to our Dropbox From 2020 to 2024 there is around 1300 invoices You can do it on excel or something else if you have an other idea, we need something designed and easy to look at please Write elephant in your bid to show us that you've read what we need Need it fast, thanks !

Hello there, We will translate your file from English to Russian, as discussed. Thank you!

I possess a PDF manual for a brushless EtherCAT drive and I'm in need of a professional who can assist me in writing an ESI file (in XML format). This file should be created using the DVS P100E Servodrive as a template and incorporating key technical specifications from the manual. The final objective is to have a fully functional ESI file that can be used in TwinCAT or CoDeSys projects. Key elements to be included: - Communication parameters - Object dictionary - ESI XML The ideal freelancer for this project should have a strong understanding of EtherCAT drives, experience with creating ESI files, and proficiency in XML. Familiarity with the DVS P100E Servodrive would be a significant advantage. Your deep understanding and attention to detail will ensure that e...

I need a proficient web scraper to extract 30,000 datasets from a single German fashion website. This includes product names, descriptions, prices, and product images (approximately 4 images per product, around 30 kB each). Key requirements: - Meticulous attention to detail to ensure accurate data capture - Experience with handling images during data scraping - Ability to deliver clean, well-organized data The final dataset should be delivered in either CSV or SQL format. Please be prepared to demonstrate your previous work in web scraping.

...project requires API integration expertise, database management skills, and the ability to build a scalable and secure solution. Key Responsibilities: • ChatGPT API Integration: Send user inputs to ChatGPT, handle API responses, and implement robust error handling. • Database Management: Store inputs and ChatGPT responses in a database (Firestore) with an efficient schema. • Response Parsing: Extract and structure data from ChatGPT responses for further use. • API Endpoint Development: Build or enhance a REST API to manage user inputs and retrieve stored/parsed data. • Documentation: Provide detailed documentation on API usage, database schema, and parsing logic. Skills Required: 1. Backend Development: Python (Flask/FastAPI/Django) or Node.js. 2. Datab...

I'm looking for an experienced Excel professional to create a comprehensive spreadsheet for tracking my stock trading activities. This spreadsheet needs to be efficient and effective, capturing all relevant data points. Key Requirements: - Proficiency in Microsoft Excel (preferably with experience in creating financial spreadsheets). - Ability to efficiently track and calculate critical metrics such as purchase dates, sale dates, and profit percentages. The ideal candidate will have a keen understanding of stock trading and can translate this into an effective tracking tool.

I'm seeking a designer to give my existing name logo a modern facelift. The new design should be bright and vibrant, reflecting a contemporary and energizing aesthetic. Key Requirements: - Design a 'Text and Icon' based logo - Utilization of a Bright and Vibrant color scheme Ideal Skills: - Proficiency in modern design principles - Excellent understanding of color theory - Creative icon design skills - Strong typographic skills for text integration

I'm looking for a freelancer to transcribe a PDF file containing text only into a plain text file. This transcription should include the preservation of headings as they appear in the original document. A sample page is attached - the whole job is 28 pages like this one Ideal skills for this job include: - Attention to detail to ensure accurate transcription - Ability to recognize and replicate headings from the original document - Proficiency in creating and formatting plain text files

I need an expert to help me organize my Excel file containing employee attendance data. Key Requirements: - Setting up filters for my analysis on employee attendance - Creating specific filters for different aspects of the data - Ensuring the file is user-friendly and easy to navigate Data Types: - Employee attendance data which includes number of days off, late comers, and early leave. Ideal Skills: - Advanced Excel proficiency - Experience in data organization and analysis - Attention to detail - Ability to create user-friendly spreadsheets

I need to delete multiple rows within a Word table. I have an Excel showing which rows should be deleted. Afterwards, some page breaks and formatting work might be needed. Skills needed: - Proficiency in Microsoft Word - Attention to detail I have two print screens attached. The word document has 102 pages with 675 rows. 326 rows need to be deleted. All work in the word document needs to be done twice: There is an English version of the document, and a German version.

I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.

...Data Entry Specialist to assist with organizing and entering new contacts into an Excel format. The ideal candidate will have excellent typing skills, a keen eye for detail, and the ability to deliver high-quality work within specified deadlines. Project Details: Scope of Work: Cognito will provide a list of companies. Using this list, the specialist will research and identify relevant Marketing and Media & Communications contacts in the US, UK, Netherlands, Germany, Hong Kong, Singapore and Australia, including their job titles (and email if available). Requirements: o Proven experience in data entry or similar roles. o Ability to conduct accurate online research to source contact details. o Proficiency in Excel and/or Google Sheets. o Tools knowledge such as Linke...

I'm in need of an experienced Python developer to upgrade an existing Python-based solution that uses Gradio. The solution allows users to perform file uploads, select different AI models, and generate a summary of the uploaded document using a prompt. The summarized response is then saved to a file which is downloadable by the user. Key Responsibilities: - Upgrade the existing codebase to integrate additional AI models, particularly GPT4o and Anthropic, to the system using their respective APIs. note that while I've used PyPDF to extract the text for the Ollama model, I'd like to use OpenAI or Anthropic API with uploading the PDF directly to their services rather than doing the extraction/OCR locally. - Ensure seamless interaction and functionality ac...

web scraping and video automation developer. Job Description Project Goal: Automate the manual process of collecting business data and generating customized videos for outreach. Key Tasks to Automate: Business Research & Data Collection Scrape Google search results (pages 2–10) for target businesses. Extract business names, website URLs, and email addresses into a spreadsheet. Automated Video Generation Create a script/tool that: Simulates browser activity (e.g., scrolling, mouse movements) for a list of URLs. Overlays a pre-recorded talking-head video onto the automated browser activity to create a single, seamless video. Vimeo Upload & Link Tracking Automatically upload generated videos to Vimeo. Save Vimeo video links back to the spreadsheet. Skills Requ...

...with Influencers on TikTok and Instergram. If you can supply account examples on TikTok and Instergram this will help you win the job. I’m looking for an influencer marketing expert to help promote my TikTok and Instagram account. The primary goal of this campaign is to increase my follower count through collaborations with Macro-influencers (100k-1M followers). Key Responsibilities: - Strategize and implement influencer marketing campaigns - Coordinate with Macro-influencers to create engaging lifestyle content - Assist in video and image editing to maintain a consistent and appealing aesthetic across all posts Skills and Experience Required: - Proven experience working with TikTok and Instagram influencers - Strong understanding of influencer marketing strategi...

Please Sign Up or Login to see details.

I'm working on a high school project involving a basic calculation app APK. I need a freelancer to extract the arithmetic operations from the source code and provide them in a plain text document as a step-by-step list of formulas. Ideal Skills: - Proficient in working with APKs and understanding app source code - Excellent written communication skills for clear, concise explanations. The app only performs basic arithmetic operations: When entered inpurts. I need the extracted formulas listed in a simple format.

I need a Tally coder who can automate data entry from various sources into Tally in real-time. Key tasks include: - Automating data entry from Excel spreadsheets, a Database, and Manual entries into Tally. - Ensuring that the data is updated in real-time. Ideal skills and experience: - Proven experience with Tally and data automation. - Proficiency in working with Excel spreadsheets and databases. - Ability to manage and automate manual data entries. - Excellent attention to detail and commitment to accuracy.

I'm seeking a talented designer well-versed in Corel Draw to elevate the design of my clinic's patient file. The aim is to make the design more professional and uniform, adhering to a modern and clean aesthetic. Key Modifications: - Color Scheme: Revamp the current palette to enhance visual appeal and consistency. (Medical sector blue color, or something good) - Typography: Improve text readability and overall design synergy. - Layout: Adjust the arrangement of elements for a balanced, uncluttered look. This project primarily involves redesigning a patient file, so experience in creating medical or similar professional documents would be an advantage. Please ensure your portfolio reflects your ability to create modern, clean designs. I want it in CDR format

Hello there, We will translate your PDF file from Italian to English, Swiss German, and Swiss French by the end of this week as discussed. Thank you!

I've inherited a project pushed to GitLab. I need to extract the 'Published' internal data (and types) within the Project application so I can identify what's available to 'Subscribe' to when creating a ROS node. The application is in C++. I'm a newbie to GitLab, so need to know how to do this and get guidance. The ideal freelancer will have: - Very Good Experience with GitLab - Experience in C++ - Familiarity with ROS (any version) - Ability to document clearly. Any format will do, PDF would be ideal. - Capable of identifying data structures and types.

I'm looking for an expert with advanced Excel skills to help me set up and manage an inventory system using Excel. Key Responsibilities: - Design an Excel-based inventory management system - Analyze customer data within this system - Integrate Excel with external databases Ideal Skills: - Proficient in Excel, particularly in its advanced functionalities - Experience in setting up inventory management systems - Strong data analysis skills - Familiarity with customer data analysis The inventory system will manage a small to medium-sized inventory.