Vba macro scripts using excelcông việc

Hi Ashish, this is for the tasks I emailed about.

I'm in need of an expert who can develop a risk assessment model for Cmbs SASB. The m...goal of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss further details and expectatio...

...need of a skilled professional to assist with my video project, which is centered around the creation of promotional content. Key Tasks Include: - Video Editing: You'll be responsible for polishing and enhancing the raw video footage. This includes tasks like trimming, adding transitions, and ensuring a high-quality final product. - Script Writing: Crafting engaging, persuasive, and informative scripts that perfectly complement the video content. - Transcription: Converting the audio content of the videos into written form. My primary goal with this project is to create compelling promotional content that captivates and engages the target audience. Ideal candidate for this project should: - Have prior experience in content creation, with a focus on video editing and sc...

...IP agreement. There are several important elements we need built, though we are not yet fixed on a development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or similarly licensed code such that it is legal to use the code or derivations in a commercial software. Freelancers should mention which development stack they would use. There are lots of Shopify repositories here: along with lots of code on the web

I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.

...developer in Pine Script for the development of a trading strategy. The script will be used specifically on the TradingView platform, so familiarity with this system is a must. Key Requirements: - Pine Script Proficiency: Proven experience in developing complex and efficient scripts on TradingView. - Trading Strategy Development: Understanding of market dynamics and indicators to create a successful trading strategy. Previous experience in this field is a plus. - TradingView Platform: Experience in deploying scripts on the TradingView platform, knowledge of its limitations and capabilities. This project requires an individual who is not only technically proficient but also has a good understanding of trading strategies. If you have a strong track record in this niche, I&...

I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...

We are a dev team and seeking a highly experienced individual dev with in-depth proficiency in Laravel, Vue, and Flutter. Your responsibility will comprise the rebranding and extending of existing Codecanyon scripts. - **Script Rebranding**: I need a meticulous freelancer able to successfully rebrand scripts to brands of clients. - **Extending Scripts**: Your tasks also include extending Codecanyon scripts by adding extra functionalities, ensuring consistent, flawless operation , implementing APIs and adding the functionalities in the existing flutter app, testing, fixing any bugs to ensure smooth operations of the system. Pay : 1. INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. ...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

1) Implement MOSSE with SCRFD for Java Android 2) Implement it in our app by replacing MLKit and connect it to our engine 3) Replace our engine with ARCface The App must be fast and robust. For the 1st milestone deliverables... implement MOSSE tracking with SCRFD for Java Android running the C++ libs. Create a demo app that runs detection and tracking and: 1. shows boxes and tracking ID for each face detected. 2. model size 3. fps 4. face confidence 5. screen resolution 6. Allow the app to run on Android's both front and back camera 7. add a zoom feature if supported by the device's camera. 8. add an option to upload and process recorded videos. no need to do ui/ux design key point is to integrate c++ library with android app Need to do some test before start Check SCRFD and...

I'm in need of a NASAL MASK design whose primary focus is to be both user-friendly and effective in treating sleep apnea. Key Requirements: - Detailed Design with Dimensions: I require a ...comprehensive design with precise measurements and specifications. This is crucial as the mask should fit comfortably and effectively for the user. - Adjustable Straps: The design must include adjustable straps. This is essential as it will allow the user to customize the fit, ensuring comfort and effectiveness during use. Ideal Skills: - Proficiency in Solidworks: The design should be created using Solidworks, so proficiency in this software is a must. - Experience in Medical Equipment Design: Experience in designing medical equipment, particularly for sleep apnea treatment, would be hig...

For my festival, I'm seeking a skilled web developer who is proficient in Bootstrap to create a website similar to the Festy Template. The primary functions of the website are to: - Promote the festival - Provide comprehensive information about the festival - Offer vendor signup with a contact form - Provide schedule and performer signup The project scope includes the development of less than 5 webpages with: - Textual content - Images - Videos A successful freelance web developer for this project should be experienced in Bootstrap and have a strong understanding of creating effective and engaging festival or event website pages. They should also be adept at incorporating various types of content, including text, images, and videos into their designs.

...GB of RAM. If I were to free up 12 GB of RAM, then I could open [takes out pencil and paper, calculates furiously for a few minutes] 120 websites. That limitation would not bother me because I plan to scrape not more than a hundred pages each day. In other words, I do not plan to scrape hundreds of thousands, nor tens of thousands, nor even thousands of websites each day. I plan to use your scripts on a relatively small scale of not more than one hundred websites each day. ******* TESTING ******* You must test your script on Linux Mint 21.3 Cinnamon Edition to ensure that it runs properly on Python 3.10.12, on the current stable version of Google Chrome, on Linux Mint 21.3 Cinnamon Edition. I do not care if your script runs on any other operating systems or any other browser...

