Excel vba sql based column value jobs
? We’re Hiring: Short-Form Real Estate Video Editor (Fast Turnaround Needed!) ✨Offering pay for every edit completed✨ Are you a skilled short-form video editor who knows how to turn real estate talking head content into engaging videos under 60 seconds? Do you excel at delivering scroll-stopping edits quickly while maintaining quality? We’re looking for someone who specializes in short-form content that captures attention and drives engagement! What We’re Looking For: Expertise in editing short-form real estate talking head videos (less than 60 seconds) Strong knowledge of platform-specific trends (Instagram Reels, TikTok, YouTube Shorts) Ability to create dynamic captions, transitions, and hooks that capture viewers' attention in the first 3 seconds Ef...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
...secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformatio...
...throughout the transaction process, addressing any issues or delays promptly. Maintain meticulous records and follow up to ensure smooth deal closures. What We’re Looking For We value creativity, organization, and professionalism. The ideal candidate will: Have excellent communication skills (both written and verbal). Be confident making outbound calls and thrive on building connections. Possess a knack for design and marketing (experience with Canva and Constant Contact is a plus). Demonstrate exceptional organizational skills and attention to detail, especially when coordinating transactions. Be self-motivated and excel in a remote environment. Have interest or experience in real estate (wholesaling or transaction coordination experience is a bonus!). Why Join Us?...
I am seeking an experienced sales professional, specifically a senior-level candidate, to close sales for my consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience i...consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience in consulting industry - Experience in recruitment - Exceptional communication and negotiation skills - Ability to understand and convey the value of our services - Committed to making a positive impact Required: - Be located in the Pacific Northwest - Be open to commission-based work Desired: - Mission-based (you wa...
My web-based driving school management system built on PHP is facing some issues that need urgent attention. Ideal Skills and Experience: - Extensive experience in PHP development - Proven track record of troubleshooting web-based systems - Ability to improve system performance and user experience Please note, specific issues with the system have not been identified yet, and it would require a thorough examination of the system to determine the exact problems. The primary users of the system are students, instructors, and administrators.
I'm seeking a dynamic salesperson to market and sell our comprehensive suite of digital marketing services, which includes SEO, social media marketing, and Pay-per-click advertising. This role is commission-based, offering you the potential for significant earnings commensurate with your sales success. Key Responsibilities: - Drive sales across various platforms including Google Ads, Facebook Ads, and LinkedIn Ads. - Cultivate relationships with potential clients and negotiate sales. Ideal Candidate: - Previous experience in digital marketing sales is essential. - Possesses strong communication and negotiation skills. - Has a proven track record of meeting sales targets. Skills and Experience: - In-depth understanding of digital marketing services. - Experience with Google ...
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I am seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy and speed are of the essence in this project.
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
...presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flow. Please DM...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I'm seeking a medium-sized realistic tattoo design for my arm, to pay tribute to my late grandfather "Poppy", who was my greatest hero. The tattoo should incorporate an excavator, his name "Poppy", his birth and death years (1945 - 2014), and ball...symbolizing the ones we released at his memorial. Ideal skills and experience for this job include: - Proficiency in realistic tattoo design - Experience with sentimental and personal designs - Understanding of incorporating text and symbols within designs - Strong portfolio of previous work - Excellent communication skills to ensure the design meets my vision This tattoo holds significant sentimental value for me and I want it to reflect my love and respect for my grandfather. Please, only apply if you have t...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I'm in need of a seasoned PHP developer to create a user login system that caters to different user roles - 'seller' and 'buyer'. This system should incorporate essential features such as login, registration, profile editing, and password resetting. Key Requirements: - Use of MySQL as the database for the user login system. - Incorporation of an email verification service for added security and user authenticity. - Design of a modern, graphics and animation infused user interface for the login system. Ideal Skills: - Extensive experience with PHP and MySQL. - Proven track record in developing user login systems. - Proficiency in creating modern, animated interfaces. - Experience with integrating email verification services. Your expertise in these areas will be ...
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
...brands, About KSTAR: KSTAR, specializes in household disposable products such as kitchen rolls, toilet tissues, aluminum foils, disposable plates, and cleaning supplies. The brand represents modernity, reliability, and practicality, delivering high-quality solutions for everyday household needs. ________________________________________ Target Audience: KSTAR caters to individuals and families who value convenience, quality, and dependability in household products. ________________________________________ Key Design Elements: 1. Style: • Modern and Minimalist: Reflects professionalism and efficiency. • Dynamic and Memorable: Adaptable across various product types, from mono cartons to tissue rolls. 2. Typography: • Use a bold, clean sans-serif font that is easy ...
...step into this versatile role and make an impact. This position offers the chance to work on diverse projects and contribute directly to our success. --- Proposals that do not include answers to all of these questions will be ignored. While we love AI, please do not use AI to answer these questions—we want true, authentic responses. Don’t worry about spelling, grammar, or sounding perfect; we value honesty over perfection. 1. What experience do you have maintaining HubSpot CRM, ensuring data quality, and managing records? 2. If your working hours differ from your local time zone, which time zone do you primarily work in? 4. How many hours a month would you available/provide with your given proposal? 4. Will you be completing this work individually as an indepe...
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-related softwa...
I need a developer to create a new Ethereum-based, deflationary token for me. The token will have a web browser wallet with core functionalities including sending/receiving tokens, token swap features, and transaction history. Key Requirements: - A unique deflationary model where a percentage of tokens is automatically burned with each transaction. - Reflection rewards for holders, incentivizing long-term holding and distribution. - A buyback and burn mechanism to support the token's value and supply control. Skills and Experience: - Proficiency in Ethereum blockchain and smart contract development. - Prior experience in creating deflationary tokens and associated web wallets. - Knowledge of implementing unique token features such as burning mechanisms and reflection r...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
Develop AI backend based on existing templates
...Sales Navigator and other digital marketing techniques. Target Definition Identify the Ideal Customer Create a detailed profile of luxury travel agencies and direct clients, with a focus on: - Agencies specializing in customized travel and exclusive packages. - High-level professionals and executives needing premium transportation services. - Segmentation - Classify agencies based on their specialization, such as high-profile events or partnerships with luxury hotels. --- Setting Up Sales Navigator - Lead List Creation - Compile a list of 50-100 potential agencies and clients using Sales Navigator. - Use keywords like "luxury travel," "VIP transport" for the search. - Using Notes and Tags - Categorize leads into relevant g...
I'm in search of a seasoned photo editor who can enhance my furniture product images. This is not a one-off task, but a continuous collaboration; e...Correct any uneven lighting. - Retouching: Remove any imperfections and enhance the overall image quality. - Shadow Addition: Create realistic shadows to add depth. - Product Manipulation: Straighten lines, remove wrinkles and imperfections. You will need to put the edited images on a white background. I'm not looking for a quick edit to just put the image on a white background and send it back. I value quality work that makes each product look its absolute best. I can pay by the image, please let me know what your proposed per image rate is. In your response, please include the word "apple" to demonstrate that y...
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
...script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning message, rather than throwing an error. Additional Details: Must be user-friendly and simple to operate. Ensure seamless interaction with MySQL, without causing unnecessary l...
I'm in need of an experienced app developer to help me create a web app focused on enhancing productivity. Key Requirements: - Expertise in web app development - Strong understanding of productivity tools - Ability to design intuitive and user-friendly interfaces - Experience in creating seamless, efficient, and high-performance applications Your bid will be evaluated based on your relevant experience, portfolio of similar projects, and understanding of productivity tools. Please include examples of previous web app projects you've completed, particularly those focused on productivity. Looking forward to your proposals.
...dedicated to cafés, restaurants, bakeries, pastries .... -------------------------------------- SET GOAL: 8 Sales COMPENSATION PACKAGE : 2920 USD ALLOCATED DURATION: 3 - 4 Weeks ---------------------------------------- PROJECT DETAILS 1. SCOPE OF WORK The Service Provider will provide full marketing services and content management to the Client, including: 1.1. Educate the audience about the app’s value through blogs, infographics, and explainer videos 1.2. Leverage paid ad platforms to increase app visibility and drive traffic to the website/app store. 1.3. Generate Email Marketing Campaigns 1.4. Build direct connections with potential users through partnerships and targeted outreach. 1.5. Leverage food and tech influencers to increase app credibility and awareness....
I'm seeking an experienced developer or team to create a cloud-based, multi-tenant (SAAS model), user-friendly CRM system. The front-end will be built using Angular, while the backend API will be developed using .NET Core. Key Requirements: - The CRM should manage various customer interactions, including email communications, phone call tracking, and live chat support. - It should incorporate sales pipeline management and automatic lead scoring as crucial sales tracking features. - The system needs to handle different types of leads: cold, warm, and hot. - The design must prioritize a user-friendly interface for end-users, coupled with a scalable backend. Ideal Skills and Experience: - Proficiency in Angular for front-end development. - Extensive experience with .NET Core for...
...Manager for Electrical Contracting and Generator Installation Business Description: We are a well-established electrical contracting and generator installation business seeking an experienced and creative Social Media Manager to enhance our online presence on Facebook, Instagram, and other platforms. The ideal candidate will have a proven track record in managing and creating content for service-based businesses, with a specific focus on: Generac generator installations Quotes, maintenance, and repairs Electrical contracting (residential, commercial, and industrial sectors) This role will involve strategy development, content creation, posting, engagement, and performance tracking. Scope of Work: Account Setup and Branding: Create and optimize new accounts for Facebook, Insta...
As we seek long-term work, I am seeking value for money, so please provide your lowest possible bid. We are looking for a WordPress expert with strong server management skills and Linux knowledge to work on long-term projects. The ideal candidate will have expertise in the following areas: Key Responsibilities: 1. Website Migration Repair: o Fix issues with websites that have been migrated but are not functioning properly. o Ensure smooth and error-free performance after migration. 2. Malware Cleanup and Restoration: o Restore websites that have been compromised by hacking. o Clean and secure websites, ensuring that they function optimally. o Utilize available backups for complete restoration. 3. Client Backend Restoration: o Rebuild and restore the backend admin panels to allow cli...
I'm seeking a skilled developer to create a web-based application that simplifies the creation of Word documents, specifically for tax documentation reports. Requirements: - Build a user-friendly e-commerce platform that allows for easy document creation and purchasing of additional features. - The web based application should let users add their data and generates word documents in a particular manner. - The web based application should enable user to add tables and the data to be linked. - Integrate a secure payment system for transactions. - Implement a content management system for users to save, edit and track their reports. Ideal Skills and Experience: - Extensive experience in web application development, preferably with e-commerce and CMS systems. - Str...
I'm looking for a LinkedIn expert who can help me to enhance my presence on the platform. The primary goal of this project is to comment, network, and connect with people across the platform. Key Activities: - Commenting on posts: I want you to actively engage with relevant content on LinkedIn. - Networking ...Networking with professionals: I need you to identify and connect with key players in my industry. - Connecting with new people: Expanding my LinkedIn connections is a key part of this project. The ideal freelancer for this project should have: - A knack for networking - Excellent communication skills - Proven experience with LinkedIn engagement - Ability to comment on posts in a way that adds value and showcases expertise Daily Requirements - 50-60 comments Con...
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I need my Excel data modified for better visual appeal and branded to match my website. Requirements: - Apply custom themes and colors to the Excel file. - Incorporate my website's color scheme and font style. - Add my contact number to the header of the Excel file. There's no need to change any of the data, as everything has already been filled.
I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
I need someone to create a excel spread sheet to show and auto populate the following cost and expenses Labor Costs: Track employee hours worked in each service category using timesheets or a time tracking system. Record the hourly wage for each employee. Calculate daily labor cost: (Number of employees) x (Hourly wage) x (Hours worked). Supply Costs: Maintain a daily log of all supplies used in each service category. Record the quantity and unit cost of each supply item. Calculate daily supply cost: (Quantity used) x (Unit cost) for each item, then sum up all item costs. Vehicle Mileage: Record the starting and ending mileage for each company vehicle used daily. Calculate the total mileage driven for each vehicle. Fuel Consumption: Collect and retain all gas card receipts. Record t...
I need an Excel spreadsheet designed for daily expense tracking and financial calculations. The ideal freelancer for this project would be someone with strong Excel skills, particularly in creating formulas and functions for financial analysis. Key Requirements: - Create an Excel spreadsheet for daily expense tracking - Implement financial calculations within the spreadsheet - Ensure the spreadsheet is user-friendly and easy to update Skills & Experience: - Strong proficiency in Excel - Experience with financial spreadsheets - Excellent attention to detail
Will create a proper google form and sheet according to your requirements.
...return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secure login with pin code (as an example shown in myntra), • Coupons creation in admin panel with expiry date and with a condition which will be discussed later • Gift page which works on multiple conditions but basically works based on cart value • DLT API - which should be used for OTP verification (for profile creation), Abandoned cart notification to the customer, Order confirmation notification, Gift card purchase notification & any other where applicable • User profile which needs to be copied from some other ecommerce portal • Admin panel management on - customer communicat...
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
I'm seeking a developer to create a straightforwa...both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app should support importing a client database from Excel. Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with offline functionality and data synchronization - Knowledge of creating role-based access systems - Capability to develop advanced analytics dashboards I am looking for a functional, simple, and cost-effective solution to enhance our daily sa...
I'm looking for someone to gather various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official webs...various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official websites and retailer sites. - Compile the data into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in online research. - Experienced in data collection and data entry. - Familiar with food and beverage products. - Able to compile information into a clear and organized ...
Attached is a image of an icon. I would like a 256px x 256px version. It should have the same appearance but look good at that resolution.
