Vba code to open excel file from folder and copy data jobs
...editor/content creator to produce three short video adds I want to use to announce an upcoming Alumni Reunion/Networking event on various social media platforms. The videos should be less than 1 minute in length, three different videos. You can use any music that you see fit but you need to have a good eye for visuals and a knack for storytelling. Key Responsibilities: - Creating engaging, 3 short videos for Facebook, TikTok, and YouTube - Ensuring the videos are less than 1 minute in length - Using royalty-free music effectively - Showcasing strong editing and storytelling skills -The videos must relay these key information 1. Name of the event is 'Poly Networking Event' 2. The event will be held on July 20, 2024...
We are a Chinese company, we need someone in India who has an Apple ID to test downloading, registering and using our APP, and the whole process should be recorded in a screenshot video.
...portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel...
...for in this API include: - Provision of Real-time data updates - Implementation of robust Security measures - Seamless Integration with existing systems - Development of a user-friendly Back-end and front-end infrastructure for an investment and trading app. - Connection of accounts in Forex, Stocks and Crypto brokers and exchanges to show live and historical statistics - Copy trading / social trading / PAMM with risk management features (on the next project) - Connection of startup business and real estate accounts (on the next project) Key Skills and Experience: - Proficiency in Python, Ruby on Rails and other relevant programming languages and frameworks. - Experience in creating APIs wi...
...Washington Dodges firsthand account the night the titanic sank. Key Details: - Emphasize on being a firsthand experience from Washington Dodges perspective - Needs an engaging, educational feel to the flow of the video. Any ideas are always welcome to make it better. Ideal Skills: - Background in writing or creation. - Creative video editing skills. - Experience in making YouTube videos. - Need at least 3 attention grabbing thumbnails to pick from, any skills in this area This project brings engaging storytelling and history from a firsthand eyewitness perspective, so any previous work in this area will be a bonus. I'm excited to see how we can educate and entertain together with this video project....
Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by whi...
Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
Overview We are in search of an exceptionally talented designer to craft an innovative and intuitive mockup for a web application focused on optimizing the recruitment process for various users. It is crucial that the submitted designs are entirely original. Submissions that utilize pre-existing templates or closely mimic designs from platforms like ThemeForest will be outright rejected and may receive a negative review. The design must adhere to the features specified in our project outline while showcasing a distinct and fresh aesthetic. Design Requirements 1. User Management -User Registration/Login: Separate workflows for candidates and companies. Each form should gather specific information as per the provided documentation. Design sh...
I am on the lookout for a researcher who can access and scan articles from a specific arabic language journal held in the Bibliothèque nationale de France. The journal was published in France. I have confirmation that it is held there. (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
I require a custom QR code generator that outputs in SVG format. These QR codes will encode vCard data for contact information. Additionally, I would like the following features: - The QR code should be in the shape of Porsche Crest logo. - The ability to customize the colors of the QR codes. - Support for integrating custom logos or images within the QR code design. Ideal skills and experience for this project include: - Proficiency in SVG format for QR code generation. - Experience with encoding vCard data. - Strong understanding of image manipulation for custom colors and logo integration in QR codes.
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm seeking a creative individual who can shape a portfolio for my architecture portifolio , showcasing ...projects - Experts in architectural design are preferred, as you'll ' be responsible for picking out stunning visuals and marrying them with concise, descriptive copy. - Specific tasks include selecting images, formatting the portfolio layout, and writing brief descriptions for each project. - A strong understanding of architecture and experience designing visually compelling and professional portfolios is a must. - The ability to communicate the unique vision of each project through your descriptions and your choice of visuals is key. Your aim is to make each project shine and appeal to pote...
...a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I ...
...working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control characters req...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the numb...
I am looking for an experienced freelancer to conduct a detailed case study on the implementation of a Zero Trust architecture in the banking sector, analyzing the economic impact of this transition.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
i need a new logo with the name " nolan & jasiel" and below "construkt" is for a construction businness , i need very class and luxury logo with gold color . not copy paste plz from pinterest or canva only custom logo and not ai also . thank you
...Dafny developer to support me in the completion of existing code. I need him to pass verification of the code by the instructions exactly. it requires knowledge in proofs, using lemmas. Key Responsibilities: - Complete existing code in Dafny - Conduct code verification and ensure it passes successfully - Ensure the code is coherent and properly structured Requirements: - Proficient in Dafny - Extensive experience with complex algorithms and data structures - Able to work with well-documented code and project requirements - Strong problem-solving skills - Excellent communication skills, as we will need to discuss certain parts of the code Prior experience with similar proje...
i need a new logo for a barber with the name " N&J" and below "elite barber " i need something luxury with initials i dont need copy paste of pinterest or ai logo , or canva i need unik and custom logo . make your best
I need a diligent freelancer to copy and paste text for me. Key Project Details: - Copy and Paste: The task involves copying text from one source and pasting it into another. - Source of Content: The text will be sourced from various online platforms. - Timeframe: I need this task completed urgently. Ideal Freelancer: - Attention to Detail: It is crucial that the text is copied accurately. - Speed: Given the urgent nature of the project, a quick turnaround is essential. Please provide your experience with similar projects and your availability.
I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
...incredibly adept and experienced in Microsoft SharePoint and particularly MS Viva suites. The need is to improvise and enhance a few specific functions which include: - Document Management: However, it remains undecided whether the structure would be folder-based or metadata-based tagging. Suggestions are welcome. Also, make sure version control is facilitated. - Collaboration Tools: You would be required to include and set up some essential collaborative tools like document sharing, team calendars, and discussion boards to ease out internal communication and coordination. Moreover, a fundamental task would be to automate workflows to increase operational efficiency. The ideal candidate would be someon...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - ...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be req...
...converting my existing logo into various file formats. Requirements: - I already have the logo, I just need it converted into PSD, JPG and PNG file formats. - The logo will be used for printing on shirts, so it's important to ensure that the converted files are high-quality and suitable for this purpose. Preferences: - I have specific color preferences for the logo and would like the designer to match the colors to the copy sent. - The font and typography used in the logo are the same as the image I've sent, please ensure this is kept consistent when converting to the different file formats. Ideal Skills: - Proficiency in graphic design and editing software - Experience in logo desi...
1. Create a chatbot. 2. Use an open-source LLM. 3. Use an iterative method to get a very large response with some custom logic( I will explain it ) . 4. Add a button in the chatbot. When enabled, it can show responses from public sources; otherwise, it must show results from a private source, such as a Pinecone database. Additionally, there should be a page where I can upload my text and PDF files. The response will be displayed like ChatGPT, with a typewriter effect.
I'm looking for a professional who can extract specific text content from a website and organize it into different categories.
I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This work will prepare the files for our in-house frontend developer to implement into our site. Key Responsibilities: - Translate Figma design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages. The su...
...expertise in SEO and familiarity with ChatGPT to craft a 1000-1500 word article. The primary objective of this article is to ensure it's optimized for SEO to achieve high and fast ranking on search engines. The content should be informative and engaging and meet the needs of SEO professionals. Ideal skills and experience for this job include: - Proven track record in content creation, particularly SEO-optimized articles - Knowledge of LSI keyword extraction - Experience with ChatGPT or a similar AI writing tool - Strong understanding of current SEO best practices - Ability to use Visual Studio Code for collaboration and development The successful candidate will be able to deliver a high-quality, ...
...software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In ...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to...
...drawing for our margarine plant process. This project requires the completion of 1 P&ID done in AutoCAD. Files must be delivered in DWG and PDF (monochrome) format and adhere to best drafting practices for P&IDs. Please do not bid if you lack direct experience with P&ID drawings for industrial processes. We will provide the PFD. Additionally, the process must be simulated using HYSYS, with the simulation results included as part of the project output. The project must be completed in 5 days. Project Details: - Create a standard P&ID from the provided PFD. - Simulate the process using HYSYS and include the simulation results. - Use of layers is required and should be consistent throughout all drawings. Layer groups should be logi...
I'm looking for a skilled photo editor who can remove six palm trees from an image and fill in the space to make it appear as if they were never there. The aim is to blend the background seamlessly. Retaining high detail in the remaining parts of the picture is critical. Your expertise in photo manipulation and detail-enhancement will be a great fit for this job. High-level proficiency in using photo editing tools such as Adobe Photoshop or GIMP is essential. Strong attention to detail is also key to ensuring the picture maintains its natural look. If resolution can be increased, that is a plus. Keeping the cost down is important.
I'm in need of someone to take the following designs and redraw them using photoshop or illustrator. It's a straightforward design. * Key Skills: 1. Graphic design 2. Logo design 3. Creative direction * Ideal Experience: 1. Have previously redesigned logos. 2. Experience in creating intricate logos. 3. Understanding of color psychology would be advantageous. Remember, I'm not necessarily out to recreate the wheel here, but I'm definitely looking for a more refined, sophisticated look.
I'm looking to develop a landing page with the primary goal of capturing leads from businesses. Key Requirements: - **Lead Generation Focus**: The primary purpose of this page is to encourage businesses to provide their contact details. - **B2B Audience**: The page should be tailored to appeal specifically to businesses, with language, design, and content that resonates with their needs and challenges. - **Simplicity**: The process for capturing leads should be clear, simple, and not require an overwhelming amount of information from the user. Ideal Freelancer: - **Experience in Landing Page Design**: You should be well-versed in creating landing pages that are optimized for lead generation. - **Understanding of...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN&rdqu...
I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fine or a scanned copy.
...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projec...
I am looking for expertise in React Native. The first module of the application is straightforward: it involves taking a picture and saving it to a local folder. Subsequently, the pictures need to be uploaded to Google Drive or a similar shared drive. The goal is to take pictures, extract data using machine learning and OCR. I can make payments, but they will be small and incremental. Additionally, I am looking for someone proficient in leveraging ChatGPT and other AI/LLM development tools. Looking forward to your prompt response.
We have Andorid TV app built in OS 9 chipmunkband seem to have problem working in Andorid boxes 10 and 11 but work on phone no problem and So we think we may need to upgrade gradle and some depencies Also we need package changed so the upgrade is done it will installed and not conflict with exsisting apps that are same Build .so os will see as a different app Attached are two soure codes similar
I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization techniques
...the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately 1500 words each, and should be generated automatically. Key requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please let me know how many y...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within ...