...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, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

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.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...that can send out automated emails through Gmail. This task should be accomplished with an appropriate scripting language for Gmail's environment. Key Requirements: - Send out notification emails. - The notifications will be for scheduled reminders and service status updates. - Targeted audiences are all users and selected groups. Relevant skills include proficiency in JavaScript (as Gmail Scripts commonly employs this language) and familiarity with Gmail's API. Knowledge of handling scheduled tasks and interaction with user databases is also beneficial. In short, I'm looking for a coding and Gmail expert who can automate the process of sending important reminders and status updates to our users. The system should handle all users while also having the option t...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would ...

...with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scripting using...

...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 Techni...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm looking for a developer to create a simple starter trading script. This is can be based on another script and does not need to be written from scratch. Develop a simple script that buys a particular cryptocurrency when it drops X% and sells it when it recovers Y%. Onc...like AWS that I'd have to manage and continually monitor for uptime, etc. The script should allow for easy parameter adjustments. Considerations for adding various cryptocurrencies such as Litecoin, Dogecoin, etc. Preferably, the script should be hosted on a cloud platform to alleviate personal management responsibilities. How to Apply: Please provide examples of previous cryptocurrency trading scripts you've developed, along with your approach to meeting the outlined requirements. Looking for...

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.

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 ...

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

...and want to set up several plot-driven chatbots from the perspective of characters involved in specific scenarios. Looking to set up a chatbot that would guide a player through pre-determined story in messaging format. To enable world introduction and immersion, we want to set up chatbots in the style of "solo text RPGs", with characters actively engaging players to drive the storyline. We have scripts for several stories, featuring original characters, and are looking to set up chatbots that would allow these characters to proactively message the player and guide through the pre-determined plot, reaching a specific conclusion. Let's say a character is a player's roommate who forgot a book at home in a different town. The character proactively messages the p...

I am seeking a competent scriptwriter and researcher who is knowledgeable about Indian history, culture, and other interesting...affairs, and environment. Ideal skills include: - Strong command of Hindi language - Proven expertise in scriptwriting - Skilled in researching and Sourcing. - Background in YouTube content creation is a plus. Freelancers who apply should provide the following: - Evidence of past work (preferably related to Indian content) - A written sample using a topic that I will provide. The right candidate should be able to create engaging scripts that are well-researched and accurate, yet easily comprehensible to the average viewer. Do you have the passion and the skills to help bring unexplored topics to life on our YouTube channel? I look forward ...

I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The c...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

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...

I'm in need of a skilled scriptwriter who can craft a compelling Spanish script for a 2-minute educational corporate video. The aim of ...script for a 2-minute educational corporate video. The aim of this video is to educate professionals and companies about a specific topic. Ideal skills would include: - Native Spanish proficiency - Strong background in scriptwriting - Experience in creating educational content - Understanding of corporate communication - Ability to write engaging and informative content - Familiarity with video scripts and voice-over requirements Your script should be: - Succinct yet informative - Able to convey complex ideas in an accessible way - Appropriate for a professional audience Please share any relevant experience and provide a sample of your wo...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insight...

I'm seeking a highly skilled developer to integrate Dialogflow into my ManyChat chatbot for the primary purpose of customer support. Ideal Skills: 1. Previous experience in Dialogflow integration 2. Expertise in chatbot development for customer support. Your responsibilities will include: 1. Create a HTTP request inside ManyChat flow builder that return the answer from Dialogflow, so I can use this answer in my chatbot. A successful completion of this project involves creating a chatbot that can effectively handle customer queries, troubleshoot issues, and provide instant responses. The end product should be a tool that enhances our customer servicing system, saves time, and improves service quality.

I'm seeking a skilled dot net developer to focus on major web development tasks. The core responsibility of the project will be functionality and programming. Key Tasks: - Implement a user registration system - Develop a shopping cart system - Convert existing PHP scripts to Dot net. Ideal Skills and Experience: A deep understanding of Dot Net, is a must, along with substantial experience in web development, specifically in functionality and programming. Proficiency in both PHP and Dot Net, specifically converting scripts from one to the other, is critical. Finally, hands-on experience with user registration and shopping cart systems is a significant plus. Don't hesitate to send me a message if you have any questions. Let's create something great togeth...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

Hi, As discussed in meeting , We are going with Phase 1

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

Hello, I just need a quick solution to send Whatsapp message using twilio API. In my twilio account, I have already [Whatsapp Business Account ID], [Meta Business Manager ID], [WhatsApp number] That is it. Thank you for your time and look forward to working with you.