Vba macro autogenerate dates names worksheet names jobs
...coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script t...
I need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be done not just this 3
Hello, I need to send a cease and desist letter and also file trademarks that can protect my many brands and family names.
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...on a mountain with a view of the Aegean (see photos attached). I want something minimal with neutral colors like the one attached below. The name of the hotel is “Mousonas luxury living”. Mousonas is a type of wind, therefore I would like a small symbol of wind as seen in the logo attached. Based on this logo I will then order 4 more logos for each apartment, which will be named with different names of winds. Please let me know if you have any ideas that would make my logo better. Any new ideas are welcome too. Thank you...
I need someone to gather a list of companies and individuals who offer cleaning services for the Bath, UK area. I need; Price per clean, name, email, telephone. This is for a 1 bedroom house. Dates will be random across the year and would need a cleaner with no contract, just a cleaner to call when needed. Need a list making of cleaners and prices for Airbnb turnover clean at Bath, UK.
...Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating product databases will be a maj...
...accurate predictions. Project Scope: 1. Preparation Stage: The freelancer will be responsible for identifying and researching all available sources of space debris data, both free and paid. This includes a comprehensive evaluation of data providers to ensure the data's relevance and quality. The output at this stage will be an Excel table summarizing the research, which will include provider names, links to data or registration, pricing (if it is a paid source), additional requirements from the provider, and descriptions of the data. We anticipate identifying up to 10 data providers. 2. Evaluation and Registration: We will evaluate the providers, register for their services, and handle payments if the data is not free. We will then provide the freelancer with access for f...
I'm in search of an amateur actor who is aged 20 years or older, to play a leading role in my school project. Here's what you should know: - Your Experience: As this is a casual endeavor, no professional acting experience is required. However, you should be comfortable taking center stage and carrying a narrative. -...significant portion of the script. You'll portray various emotions and, potentially, multiple aspects of a complex character. Ideal skills and experience: - Experience in amateur theater or similar productions - Ability to take and apply direction - Good memorization skills - Comfortability with performing in front of an audience - Reliable and committed to meeting rehearsal and performance dates If this sounds like a role you’d love to play,...
I urgently need a specialist to verify employment histories for potential employees. This task requires accurate, quick work, ideally completed by someone with experience in HR processes or a similar background. What you need to do: The project is divided in 2 milestones. 1. the task is to submit the employee documents to the clin...employment history This task takes precision and attention to detail; your due diligence can have a significant impact on my organisation. Please only apply if you have relevant experience and can handle this sensitive task with professionalism. Key responsibilities: - Verifying the employment histories of potential candidates to ensure reliability and truthfulness. Please note, Employment dates and all the information in the certificate must be ...
...Features: - Entertainment aspects to be discussed in greater detail at a later stage within the project. Creativity and ideas for entertainment-focused applications are a definite advantage. Task Management Features: - The app must primarily include the ability to manage tasks. While specific functionalities were not listed, potential features of interest could be creating tasks, setting due dates, and assigning tasks. Knowledge and experience in designing user-friendly task management components will be highly valuable. Freelancers are encouraged to ask questions if further details are needed before placing a bid. The ideal candidate will have a proven track record of designing and developing successful entertainment and productivity apps. Integral to this project is the abil...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, est...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
As the name suggests, i am looking for somebody who could potentially make me some software that can scan the DVSA government website automatically and be able to find me any test cancellation dates. However, this wouldn't be on the public dvsa website, but for the driving instructor portal (only accessible with a valid government gateway ID [which i will provide]). Further details will be ironed out.
...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...
More details: What format are the company names provided in? pdf Do you have the capability to extract text from the PDF files? Not sure How soon do you need your project completed? ASAP
...information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accuracy and reliability of the scraped data. Customize the scraper to meet our specific requirements and adapt to any changes or updates in the target websites. Deliver the scraped data in a timely manner, adhering to project deadlines. What We're Looking For: Proficiency in web scraping techniques and tools. Attention to detail to ensure the accuracy and quality of the collected data. Ability to customize the scraper to target specific criteria, such as states and names. Strong communication skills to provide regular updates on progress and collaborate effectively wi...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm in need of an experienced mobile app developer with proficiency in PayPal API integration. The app is inten...out as part of the testing process Expected Output: - A smooth, intuitive cross-platform app - Seamless and secure payment processing utilizing PayPal. Candidates should have a strong portfolio showcasing similar projects. If this sounds like you, please bid with your plan of action and expected timeline. The Project: There is a requirement to develop a piece of code that; 1. Retrieves the names of four individuals from a server 2. Sends a single payment to the four individuals Note: As the app will be used by many different users, hard coded PayPay IDs is not possible. Upon completion of this small piece of development, the code will be integrated into anot...
...responses should organise them into yes and no groups. This will help us automate repetitive tasks and sharing of information to groups of people. - CRM Management: I am an agent to film ans supply extras for background. This requires searching for certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send their profile to the production for approval. The approved staff then get added to a whatsapp "mailing list to communicate with as a group but each person receives a private message. - Contact List Management: I also need the CRM to have a robust Contact List management system, to help keep track of our clients and their interaction history, ...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
...information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accuracy and reliability of the scraped data. Customize the scraper to meet our specific requirements and adapt to any changes or updates in the target websites. Deliver the scraped data in a timely manner, adhering to project deadlines. What We're Looking For: Proficiency in web scraping techniques and tools. Attention to detail to ensure the accuracy and quality of the collected data. Ability to customize the scraper to target specific criteria, such as states and names. Strong communication skills to provide regular updates on progress and collaborate effectively wi...
...Reference checks. Key Requirements: - Conduct Employment History Check: I require the candidate's employment history to be thoroughly checked for the past 3-5 years. It is crucial to verify the companies worked for, positions held, and reasons for leaving. - Perform Reference Check: The reference check should delve into the candidate's past employment, focusing on the accuracy of the employment dates, job titles, and performance evaluation. Ideal Skills and Experience: - Experience with HR background verification. - Proficiency in conducting background checks. - Excellent knowledge of employment laws and regulations. - Strong communication and investigative skills. The selected candidate will need to provide detailed reports on the findings of both the Employmen...
...two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with dates arranged horizontally. 3. Yearly Budget Forecast: I'm also seeking a user-friendly and easily readable yearly budget forecast. I hope the project can be delivered ASAP. Your bid should demonstrate your understanding of these requirements and also provide an estimate of the fastest possible completion date. Let's make this management tool an asset a...
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I am seeking an expert in email scraping for the purpose of building a marketing database. The ideal candidate can efficiently scrape emails and the company names. Key Aspects: - Attention to detail to ensure all relevant emails are scraped accurately and company name is also with. - Quick turn around, the project should be completed within a month. - Extensive experience in email scraping and database construction. I need this in a google sheet document. The approx amount of names/emails is 12.000 - 14.000 on the website. I need a fixed price offer and also time frame for this.
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I'm in need of a logo designer to create unique logos for 4 related companies. The designs should have a similar aesthetic and be differentiated beyond the company names. the companies are: 1. Green Magic Hemp - a grower of medicinal cannabis plants 2. Oceania Hemp Bio Diesel - a company growing hemp and using its oil to create bio diesel 3. Green Magic Fresh - a company growing large quantities of fruit and vegetables and suppling the national retail market - no web site yet 4. Food Security Training Institute - teaching global customers how to grow inside covered growing environments and selling the produce to a number of retail and whole sale organisations. Key Requirements: - Cohesive Design: The logos must share a consistent style
I need a database for the UK market, with a focus on company names and Email ID. Key Points: - The project primarily involves creating a comprehensive database for the UK market - The main data points to be included are company names and Email ID's - Information can be extracted from Yellow Pages, Business Pages, Associations, Business Chambers and similar. - Accuracy of data, specially Emails - Sample File of Required database is attached - To start with we require 10,000 records. - Will pay INR 0.60 per record. Ideal Freelancer: - Prior experience in creating detailed databases - Proficiency in data gathering, scraping and organization - Familiarity with the UK market would be a plus Please include your relevant experience in your application.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates and seek clarif...
...in need of a skilled Korean calligraphy artist (who is Korean itself and knows spoken Korean) to create custom name pieces for me in your unique style. Key Project Details: - I'm looking for someone experienced in Korean calligraphy to craft names in Korean in your own calligraphy style. The style can be Traditional calligraphy, Modern calligraphy, Brush lettering, or a fusion of your own. - The names can be either in Formal (Hanja), Semi-formal (Hangul), or Casual (Stylized Hangul). You are free to choose the style that you feel best suits the names. Application Requirements: - Please include examples of your past work specifically in Korean calligraphy. I'd like to see a range of styles to gauge your versatility. This project is a great opportunity ...
I'm in need of a developer to add a custom subscription multi-step ordering functionality to my new Woocommerce site. The site will be built using Divi, and I'm aiming for a modern and sleek design. The custom subscription package should allow customers to: - Choose delivery frequency - Select product combinations - Use a date picker to specify delivery dates The ideal freelancer for this job should have: - Proficiency in Woocommerce and Divi - Prior experience in setting up custom subscription packages - An eye for modern and sleek design This is a sample for reference: Looking forward to seeing your proposals. Thank you.
...In-depth understanding of Wix and Shopify platforms - Proficiency in product listing across multiple categories, preferably clothing - Excellent attention to detail to ensure accurate descriptions and optimal keyword use - Experience with product photography or digital photo editing is an advantage - download product images and editing to the theme and layout of our website - Come up with product names, product description that is SEO optimized - Work closely with founder to fix price and work on website Required: - A desktop, Laptop that does not lack - Video Call capability that is clear - A stable and reliable wireless connection Having familiarity with the fashion industry would be ideal. This role requires a diligent professional who understands the dynamics of online ma...
I'm on the lookout for a competent and creative designer to create business cards for my co-founder and me. The goal is to have cards that portray our brand in a sleek, minimalist way, embodying professionalism and simplicity. Below are the specifics: - Our contact details, including names, website URL, social media handle, and email addresses, need to be incorporated into the design. - We favor a color scheme of green, light brown, black, white, and an offset of yellow. We’ll provide our current logo to guide your color choices. - We're seeking a minimalist and clean design. Less is more for us. The design should be clutter-free and easy to read, but still visually appealing. The ideal freelancer for this task should be: - Experienced in graphic design, particular...
...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...
...experience in Odoo to implement accounting reports in Odoo saas~16.3+e (Enterprise Edition). The reports should be exportable as XLSX or CSV files. Required Reports: 1- Account Payables Display tabs for each supplier. Information on invoices issued, quantity, and payment dates. 2-Inventory Summary Display existing inventory as of a specific date. Price and cost information. 3-Sales Tax Display total sales within a specified time period. Consider both taxed and untaxed sales. Additional Features: *Ability to specify dates for the report results. Example: For the "Inventory Summary FEB 2024" report, be able to search for results for January or other previous months. Access and Meeting: Upon project acceptance, access to our Odoo system will be provided. A video ...
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
...are thrilled to announce that an exciting webinar on our revolutionary commercial real estate marketplace. Join us at 1pm EST on April 20th to discover groundbreaking insights into the future of commercial real estate. Instructions: **MUST DIAL INTO THE WEBINAR *** **DO NOT MENTION THIS CONTEST AND PAYOUT ON THE WEBINAR *** Register with American Sounding Names: We kindly request all participants to register using American sounding names to maintain the authenticity of the event. Engage in the Webinar: Join the webinar and actively participate in the discussion. At the end of the session, you'll have the opportunity to ask questions related to the commercial real estate market. Take a screenshot of your question and upload to the contest entry so that we can pay you ...
...company information and the logo designs. Social Media Graphics: Suitable profile and cover images for Facebook, Instagram, Twitter, Reddit, and LinkedIn in appropriate formats. Other Printed and Digital Materials: Company letterhead, envelopes, brochures, presentation templates, and other corporate documents. Email Signatures and Templates: Designed to maintain brand integrity using sample names and departments. Delivery Formats: Print-ready formats (.ai, .png, .pdf, .jpg) Including color palettes Special Notes: The logos must be effectively usable as icons alone on social media, mobile applications, and other digital platforms. We prefer professional, experienced designers with verifiable past work. We are looking forward to proposals from talented designers who can bring...
I require a professional with a high level of expertise in web scraping and API integration to assist with a critical project. Here are the specifics of the project: - I need you to scrape data from , a website where we dropship our designer clothing products. - Specifically, I need the following details scraped: Product names, Product Colour, Product Sizes In Stock & Not in Stock, Product Prices (Only Black & Grey Pricing, not red sale price), and Search Key. - The scraped data should be automatically updated on a daily basis. - The scrapped data should be integrated into our Shopify store through an API bot. The ideal candidate should have a proven track record of working with similar projects and should be able to tailor the solution to our specific needs. Please inc...
...spreadsheet and comprehensive report I can present with confidence. Note* 1).The PASNAP ( Union name) 2023 LPN & RN spreadsheet shows the license years (years of experience if you will) and shows both salary in 2023 and current salary in 2024 2).The FA (Fair Acres nursing) leadership file highlights all Nurse supervisors/managers ( uses this for comparing salaries. (also note their start dates are listed in column "O") 3).The Fair Acres employee list is a list of all employees. I've highlighted in "green" & "pink" the LPN nurses and the RN nurses ( nursing category employees notes on file) you are to compare the .The FA (Fair Acres nursing) leadership file and the Fair Acres employee list (pink & green). This is the data y...
I need an experienced professional to visit Usiminas in Brazil for the purpose of verifying a previous employment certificate. This involves: - Confirming the work experience stated. - Validating the job title and responsibilities provided. - Ensuring the employment dates align with what's recorded. Targeted Address for Visit: Usiminas, Ipatinga - State of Minas Gerais, Brazil Issuing Authority Name :Usiminas Brazil Task : Verify the provided document by form filling and get geo-tagged pictures Please note, you'll only be authenticating one certificate. A background in HR, employment screening, or due diligence would be helpful for this project. Strong attention to detail is essential, alongside fluency in Portuguese and English. Familiarity with Brazilian business ...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
2 excel files with VBA macro as per customer requirement
...topics with you. select topic and then google it looking for the research paper. then find the survey paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP. Your prompt attention and quick work turnaround will be highly appreciated. Research Report 1. Title: [Insert your research title here] 2. Names: [Insert author names here] 3. Department: [Insert department name here] 4. Email: [Insert email address here] 5. Abstract (9-10 lines): Research area: Briefly explain the area your research focuses on. Problems: Identify the key problems existing in the research area. Solutions: Briefly mention the solutions your research proposes. 6. Introduction (20 lines): General overvie...
...Donors and trading partners) for viewing, analysis and with rights editing member profiles. Membership Subscription Tracking Design a system to track membership subscriptions and payments. Record subscription start dates, renewal dates, and payment history. Allow for online subscription tracking with the flexibility to transition to offline tracking based on user capacity. Member Services Tracking Develop modules to track member services such as training sessions attended, donations received, and other relevant services provided. Capture details of services rendered and associated dates for reporting and analysis. Implement data import capabilities and offline access options for managing member services. Trade References and Crop Production: Create a section to re...
