Excel macro vba codingKazi

I am seeking a skilled designer with experience in both web and logo design to create a professional and corporate style website for my business. Specifically, the website must include:...design to create a professional and corporate style website for my business. Specifically, the website must include: - A contact form to facilitate communication between us and our clients. - A portfolio showcase: An easily navigable section for us to display our past work and achievements. - A blog/news section, to keep our clients updated on latest developments. This project requires not just coding skills, but also a keen eye for sleek, corporate design to ensure the website aligns with our professional image. Experience in creating similar professional corporate websites would be a significant ...

Need web developer to work with team

I am on the lookout for a season...detailed historical rain data for Camden County, New Jersey, spanning the last 2 years. Your key tasks will include: - Gathering and analyzing rainfall data specifically for Camden County, NJ - The data should cover a period of the last 2 years - Present the data in an Excel format Ideal candidates should possess expertise in the following areas: - Meteorological data gathering and analysis - Familiarity with weather recording instruments and systems - Proficiency in transforming raw data into actionable reports - Firm grip on Excel for data input, organization, and presentation With your contribution, this project can march forward with key weather insights for Camden County, NJ. I look forward to hearing from those with a knack for ...

Project Description: We are a transportation company specializing in vehicle transportation across the United States. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions within t...

list of about 150 organizations (in docx). Your job is to: — transfer the list of organizations to Google Sheets (or Excel) (just enter the name, not description) — for each of them add in 7 columns: acronym (if there is one), a website, contact email address (office or other main email, not webmaster), city (not whole address, just the city), country, year founded (establishment year), English Wikipedia link (if the organization does not have a Wiki page, leave empty)

preferably a VBA solution, as per file, when click the 'generate' button to have multiple customer's details into one row in next sheet

Project Description: We are a transportation company specializing in vehicle transportation. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions within the company. Key Features:...

I am seeking a freelancer possessing a strong command over Excel, VBA, and familiarity with Solver and Holt’s Winter Smoothing. Your task will entail: - Building a sales forecast analysis model using VBA in Excel. Detailed experience with Solver and Holt’s Winter Smoothing is crucial, as these tools will be heavily relied upon for seasonality adjustments and trend forecasting. - Developing a well-documented mini report highlighting the process, results, and interpretations. Effective communication and report writing skills are essential. - Incorporating historical sales data provided by me for analysis. Being able to interpret and manipulate large data sets is a critical component for this job. Previous experience in sales forecast analysis or simi...

I'm seeking a proficient Python programmer who can build effective scrap...and LinkedIn profiles. Your task will include: - Using Python with Scrapy to collect desired information. - Developing scripts that can identify and retrieve the services provided by the mentioned sites, along with their relevant contact details. - Ensuring that the scripts can also gather a comprehensive list of requirements from LinkedIn profiles. - Lastly, providing the compiled data in an Excel file format. Experience with Python and Scrapy is vital, and a firm understanding of web scraping and data manipulation is necessary. A proven track record in similar tasks would be advantageous. The freelancer must also be aware of and adhere to the legal boundaries around web scraping to avoid any potentia...

I am seeking a versatile, full-stack developer to assist in the creation of an informative website and utility mobile app. Ideal Skills and Expertise: - Comprehensive knowledge in both front and back-end development - Familiarity with a variety of programming languages as I do not have a preference - Experience with bo...Familiarity with a variety of programming languages as I do not have a preference - Experience with both website and mobile app development - Ability to translate my ideas into a user-friendly digital platform Project Objectives: - Develop a secure, mobile-friendly website that serves as an informative platform - Create a utility app that complements the website and enhances usability - Use best coding practices ensuring the website and app perform optimally on a...

I'm seeking a proficient Python and Javascript trainer to guide me in developing a specific web application. Your role won't just be to explain the fundamentals, but to provide hands-on training throughout the development process. Skills and Expe...and Experience: - Proficient in Python and Javascript - Proven track record in teaching programming - Experience in web application development The perfect trainer would help me understand the languages at depth since the end goal is not simply learning programming. It will involve actively using Python and Javascript in a real world project, designing and coding a web application. So, anyone with experience of building a web application from scratch ...

... This includes retrieving details such as company names, contact names, addresses, phone numbers, website address and email addresses. Key tasks include: - Scrape all necessary information - Format scraped data into an excel file - Rigorously remove any duplicate entries The ideal freelancer for this project would have a vast amount of experience in web scraping and data mining, as well as a deep understanding of data cleansing to ensure we are only left with unique data points. Highly proficient in Excel and familiarity with Website A's structure would also be advantageous. ----- note there are two parts for each record: Scrape : date: / name of show/ and location on this page: then continue click on each

