Useful vba codes for excel jobs

I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.

I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure

...comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accounted for and calculations are accur...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 1...need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. ...

...that loops through waves of escalating difficulty, offering replayability and the potential for continuous improvement. - Incorporate mechanics that reward players based on their performance in surviving and progressing through the endless waves of zombie enemies. 2. Gameplay Mechanics and Features: - Implement a procedurally generated system for enemy waves to ensure each playthrough is unique and offers varying challenges. - Introduce scaling difficulty that dynamically adjusts to the player's skill level, providing a continuously engaging experience. - Include endless mode-specific features such as leaderboards, milestones, or rewards that motivate players to push their limits and strive for higher scores. - Design gameplay loops that encoura...

I'm in need of a skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a seamless integrati...

I'm looking for a proficient web scraper who can extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as ...

...Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of locations where the teacher can be available for each availability period. Subjects: System to associate subjects with each teacher, distinguishing between th...

I'm looking for a sales expert that can generate leads and sell an online course on money-making strategies. The course is designed for 18-35 year olds aspiring to achieve financial independence. Key Responsibilities: - Develop a comprehensive sales strategy to effectively market the online course - Utilize your expertise to reach and engage with the target audience - Maximize sales Ideal Skills: - Proven track record in sales, preferably in the online course industry - Familiarity with the target audience and their online behavior - Strong communication and persuasion skills - Understanding of online marketing tools and techniques - Ability to work independently You will be provided with personal discount codes, so that you can persuade customers to purchase...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.

I have a substantial amount of survey data, all neatly organized in a spreadsheet. I am looking for a professional with experience in descriptive statistical analysis to help me make sense of it. Key requirements are as follows: - Expertise in descriptive statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calculating ...

Looking to collaborate with Antenna experts for design/build of RFID UHF 860-960 MHz Active Digital always on antenna. It will support any RFID tags of the stated frequency range and the protocol. We have identified some possible technologies below but will rely on your expertise to pick one or combination of these or another suitable one from your experience. If you know of a pre-built solution that will be ideal. This antenna will be connected to our MCU via a comm port and be fully software defined. Our objective is to accomplish a 0.3 meters x,y,z 3D planer precision location of RFID UHF passive tags at about 25 meter cone at about 8 meters height from floor. Must be RFID UHF Frequency range (roughly 860-960 MHz, supporting US, Europe, Asia spectrums) Applicable ISO standards...

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notific...

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deli...

I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored ...

...android): Key requirement from developers: • Looking for a team of qualified developers with knowledge of all the functionalities required for this project • Must have expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to one calendar booking form and the form will show availability ...

We are seeking a knowledgeable and detail-oriented Building Codes and Regulations Specialist to assist in ensuring our upcoming project complies with all relevant laws, regulations, and codes. The ideal candidate will have a strong background in construction, architecture, or urban planning, with extensive experience in researching and applying legal and regulatory requirements specific to different locations and project types. Responsibilities: Research and compile a comprehensive list of all building codes, bylaws, and government regulations applicable to the project. Analyze and interpret regulations specific to the location, area, and type of project. Provide detailed documentation and guidelines to ensure the project adheres to all legal requirements. Liaise wit...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed an...

...visitors to calculate their debts. This will not only be a useful feature for the users but also a way to attract leads by offering value. - Testimonials: I would like to include testimonials from previous clients on the site. This will help in establishing credibility and trust among the audience. - Lead Attractor: Additionally, I'm open to suggestions on how to further attract leads. Whether it's another interactive tool or a resource download Ideal Skills and Experience: - Proficiency in web design and development - Understanding of user experience (UX) principles - Knowledge of lead generation strategies - Familiarity with debt-related content is a plus If you have creative ideas on how to make my website more engaging and effective for users with d...

I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The spe...windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working o...

I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to su...

We are using the VROOM Project front end for a route optimization tool. The code is open source You can demo it here - We have modified the front end to support uploading data in and XLS format instead of JSON. The data parsing is working but we are looking to improve the data validation to alert the user of specific problems with their data they are uploading. Input data: Sheet 1: Work Order Tab Name, Address 1, City, State, Zip, Technician Sheet 2:Technicians Tab Name, Starting Address, Starting City, Starting State, Starting Zip, Ending Address, Ending City, Ending State, Ending Zip Some of these fields can be blank. Useful validation for the user will be required. See this documentation regarding the json

