Vba extract comments excel jobs
I need a freelancer to help me transcribe 2-3 pages of my bank statement into an Excel file. Please format the data into separate columns for Date, Description, and Amount. Additionally, I need the balance after each transaction included in the Excel file. Specific Requirements: - The data should be transcribed into columns for Date, Description, and Amount. - The balance after each transaction should be included. Formatting: - The Excel file should use standard grid lines and font. Ideal Skills: - Proficiency in Excel - Attention to detail - Data entry experience
I'm in need of a CAD professional to help me create a full Bill of Materials (BOM), a detailed parts list, and a basic electrical layout. I have Python files ready just run for DXF in SkyCAD, which can generate the full program including the BOM. However, these files will need to be downsized. Key Tasks: - Produce a full BOM f...the dxf for a basic electrical layout I need the parts list to be a detailed component items called out in detail in the dxf and correlated with the BOM to allow for easy cross-referencing. This project is time-sensitive as I'm currently two weeks behind schedule. Ideal Skills: - Proficiency in CAD software - Experience with creating BOMs and parts lists - Ability to work with dxf files to extract electrical layouts - Python programming knowl...
This program is to be an unpublished, separate tool for my website for asset valuation: www.maskinvurdering.dk. I have prepared a 6 page description of the project, which I have attached. I am interested in firm bids only. Placeholder bids are not to be considered genuine bids and such bids will not be considered.
...Demonstrated skill in conducting comprehensive research on diverse topics such as AI, stock markets, and market trends. • Advanced knowledge and use of Generative AI models such as ChatGPT. • Proficient in managing personal tasks, including booking appointments, organizing family holidays, and developing personal branding initiatives. • High proficiency in Microsoft Office applications (mainly Word, Excel, and PowerPoint), ChatGPT, and familiarity with digital content management systems for maintaining websites (WordPress). • Experience in handling confidential information with the utmost discretion and integrity. • Educational background in business administration, marketing, or related fields is preferred. Working Hours and Duration: • This is a re...
...the next level! About the Role As our Social Media Freelancer, you’ll: Develop and execute a dynamic content strategy across platforms like Instagram, Facebook, LinkedIn, and TikTok. Create high-quality, engaging content including posts, stories, reels, graphics, and videos. Manage posting schedules to maximize engagement and reach. Build and nurture a growing online community by responding to comments and messages. Analyze performance metrics and adjust strategies to improve engagement and growth. Stay up-to-date with social media trends to keep our brand ahead of the curve. What We’re Looking For Proven experience in content creation and social media management. Expertise in using tools like Canva, Adobe Suite, or similar for graphics. Ability to create short-fo...
I'm looking for an Excel VBA expert to help me with a local Excel file. The task involves creating a script that will filter data in a pivot table based on specific criteria. Ideal skills and experience: - Proficient in Excel VBA - Experienced in working with pivot tables - Strong understanding of data filtering techniques - Ability to write clean, efficient code
I'm looking for a skilled VBA programmer to create a dynamic filter function for my Excel pivot table. The data source is an Excel workbook and the pivot table is primarily dealing with numeric data. Key Requirements: - Create a VBA code that allows the pivot table to filter numeric data based on custom criteria. - The filter should be dynamic, adjusting as the data changes. Ideal Skills and Experience: - Proficiency in VBA programming with a strong understanding of Excel pivot tables. - Experience in creating dynamic Excel functions. - Ability to understand and implement custom filtering criteria.
...similar) for storing funding and tender listings. • Database structure should accommodate fields such as: • Title of the funding or tender. • Description and eligibility criteria. • Submission deadlines. • Funding amount or programme budget. • Contact details or application process links. • Relevant documents (if applicable). 2. Web Scraping Setup • Develop web scrapers to automatically extract data from: • European Commission Funding Portal. • UK Research and Innovation Opportunities. • Configure scrapers to: • Run daily to fetch and add new announcements. • Identify and handle changes in webpage structure. • Implement robust error-handling and notification mechanisms for failed scrapes. 3. ...
I've collected data from 4000 texts and need help with the remaining 30%. My primary focus is on optimizing existing regex patterns to extract specific details from patient reports. The ideal candidate should be proficient in Python and have extensive experience with regex. Tasks: - Help optimize existing regex patterns to extract lab results and diagnoses from patient reports. - Assist in improving the efficiency of data extraction. Skills & Experience: - Proficient in Python - Extensive experience with regex - Previous work with medical data preferred
...fillable PDF form incorporating numerical data from Excel. The form will require several advanced functionalities including: - Formulas for calculations: This is crucial as the form needs to carry out certain computations based on the input data. - Conditional formatting: The form should be able to visually represent changes based on different conditions. - Data validation: The form must ensure that the inputs meet certain criteria, helping to maintain the integrity of the data. The integration of the Excel data into the PDF form will be done through manual input. Therefore, the design should facilitate ease of use and accuracy during this process. Ideal skills and experience for this job include: - Proficiency in Adobe Acrobat and Excel - Experience in creatin...
We are working on a project that collects data through surveys aimed at understanding trends, traveler preferences, and satisfaction levels within the tourism sector. Currently, the process involves manual work using Excel, which is time-consuming and inefficient. To address this, we aim to develop a system that automates data preparation, classification, and visualization (using POWER QUERY), thereby enhancing accuracy and decision-making capabilities. The overarching goals of the project are: of Dashboards in Power BI Building interactive dashboard(s) to present various analyses, key questions, and insights, supported by constructed indicators, DAX formulas, and other advanced features. Statistical Indicators Generating descriptive statistical measures (e.g.,
I'm in need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Back Office Support.
I'm in need of a modern and sleek logo for my brand - Hops Detox Hops Detox uses hops extract drops Please Google Image Hop Plants for design ideas The Image NEEDS to look like a hops plant If you use liquid drops - the liquid is clear ( not coloured ) This logo should incorporate both an image of the hops plant, as well as the text 'Hops Detox'. The Text HOPS DETOX should be easily seen in the logo Key Requirements: - The design should be modern and sleek. - The color scheme is open - The logo could feature both the hops plant and maybe the liquid hops drop/s - which is the unique aspect of Hops Detox program Please note, I have no interest in AI-generated images. Please note the time difference in Sydney Australia for when I review Skills and Expe...
I need to work in a excel doc to do a macro to calculate new prices and add some other information.
*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.
...in Matunga, Mumbai. The aim is to keep our Instagram page active and generate leads. Key Responsibilities: - Create and post engaging content several times a week, including client testimonials, workout tutorials, and class schedules and updates. - Use iPhone photography to capture high-quality images that showcase the studio, our classes, and our members. - Monitor engagement and respond to comments to build a community around our studio. Ideal Skills and Experience: - Proven experience in social media management, particularly on Instagram. - Strong photography skills, with experience in using an iPhone for professional-quality images. - Knowledge of the fitness industry and what content resonates with fitness enthusiasts. - Excellent communication skills, able to engage with...
...aged 3–16 who are exploring educational programs to boost their child’s academic performance and confidence. Secondary Audience: Educators, school administrators, and professionals in education-related fields who might recommend Kumon. Corporate professionals and entrepreneurs interested in education for personal development opportunity for their children. Success Metrics: Engagement: Likes, comments, shares, and saves. Reach & Impressions: Overall visibility of posts across platforms. Traffic: Clicks to the website from social media platforms. Conversions: Sign-ups or inquiries about Kumon programs. Timeline: Pre-launch (2 weeks): Teasers (e.g., “Coming Soon: A Smarter Way to Learn”). Launch (1 month): Main campaign content rollout with frequent p...
I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.
Prototype for AI-Based Disease Monitoring Using Social Media Data Project Overview: We are looking for a freelancer to develop a simple prototype for a project that monitors disease-related trends using social media data (e.g., Twitter). This is a proof-of-concept project intended to explore feasibility, and we plan to expand it into a larger project once we get confidance. The main goal is to extract and analyze basic trends using natural language processing (NLP) and machine learning, along with simple visualizations. --- Scope of Work: 1. Data Collection: Collect a small dataset of tweets or public health data using the Twitter API or any other publicly available source. Focus on disease-related keywords (e.g., “flu,” “dengue,” or “outbreak&...
I'm in need of a skilled professional who can help with the extraction of text from my PDFs. This is an ongoing project with new PDFs coming in regularly. I need the code in a Colab notebook that i can run myself and upload new PDFs to run text extraction. Key Requirements: - Extract all text from multiple PDFs. - Store the extracted data into a CSV or data frame. Ideal Skills: - Proficiency in Python or similar languages for data manipulation. - Previous experience in text extraction from PDFs. - Familiarity with data cleaning and preparing data for analysis. The ability to work on a consistent basis and deliver high-quality work promptly is essential. Please provide examples of similar projects you've completed in your proposal. Example PDF is attached,
...Components: List/Feed of blog posts Pagination (endless scrolling) Sorting (by date, popularity, etc.) Search functionality for posts Libraries: RecyclerView, Pagination 3, SearchView 4. Comments and Feedback Module Purpose: To enable users to comment on blog posts. Components: Comment section for each blog post Like/Dislike comments Nested replies for comments User notification when someone replies Libraries: Firebase Realtime Database, Firestore 5. Push Notifications Module Purpose: To notify users about new blog posts, replies, or other important updates. Components: Notifications on new posts or comments In-app notifications Push notification handling Libraries: Firebase Cloud Messaging (FCM) 6. Media Management Module Purpose: To handle images, videos, a...
...Components: List/Feed of blog posts Pagination (endless scrolling) Sorting (by date, popularity, etc.) Search functionality for posts Libraries: RecyclerView, Pagination 3, SearchView 4. Comments and Feedback Module Purpose: To enable users to comment on blog posts. Components: Comment section for each blog post Like/Dislike comments Nested replies for comments User notification when someone replies Libraries: Firebase Realtime Database, Firestore 5. Push Notifications Module Purpose: To notify users about new blog posts, replies, or other important updates. Components: Notifications on new posts or comments In-app notifications Push notification handling Libraries: Firebase Cloud Messaging (FCM) 6. Media Management Module Purpose: To handle images, videos, a...
...and support live shows through our Instagram account. The ideal candidate will be capable of content scheduling, engaging with our audience, providing customer service responses to direct messages and comments, assisting during live events, and managing databases and invoices. Key Responsibilities: - Content Scheduling: Plan and schedule diverse content, including promotional materials, educational content, and user-generated content. - Engagement: Actively engage with our audience, fostering a sense of community and driving interaction. - Customer Service: Respond to direct messages and comments in a professional and timely manner. - Live Show Assistance: Provide backend support during live shows, including tracking purchases and assisting with customer queries. - Datab...
Pull all data of each publisher as we discussed + create an excel file as you did in the previous job. Delivery in on january 20th
I'm looking for a talented Virtual Assistant (VA) who can ma...should be able to create engaging and high-quality content including images/graphics, videos, and written posts. Experience with design and video editing tools will be an advantage. - Scheduling Posts: You will need to follow a content calendar and ensure posts are scheduled at optimal times for engagement. - Engaging with Followers: Building a community is key. You should be able to respond to comments, messages, and engage with followers in a positive and professional manner. Ideal skills and experience: - Proven experience as a VA or in a similar role - Excellent knowledge of social media platforms - Strong content creation skills - Good understanding of social media metrics - Proficiency in using social media m...
I'...need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Key Responsibilities: - Data entry of customer information - Email management - Spreadsheet work, including the use of pivot tables and advanced functions in Excel Ideal Candidate: - Familiar with MS Excel and Outlook - Capable of handling basic to intermediate data entry tasks - Able to manage emails efficiently Please provide your hourly rate, inclusive of all fees. The workload might be ong...
I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.
...files containing data downloaded from an SAP tool. The primary focus is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons. Your expertise and attention to detail will be cru...
...preference) Requirements: Exact Replication: The UI should mimic the design, responsiveness, and animations (if any) of the reference website. Cross-Browser Compatibility: Ensure the UI works seamlessly across popular browsers (Chrome, Firefox, Safari, Edge). Mobile-First Approach: The UI should be optimized for mobile devices and tablets. Code Quality: Clean, readable, and maintainable code with comments where necessary. Deliverables: Complete source code for the UI. Fully functional responsive web pages that match the reference website. Deployment instructions (if required). Timeline: Please specify the estimated time to complete the project. Additional Notes: Backend integration is not required. Focus solely on the front end. Flexibility to accommodate minor revisions afte...
I have a PDF file containing financial data that needs to be converted into an Excel spreadsheet. The data is structured in tables within the document. Ideal Skills: - Proficiency in Excel - Data conversion from PDF - Attention to detail Experience: - Prior projects involving financial data preferred - Experience with PDF to Excel conversion
My project involves developing a front-end interface that allows users to upload student forms, which will then be processed by the OpenText Intelligent Capture server using Captiva REST services with .NET. The uploaded documents will be analyzed to extract specific information. Key requirements: - Users will upload student forms in various formats, primarily PDF, Word documents, and Images. - The system needs to capture and display form fields from these documents on the next page. - Essential form fields to capture include educational details. Ideal skills and experience: - Proficiency in .NET and experience with Captiva REST services. - Familiarity with OpenText Intelligent Capture server. - Strong front-end development skills. - Experience in document processing and data extra...
I'm seeking an Excel expert to enhance a self-grading Excel sheet for beginner students. The goal is to make it more visually appealing and user-friendly based on an example file I have. Key Requirements: - Quick turnaround time (within 2 hours) - Experience in Excel - Ability to implement visual improvements such as color coding, formatting, and graphical elements - Potential for future projects if work is satisfactory The primary function of the Excel sheet will be visual data representation. Please apply if you can meet the requirements and deliver promptly.
I'm in need of a freelancer who can extract text from a PDF into an Excel Spreadsheet. The job requires basic cleaning and formatting of the data in the spreadsheet. Key Tasks: - Text extraction from PDF - Inputting data into Excel - Basic cleaning and formatting of the data Ideal Skills: - Proficient in Excel - Attention to detail - Previous experience with data extraction from PDF Looking forward to your bids.
Hi there, I need someone to manually copy and paste text and numbers from tables in a 90-page PDF document into an Excel template with five predefined columns. Key Requirements: - Combine split sentences into a single line. - Leave a blank line between paragraphs. - Adhere to specific formatting requirements as per the predefined template. Ideal Skills: - Excellent attention to detail. - Proficient in Excel. - Able to follow specific instructions meticulously. Flat rate 5 NZD Bonus: 5 NZD bonus for error-free, on-time delivery. Deadline - one day i.e. 15 Jan 25 Please start your bid "5NZD" I appreciate you reading my post
I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.
...a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with stakeholders to gather requirements and deliver solutions. Required Skills: Proficiency in Power BI and ...
I'm seeking a skilled professional to extract data from low-quality eFax PDF documents using various tools and techniques. This project primarily involves AI/ML data extraction, focusing mostly on text data. Key Responsibilities: - Utilize EasyOCR, pdfplumber, and OpenCV for document processing. - Implement with Python, , and Label Studio for annotation and user interface. - Apply spaCy for Natural Language Processing and Named Entity Recognition (NER). - Leverage PyTorch and Hugging Face's Datasets and Transformers within a machine learning framework. - Store metadata in PostgreSQL. Ideal Skills and Experience: - Proficiency in OCR, PDF processing, and image handling. - Strong background in Python and Next.js. - Experience with spaCy, PyTorch, and Hugging Face's T...
...Strategy:** develop a strategy tailored to objectives and audience and decide what to post, when, and how, to maximize impact. **Content Creation:** photos, graphics, videos, and engaging texts for posts and stories Everything to capture audience's attention. **Planning and Publishing:** schedule and publish all content according to the agreed calendar. **Interactive Management:** Respond to comments and private messages, maintaining an active and authentic dialogue with audience. This way, to build trust and strengthen the relationship with clients. **Pricing:** - €100 for 1 social network - €150 for 2 social networks - €200 for 3 social networks - €250 for 4 social networks - €300 for 5 social networks - €350 for 6 social networks - &euro...
I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date Clock-in Clock-out ...
I'm seeking an expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I ... Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company Name, Email, Mobile Phone, Linkedin acount
I need a visual dashboard created from my Excel financial data. This dashboard will primarily be used by executives, so it needs to clearly display cash flow and ROI information. Key Requirements: - Proficient in Excel and dashboard creation - Ability to visualize complex data simply and effectively - Prior experience working with financial data Ideal Skills: - Data analysis - Financial literacy - Excel expert - Dashboard design
...platform that integrates NFT creation, trading, and community engagement. The app should be built in Swift for iOS and leverage Ethereum and Polygon for its blockchain needs, with storage being decentralized via IPFS. Key Features: - NFT minting, buying, and selling - Interactive media creation (photos, videos, live drawings, and augmented reality content) - Comprehensive social features: likes, comments, shares, and personalized feeds User Authentication: - The application should support Biometric (Fingerprint, Face ID) user authentication Community Engagement: - The platform should include forums and discussion boards, as well as in-app messaging for community interaction Ideal Skills & Experience: - Strong expertise in Swift and iOS app development - Proven experienc...
...from the user's profile on a configuration site, which should be built in .NET C# and integrated with Stripe for payment processing. Key Features: - Filters: The extension must apply filters based on job title, location, company size, employment type, post date, distance, industry, job benefits, job salary, companies, experience level, and job workplace. - Data Extraction: The extension should extract information from the user's resume, cover letter, contact information, and experience details. Please refer to the following for examples: - Example Chrome Extension: :%20Job%20Application%20Bot/pgnfaifdbfoiehcndkoeemaifhhbgkmm - Config panel: I'm happy to provide a demo if needed. The ideal candidate for
I'm seeking a skilled professional to perform a detailed takeoff from my bluepr...comprehensive material list of quantities and costs breakdown for all trades, including electrical, plumbing, and carpentry. The final output should be an Excel spreadsheet, as I prefer this format for data analysis and budgeting. Key Requirements: - Proficient in reading and interpreting blueprints - Experience with construction material takeoffs - Familiarity with costs associated with various trades - Excel spreadsheet creation and data organization skills I do not have a specific template for you to follow, so creativity and an understanding of how to best structure the data will be key to your success in this project. Please ensure the Excel document is clear, logically organ...
I'm looking for a skilled Excel professional to help automate my spreadsheet, which I've been manually updating with annual measurement data (3D coordinates). The spreadsheet involves regression analysis and generating charts. Key tasks that need automation: - Updating formulas: Currently, I have to re-input the formula to accommodate the new data each year. - Data input: I want it to be as simple as entering the new data and the spreadsheet updates itself. - Chart generation: The spreadsheet produces various charts from the data, which currently requires manual intervention. - Running regression analysis: The spreadsheet includes regression analysis which needs to be automated as well. Ideal skills for this project include: - Proficiency in Excel, especially with...
PLEASE READ COMPLETELY PLEASE READ COMPLETELY PLEASE READ COMPLETELY This is truly a long term gig so READ COMPLETELY!!!!!!!! Daily Social Media Management Posting pre-prepared content across platforms like Facebook, Threads, and LinkedIn. Engaging with the audience through comments and messages. Scheduling posts using provided calendars and tools. Graphic Design Designing graphics in Canva based on detailed instructions. Ensuring the visuals align with the brand’s style, colors, and tone. Editing images as needed for social media or promotional campaigns. Email Communication Sending follow-up emails to RSVPs and leads. Assisting with email campaign scheduling and updates. Ensuring emails are accurate, professional, and timely. Sales Support Making follow-up sales ...
We have a platform in PHP and MySQL to manage the services we provide but we have never used it. Currently we manage everything with Excel but there are already many records and various people who work on the file. I need to load our excel database into the MySQL database and start using the tool. The excel database has 20.440 rows and 43 columns.
I'm seeking an expert in financial modeling with Excel to help construct a comprehensive analysis model for a retail center development project. This project will involve a construction loan, refinancing, and utilizing land equity from the landowner. Key Requirements: - Develop cash flow projections on a monthly basis. - Include critical financial components such as the Profit and Loss statement and Loan amortization schedule. - Conduct sensitivity analyses for interest rate changes, construction cost variations, and market rental rate fluctuations. Ideal Skills: - Proficiency in Excel, with advanced financial modeling skills. - Experience in retail development project analysis. - Ability to conduct and interpret sensitivity analyses.
...for an industrial site. - Experience with oil/sand interceptor pit design is a plus. - Knowledge of civil design software is essential. - Review existing drawings for service connections to the building and advise on requirements to connect pit to the local municipality's main sanitary feed to the site - Liaise and coordinate with Architectural, Structural and Mechanical consultants - Review and extract information from existing Environmental Site Assessment (ESA) - Assist Prime Consultant as required on Civil-related aspects of building permits to the Authority Having Jurisdiction (AHJ) - Review and comment on relevant product submittals issued by the General Contractor during the construction phase. - Provide information to prime consultant to enable to civil-related specs...