I urgently need an experienced freelancer to create project management spreadsheets. Here is what I'm specifically looking for: - Proven experience in creating project management spreadsheets. - Quick turnaround as the project is needed ASAP. - Del...Here is what I'm specifically looking for: - Proven experience in creating project management spreadsheets. - Quick turnaround as the project is needed ASAP. - Deliver spreadsheets that effectively track and manage project information. - Successful freelancers will need to include detailed project proposals with their applications. This project requires a freelancer with advanced knowledge in Excel or other spreadsheet programming. If you think you're the perfect candidate, don't hesitate to apply. I look forward ...

Problem: we want to be reminded / flagged when a contract should be renewed / re-tendered. We want to reminded / flagged six months before the contract expires. The data point we have is the contract expiry (dd/mm/yyyy). Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.

Excel VBA Automation- As discussed.

I am in need of a meticulous data entry clerk, proficient in both text and numeric data entry. The project involves entering 200-250 items into a pre-provided template. Ideal skills and experience: - Proven data entry work experience. - Strong language skills. - High levels of attention to detail. - Experience with data entry software. or in an excel template - Experience working with templates. Please note: The excel template for data entry will be provided, I'll need you to follow the structure precisely and ensure you maintain high levels of accuracy. The data provided will be a mix of text and numeric data. Fields (Columns) will be : date = date field supplier name = text field nature of items or services ( 7-10 key words) = text field ...

Buongiorno, Avrei bisogno di un sviluppatore in grado di creare un applicativo CATIA che possa creare dei file CatDrawing generati in maniera automatica. Ogni CatDrawing sarà legato a un Catproduct e ogni foglio all'interno del CatDrawing sarà direttamente legato ad ogni singolo CatPart presente nel product. Ogni foglio avrà un cartiglio e i campi di questo cartiglio saranno collegati in maniera automatica ai parametri precedente assegnati in ogni catpart. Grazie mille.

I am seeking a professional with strong capabilities in Excel who can assist in creating 5-10 filter views on an online Excel sheet. The successfully completed project will include: - Ability to filter numbers, text and dates with precision - Filter views applied effectively on each individual column - Advanced understanding of Excel to ensure seamless integration of filter views The ideal freelancer for this job will have experience with complex Excel tasks, especially filter views. Your expertise should include a strong understanding of Excel formulas, data types and the ability to navigate and edit online Excel sheets with speed and accuracy. Your work will significantly improve the functionality of my spreadsheet, enabling faster data retriev...

I am looking to improve the user interface of a fun, educational app which is aimed at preschoolers. The app's purpose is to familiarize children with various animal sounds. While the coding aspect is already taken care of, I need help with the design part. The ideal freelancer for this project should: * Be familiar with Android Studio platform. * Have previous experience in app interface design, particularly for children. * Possess a knack for creating cartoonish and fun designs that engage young kids. The main goal here is to provide an interface that not only enhances the knowledge of the users but also is enjoyable and engaging for 4-5 year old kids. I trust your creativity and your knowledge of what could appeal to children in this age bracket.

I have two lists of invoice numbers and associated amounts, formatted in Excel. I need a worksheet created that will compare these lists and highlight any invoice numbers that cannot be found and their corresponding amounts. The comparison results should be incorporated into existing sheet 1. Additionally, the data in these invoice lists includes dates, invoice numbers, and transaction amount. Ideal freelancers for this project should be: - Highly proficient in Excel - Experienced in data comparison and highlighting functions - Able to work with data that includes dates and transaction amounts.

I'm in need of an Excel expert who can utilize Excel macros to automate several of my routine tasks. The main actions to automate are listed below: - Data Entry - Generating Reports These tasks are currently taking a significant amount of time and I'm confident that with the right automation, efficiency can be greatly increased. Ideal candidates should have extensive experience in using Excel macros for automation and report generation. A deep understanding of Excel and automated data entry via macros is essential for the successful completion of this project.

I'm seeking an advanced Ember.js developer with ex... - Building user-facing applications - Integrating back-end APIs - Automated testing You will be responsible for: - Developing front-end components - Managing application state The ideal candidate will be an adept problem solver, have a comprehensive understanding of the full stack, and a proven track record of delivering efficient, well-written code within given deadlines. Familiarity with coding standards and ability to write code that meets these standards can set you apart. Your work will be instrumental in developing the overarching structure of our application, and your input on decisions pertaining to feature implementations will be invaluable. Flexibility, lateral thinking, and adaptive creativity are key to succes...

I represent a digital marketing company, and we have recently encountered an issue with a client's WordPress website. The issue involves schema code erroneously appearing in the header and footer on all pages, a problem we need rectified immediately. Ideal candidates for this job should possess the following skills and experiences: • Proficiency with WordPress, specifically it's coding structure. • Expertise in dealing with Schema code and debugging unforeseen issues with it. • Ability to analyze a website for errors without having any prior knowledge of recent updates/modifications as none come to mind. It's crucial for us to ensure our client's website runs smoothly and professionally, eliminating this visible schema code is part of that objec...