Dear translator, We are a company that develops live streaming and video chat apps. We are looking for native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be asking ...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily na...

I'm in immediate need of an attendance application that can be used on Android devices and on the web. The main features I'm looking for are QR code scanning for attendance tracking and a robust reporting and analytics system. Key Features: - Android and Web Compatibility: The app should be accessible on Android devices and through a web interface. - QR Code Scanning: The primary function of the app is to scan QR codes for attendance. The UI should be intuitive and easy to use. - Reporting and Analytics: The app should have the capability to provide detailed reporting and analytics on attendance data. This includes but is not limited to: - Tracking attendance trends over time - Generating customizable reports - Exporting data - Visua...

...licensed professional for Florida to sign and seal my new construction residential home design plans. Key Responsibilities: - Sign and seal the Architectural plans: The sign and seal should be focused specifically on my architectural plans for a new residential home. - Permit Acquisition: It's essential that the sign and seal on these plans will facilitate a smooth and successful permit acquisition process. Ideal Skills and Experience: - Licensed Architect or Engineer for Florida: I'm specifically looking for a professional with a certification to sign and seal architectural plans. - Experience in Residential Projects: It's crucial that the freelancer has experience dealing with residential projects, particularly in new construction. - ...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive ...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

I'm in search of a seasoned OpenWRT expert to develop a captive portal. This project requires a deep understanding of CoovaChilli+Daloradius (or other opensource radius). The major features to be embedded include: - Soci...deep understanding of CoovaChilli+Daloradius (or other opensource radius). The major features to be embedded include: - Social media login, specifically through Facebook. - A customizable landing page. - Mindful bandwidth control. - A voucher system with one-time use codes. Prior experience in implementing such features is highly preferred. Please abstain if you're not familiar with CoovaChilli. Your expertise in creating a smooth and user-friendly interface will be greatly valued. Anticipate the full utilization of your skills for this captiva...

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sor...

Please Sign Up or Login to see details.

I am in ne...am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a cle...

...looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I ...

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it&#...

...looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I ...

...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open...

I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data ext...

...with us. This system will allow people who bring us publishers with their own referral links to earn commission on the earnings of the publishers. It is not a titan chain style system to be earned from what they bring. IMPORTANT NOTES This system is a completely legal system where members actually work for us and earn from us through the publishers they bring to us. You can think of it as a basic Affiliate system. It can be used through a script with a membership system, ready, useful and nice design. People who will work as a partner of our agency will be able to enter from a url such as and login or register. Since this page will be open to everyone, it will have a simple design that explains our affiliate marketing system. (Ready Landing theme can be used.) The

...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...

...requirement by our county for an architect to provide the final sign off. The apartment is envisioned as a cozy 19'3" x 14'5" one-room setup incorporating: - Kitchen: minimal cabinetry, a sink against an exterior wall, and space for a mini-stove, adding a half-wall partition from the bedroom area. - Bathroom: designed to fit in the back left corner, with a shower, toilet, and sink aligned on one wall. - Living Area: layout needs to be space-efficient due to the mini form factor. A key consideration, the home sits on piers which we are not allowed to attach anything to. The placement of fixtures must also adhere to existing plumbing arrangements, which we can provide further information on as required. Candidates must have familiarity with Florida b...

Hey, I’m using a theme that have it’s own sign up form but there is no field for entering username. I want to add the enter username field and make it required. We have to do this from the file manager by editing codes.

I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites...

I'm looking for structural engineering professionals to design exterior ceilings and soffits for a 12-story St. Regis Resort. They must be experienced in creating designs that meet Miami Dade hurricane codes. Key Requirements: - Waterproof - Fire-resistant - Aesthetically pleasing - Designs need to incorporate steel and light gauge metal framing components I've already secured permits and approvals necessary for this project. The design must strictly meet all local authority guidelines. Prior experience in this area is strongly preferred.

Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.