I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.

NPV, SIM, Covar and general coding in VBA

Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.

I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting

I'm a beginner programmer looking for an expert who can craft a video tutorial on how to run the Vehicle-CV-ADAS project from the shared GitHub repository on my Visual Studio Code. This project involves a solid understanding of coding and VS Code operations. The ideal freelancer for this task would: • Have a comprehensive knowledge of Visual Studio Code • Be adept at creating easy-to-follow video tutorials • Have considerable programming expertise • Be proficient in using GitHub The end product should be a step-by-step instruction video that I, as a beginner, can easily follow to run the project on my VS Code. I already have both GitHub and VS Code installed, so no need to cover installation procedures. The tutorial should cover: • Accessing the Gi...

Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design in the...

I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the follo...four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allo...

I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

Tengo el inventario de la tienda ya escrito, pero nescesito tenerlo en un excel para que sea mas dinamico y facil de usar.

...final output. The deliverable must be meticulously optimized for HTML and CSS to PDF conversion, adhering to professional coding standards. Deliverables include the HTML and CSS files. We will handle the conversion to PDF. Please note that on the last page of the PDF, the graphic depicted is not a static image; rather, it is a dynamically generated graph created using the d3.js library, specifically the d3-sankey graph (). Additional Information: It's imperative to note that the final HTML, JS and CSS files will serve as the foundation for PDF conversion. Therefore, maintaining a high level of precision and adherence to structured coding practices is essential for a seamless transformation process. Clear and concise communication throughout the development phase

I'm encountering an issue with input validation and need a skilled developer to address it. Specifically, the issue is related to email input validation. Although the specific problems haven't been pinpointed, it appears to influence the functionality of the system. Ideal Skills: - Problem-solving abilities - General coding & debugging experience - Familiarity with different types of input validation, especially with email. This project requires the successful applicant to identify the root cause of the email input validation issue and implement a solution to fix it. This might involve adjusting the system's ability to detect invalid emails or its handling of special characters. Please only bid if you have relevant skills and experience troubleshooting simila...

I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!

Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc

...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confident we ...

...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...

I am looking for a seasoned PHP developer to construct an interactive web application. The primary function of this application will be user i...construct an interactive web application. The primary function of this application will be user interaction: creating profiles, sending/receiving messages, making connections, and other interactive features. Ideal Skills and Experience: - Expertise in PHP development - Extensive web application development experience - Proven ability to create interactive, user-friendly interfaces - Proficient in coding for robust performance and scalability. Understanding of .NET platform is also a plus, but not a primary requirement for this project. Your bid should reflect your understanding of these key requirements. I look forward to your detailed ...

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the

I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.

On this project, your expertise in PHP and JavaScript will be much needed to evolve a software we are developing. Though we are not completely certain of what our PHP and JavaScript would achieve presently, our focus is majorly twofold. Our team of developers are relying on your oversight to navigate through this ambiguity. Breakdown of Tasks - PHP: Our PHP needs involve connecting to databases, controlling form submissions, and retrieving data from the system when required. - JavaScript: Currently, the specific functionalities for the JavaScript task are vague, although form validation, user authentication, and data manipulation is probable. Ideal Skills and Experience - A broad understanding and experience in PHP and JavaScript. - Proven track of successfully handling form submission...

Seeking a dab hand in front-end and back-end development with top-notch proficiency in database management for the development of an e-commerce website. Key features need to include: - Item listing and search functionality - Seamless shopping cart and checkout process - Robust payment gateway integration Hands-on ex...ensure fast and efficient data handling. Your expertise in front-end development should facilitate the design and development of an engaging and interactive web interface. It’s required that you're versed in back-end development to support the integration of all required functionalities. Please bring a creative approach to problem-solving, a well-developed technical skill set, and a passion for coding to the table. Let's make online shopping an absolu...

I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowledgeable professional w...

I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...

I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) lan...not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...

I'm in immediate need of a prolific developer to create a web application as well as a website that critically use API. Lack of specificity doesn't mean lack of quality; I am looking for a developer who can craft a robust, flexible platform capable of future growth a...User-friendly interface - Contemporary visual appeal - Secure User registration and login system - Comprehensive search functionality - Seamless Integration with external APIs Time Expectation: As this section was skipped, I'd favor developers who can provide a quick turnaround time without compromising on quality. Ideal Skills/Experience: - Proficiency in web application and Website development - Coding expertise with APIs - Understanding of user experience principles - Strong portfolio displayin...

Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.