Excel vba update fields jobs
I am seeking an Excel expert who can create a master Excel file and a child file with limited columns. The key requirement is that both files need to be synchronized, ensuring that any changes made in one file are automatically reflected in the other. Key Tasks: - Create a master Excel file with specified columns (details will be provided) - Create a child Excel file with limited columns - Set up synchronization between the two files - Use IF formula where necessary to ensure smooth functionality Ideal Skills: - Proficient in Microsoft Excel - Experience with IF formula and other Excel functions - Ability to create and manage linked files - Detail-oriented to ensure accurate synchronization The synchronization should be triggered by any of the ...
I need an Excel list containing all the companies attending an upcoming exhibition. The list should include the following details for each company: - Company Name - Booth Number - Contact Information (whatever is available, website should be enough) - Company Description (in a brief summary) - Country Ideal candidates for this project should be familiar with data collection and Excel. Attention to detail is crucial, as the information needs to be accurate and well-organized. Experience with similar tasks is a plus.
I need assistance in converting a multi-tab Excel file into a detailed table for record-keeping purposes. The data should be organized in the table by category. Key details: - The table should only contain raw data, with no specific calculations or summaries needed. - The ideal freelancer for this project should have strong Excel skills and experience in data organization.
I need a professional and eye-catching flyer to promote a Girls Basketball Clinic. The primary goal of the flyer is to attract sign-ups, specifically targeting girls in school teams. Green and yellow gold are the theme Key Details to I...EXPECT: ✅ Shooting Fundamentals & Game-Ready Accuracy ? ✅ Elite Ball Handling & Control ? ✅ Fast Break Execution & Game Speed Drills ⚡ 5005 e Los Angeles ave Simi valley ca 93063 - Date and time of the clinic - Location of the clinic - Contact information for registration - Price Ideal skills for this job would include graphic design and marketing experience, particularly in sports-related fields. Familiarity with designing for a target audience of young athletes would be a plus. Please include samples of your previous work in ...
I'm seeking a skilled Supabase developer to implement Row-Level Security (RLS) policies on my database. The objective is to limit insert and update capabilities to a designated admin account while permitting all authenticated users to read database records. Key Responsibilities: - Configure RLS policies that restrict insert and update access to a specific admin user. - Ensure all authenticated users can read data records without restrictions. Ideal Skills and Experience: - Proficiency in Supabase and database management. - Prior experience in setting up RLS policies. - Strong understanding of user authentication and access control.
I need a simple, user-friendly, interactive webpage designed to help my father, who runs a small transport business, generate bills for his clients. This should be an easy-to-use platform where he can customize fields and rows in a table, type out service details, client information, and pricing. Key requirements: - The webpage should allow for customizable fields and rows in the table. - The final bill should be printable as a PDF. - The design should be simple and intuitive, taking into account my father's lack of experience with word editors. Ideal skills for the job include web development, experience in creating interactive webpages, and ideally, a background in designing for non-tech-savvy users. Please let me know if you can help, and I will share further detail...
...documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requiring extended collaboration over several months. Communication will primarily...
...Bootstrap 5 – The website must use the latest version of Bootstrap for styling and layout. ✅ Pixel-Perfect Development – The website must match the provided Adobe XD design exactly in terms of layout, colors, typography, spacing, and responsiveness. Every detail, including margins, padding, and animations, should be faithfully implemented to ensure a high-quality, professional finish. ✅ Advanced Custom Fields (ACF Pro) – The website should be built using ACF for content management, including flexible blocks that can be toggled on and off as needed. ✅ Gravity Forms – Must integrate Gravity Forms with HubSpot via Zapier (our existing workflow). ✅ Minimal Bloat – No unnecessary plugins or bloated code. The site must be lightweight, optimized for speed, ...
I need someone to analyze my order data. I have it in an Excel/CSV file and it contains data for up to six months. Specifically, I want to know: - How many orders were placed on each weekday (Monday, Tuesday, Wednesday, Thursday and Friday) in February and March, and so on for the following months. The final analysis should be provided to me in another Excel/CSV file. Ideal skills for this job include: - Proficiency in data analysis, particularly using Excel - Understanding of order data and e-commerce metrics - Experience in creating clear, concise data reports. Please make sure that your Excel skills are top-notch, as this is the format I want to receive the final results in.
I possess a survey dataset centered on tea consumption and I am seeking a skilled data analyst to assist with its evaluation. The ultimate goal is to gain insights that will enhance the data-driven nature of an article I am crafting base...article I am crafting based on these findings. Key Responsibilities: - Identify correlations between different age groups and their tea consumption habits. - Extract significant insights and trends from the dataset. - Create visual representations (graphs, charts, etc.) to support the article. - Summarize findings in a clear, concise manner. Ideal Skills: - Proficiency in data analysis tools (Excel, Python, R, etc.). - Strong statistical acumen to detect meaningful patterns. - Excellent ability to present findings in a clear and visually appeali...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project include: - Proficiency in Ex...
Hello! We hired you in the past. I'd love to hire you to simply clean up a logo and update it We want " COMMERCIALISATION GROUP " to be cleaned up. I have attached a screenshot of what I would love the logo to look like, but it needs to be cleaned up as the gaps are all different sizes and look bad. We require a both a coloured logo: #33639D and a white copy font: GOTHAM Transparant PNG, WEBP and SVG please :)
Hello! We hired you in the past. I'd love to hire you to simply clean up a logo and update it
I need to convert data from XML to Excel. I've got an example XML file that can be used as a reference for the conversion. Ideal Skills: - XML - Excel - Data Conversion - Attention to Detail Please ensure that the conversion is precise and matches the structure of the example XML.
I will send through the information in chat.
...Home Improvement & Remodeling Business Description: Hello, I need a professional website for my home improvement and remodeling business (Draine State). We offer plumbing, drain cleaning, handyman services, full home remodeling (interior & exterior), and home repairs. Website Requirements: • Modern, mobile-friendly, and fast-loading • SEO-optimized to rank well on Google • Easy to manage and update • Includes: ✅ Home remodeling services (interior & exterior) ✅ Plumbing, drain cleaning, handyman, and repair services ✅ Project gallery (Before & After photos) ✅ Contact form and online booking option SEO Optimization: I need SEO optimization for my website to ensure it appears on Google’s first page when people search for services lik...
Replace ESP32 with STM32G030C8T6, adding protection, debugging, and programming circuits. Remove IO expander and RTC IC; use STM32’s internal RTC with CR2032 battery and crystal. Add optocouplers for UART isolation and RS232 printer TX. Update RTD circuit with constant current source, ensuring noise reduction, CMRR. Other analog section improvements than RTD for noise and CMRR. Redesign PCB for single-side SMD assembly. Select compact, reliable, cost-effective optocouplers.
Replace ESP32 with STM32G030C8T6, adding protection, debugging, and programming circuits. Remove IO expander and RTC IC; use STM32’s internal RTC with CR2032 battery and crystal. Add optocouplers for UART isolation and RS232 printer TX. Update RTD circuit with constant current source, ensuring noise reduction, CMRR. Improvement in other analog section apart from RTD for noise and CMRR. Redesign PCB for single-side SMD assembly. Select compact, reliable, cost-effective optocouplers.
I'm an e-commerce seller seeking a proficient Excel specialist who can create formulas and automate processes for my inventory tracking. Key Responsibilities: - Develop Excel formulas and automate processes to enhance efficiency - Create inventory level alerts to prevent stock shortages - Conduct sales tracking and analysis to inform business decisions Skills & Experience: - Advanced Excel skills with a focus on automation - Previous experience in e-commerce inventory management - Proficient in sales tracking and data analysis.
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
...design and develop a user interface application on Linux. The app will be used for controlling both custom and Zebra hardware devices, interfacing with an SQL Database and performing API integrations. The complete end-to-end Figma model is already designed with all the necessary screens. Key Requirements: - Control and monitor status of custom hardware devices - Configure custom hardware devices - Update firmware on custom hardware devices - Manage versioning in accordance with FDA regulations - Configure Zebra hardware devices - Develop an Android App for RFID / 2DMI Scanner Ideal Skills and Experience: - Proficient in Linux UI app development - Extensive experience with custom and Zebra hardware devices - Strong background in SQL Database management - Proven record of success...
...expectations. • Provide timely and well-documented cost breakdowns for bids, proposals, and budget planning. Qualifications & Skills • Experience in material takeoffs and cost estimation in [industry, e.g., construction, manufacturing, engineering]. • Strong understanding of engineering drawings, blueprints, and CAD models. • Proficiency in estimation software (such as Bluebeam, PlanSwift, Excel, or industry-specific tools). • Ability to work with engineers, architects, and project managers to refine estimates. • Strong analytical skills with attention to detail. • Excellent communication and negotiation skills for working with vendors and suppliers. • Ability to manage multiple projects and meet tight deadlines. Preferred Qua...
...region of Anguilla. Ensure compliance with local copyright laws. 3. Enhanced User Experience via Icons: Replace traditional category representations with visually appealing side-by-side icons for all features. Description texts will be provided and need to be properly placed. 4. Regulatory Adjustments: - Make login/sign-in optional for buyers but mandatory for freelancers joining the marketplace. - Update platform visuals including rebranding elements such as a logo modification (placement adjustment). 5. Social Media Enhancement: Integrate missing YouTube and Google icons into the social media options of the marketplace. 6. Functional Email Setup: Add two functional email contact points to the site. 7. Pricing Strategy Implementation: Configure marketplace fees at a reduced perc...
I need a simple edit to my logo. The current logo is in PNG format and I need to change the company name displayed on it to 'West Indian Catering & Food Truck' & 'ChrisShoun Cookz LLC' same font. Same position
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I'm in need of an Access database designed specifically for reporting and analyzing opera...storage and retrieval while also providing general reporting capabilities. Key requirements include: - Development of custom reports tailored to my operational data needs, specifically Profit and Loss Statements on a per operating unit and collective/all units basis. - Creation of user-friendly dashboards for easy data visualization. - Implementation of automated data import processes involving excel and/or cvs file uploads. Ideal candidates for this project should have: - Extensive experience with Microsoft Access database development. - Strong skills in data analysis and reporting. - Prior experience in designing dashboards and custom reports. - Knowledge of automating data imports i...
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I'm seeking a professional to review and optimize the VB code in my Excel file, which has been modified over the past 20 years. The primary goal is to streamline the code for future users. The code has sections that handle macros and automation scripts. These scripts involve data import, formatting, and report generation. Ideal skills and experience for the job: - Proficient in Visual Basic for Applications (VBA) - Extensive experience with Excel - Previous experience in code optimization for performance - Excellent problem-solving skills, particularly with macros and automation scripts - Ability to simplify complex code for future understanding
Please update Category Tabs for customers to search each fitment category as discussed. I have already uploaded tab images to each category that will show along the top underneath the brands filter. This needs to be completed correctly asap.
Project Title: Research & Analysis Project Description: We are seeking a skilled and experienced researcher and writer to contribute to a public policy research initiative. • Analyze relevant data and reports to support evidence-based recommendations. • Ensure all research and writing adheres to the highest ethical standards and is properly cited. Requirements: • Demonstrated expertise in public policy research and analysis. • Strong analytical and critical thinking skills. • Excellent written and verbal communication abilities. • Familiarity with policy research methodologies and data analysis techniques. Project Deliverables: • 6,000 words of original, high-quality written content for a policy research report. • Complete and accur...
I need assistance with integrating my Excel spreadsheet with an API and webhooks to fetch customer data from external sources. I am not quite sure which API service to use, so your expertise in identifying the appropriate REST, SOAP, or GraphQL API will be crucial. Key Requirements: - Understand and implement API integration in Excel - Expertise in identifying suitable API services - Experience in working with webhooks - Proficient in Excel I am looking for someone who can automate the process of fetching this data, allowing for a seamless and efficient workflow. Your experience with manipulating Excel for data processing tasks will be a significant advantage for this project. Please provide examples of similar projects you've completed in your bid.
I am looking for a skilled freelancer to create a YouTube channel in the Tech category and set it up for monetization within three days. I already have pre-recorded videos that need to be uplo...monetization once the channel meets the eligibility requirements for the YouTube Partner Program. Link my own AdSense account to the YouTube channel once it qualifies for monetization. Requirements: Experience with YouTube channel creation and monetization. Knowledge of YouTube SEO and best practices for video optimization. Ability to deliver the project in 3 days. Strong communication skills to update progress and ensure requirements are met. Payment: $100 upon successful completion of the job. Payment is made once the channel is created, eligible for monetization, and my AdSense account ...
...Flatsome theme. The ideal candidate will have a strong understanding of e-commerce best practices, user interface (UI) and user experience (UX) design, extensive experience with the Flatsome theme within the WooCommerce/WordPress environment, and a portfolio showcasing modern and visually appealing website redesigns. Responsibilities: Flatsome Theme Redesign (WooCommerce/WordPress): Significantly update our existing Flatsome theme within our WooCommerce/WordPress installation to achieve a modern, clean, and user-friendly design. This includes modifying the theme's appearance, layout, functionality, and styling to meet our specific redesign goals. This is not just a minor refresh; we are looking for a substantial visual and functional overhaul. Modern Design Aesthetic: Crea...
I need a program/script that automatically generates crosswords and exports them in a specific JSON format for my Android application. Main Requirements: 1. The program must receive a list of words as input 2..."positions": [ { "x": number, "y": number } ], "direction": "horizontal|vertical" } ] } Technical Specifications: - Each word must have its positions defined in x,y coordinates (0-9) - The program must maximize the number of crossings between words - Words cannot overlap incorrectly - Must validate that all words fit within the grid - The "id" and "image_url" fields can be dummy values Deliverables: 1. Program source code 2. Usage instructions 3. Basic docum...
I'm looking for a professional to create detailed floor plans for a hotel kitchen and breakfast area. Key Requirements: - You will need to work with existing blueprints, so attention to detail and ability to reference and update current plans is crucial. - The floor plans should be comprehensive, incorporating utilities and fixtures. Ideal Skills: - Proficiency in architectural design and drawing software. - Experience in designing commercial kitchen and dining spaces. - Ability to interpret and modify existing plans.
...PHP 5.6: Qipco Racing Website. This website is used for uploading and managing photo albums. However, since PHP 5.6 is no longer supported by our hosting provider, we need an experienced PHP developer to upgrade the codebase to PHP 8.1+ while ensuring all functionalities remain intact. Project Scope: Upgrade the website from PHP 5.6 to PHP 8.1+ Update deprecated functions and ensure compatibility with modern PHP standards Update database connections to work with PHP 8.1+ Ensure photo upload and album management features work correctly post-upgrade Perform necessary testing to confirm full functionality Requirements: Proven experience in upgrading legacy PHP applications Strong knowledge of PHP 5.6 and PHP 8.1+ Experience with database mig...
I need an Excel expert to build and automate a user-friendly price sheet for me. Key Requirements: - The sheet should cover various categories: electrical items, labor, markup, taxes, etc. - The price sheet should be easily exportable to PDF & CSV format. Ideal Skills: - Strong proficiency in Excel - Experience in building automated Excel sheets - Ability to create user-friendly interfaces - Understanding of pricing components (labor, markup, taxes) - PDF & CSV export experience The goal is to create a comprehensive, user-friendly, and automatable price sheet that I can use for various categories. Please only apply if you have the relevant experience.
...Reference for expense categories and summary formats. Milestone 4: Final Review & Revisions ($15) Tasks: Apply final corrections based on feedback. Deliver the completed spreadsheet with all data cleaned, formatted, and summarized. Files to Reference: All project files (including feedback notes, if provided). Final versions of the cleaned data and formatted tables. Guessing python, power query, vba, macros, some AI workspaces or other data analyst tools can make this smooth for you. Need done by Feb 13. Budget is $80 ...
I'm looking for a skilled professional to finish my partially completed website and to help with the digital marketing of my company. Website Completion: - Layout design: The website needs a polished, user-friendly layout that reflects my company's brand. - Content update: I need assistance in updating the website's content to ensure it's fresh, relevant, and engaging. - Functionality improvement: The website's functionality needs to be enhanced for a seamless user experience. Digital Marketing Services: - Social Media Marketing: I want to boost my company's visibility on social platforms, particularly Facebook, Instagram, and LinkedIn. - Search Engine Optimization (SEO): I need my website to rank higher in search engine results, driving more organic...
I'm looking for a seasoned recruiter to assist in identifying and managing top-tier candidates for diverse positions within our organization. Your primary ...our hiring managers. - Ensure a positive candidate experience by guiding them throughout the interview process. - Maintain an organized and efficient tracking system for all candidates. - Collaborate with our recruitment team to refine our hiring processes and provide constructive feedback on candidates. Ideal Skills and Experience: - Proven experience in recruitment, preferably within diverse fields. - Proficiency in utilizing various sourcing platforms. - Excellent communication and coordination skills. - Ability to provide a positive candidate experience. - Strong organizational skills for candidate tracking and proces...
...to load a URL via premium proxies while maintaining performance. Update and optimize the script with the latest Python libraries to ensure the process is smooth and reliable. Test and troubleshoot the script to handle errors, timeouts, and proxies rotation effectively. Ensure proper logging and error handling throughout the script to keep track of proxy usage and webpage requests. Collaborate with the team to meet project deadlines and requirements. Requirements: Proven experience with Python programming, especially in web scraping or automation. Strong knowledge of proxy management and handling authentication (username & password). Familiarity with the Resi GG platform and premium residential IP services. Ability to update and optimize Python scripts using the latest...
...for vibrant, colorful imagery - Ability to evoke specific emotions through visual design For pages: - public home page - header, categorie images, images - private home page - influencer landing page - about us - contact us - category page - product detail page - other 5 image headers for pages - other suggestions for font, colours, formating, general estetichal aspect Work in figma so we can update text / images later Payments is made after acceptance, at sources delivery. Offer should contains: - price for one set with iterations / feedback from beneficiary - price for second totally different set - links to finished works, websites executed by provider. Before awarding provider should demonstrate within a remote call. - delivery phases and delivery term - requirements fr...
I am in need of a seasone...and monthly reports. These reports will be derived from our job sheets, which are Word documents stored in Dropbox. Key Responsibilities: - Develop an automated system using Power Automate to generate weekly and monthly reports from our job sheets. - Ensure this system sends the reports to our management team. - Present the data in an easily digestible format using Excel. Ideal Skills: - Proficient in Power Automate and Excel. - Excellent understanding of data visualization through graphs. - Experience with interpreting and reporting on employee performance, repeat clients, and staff performance data. As for the data visualization, the type of graphs used will depend on the specific data being presented. Therefore, a flexible and analytical mind...
I'm looking to update my house's exterior color and replace the brick parts with stone. I have reference photos to indicate the desired color and stone finish. The photo I want edited is the red house with brick. I want the color to match the green house in the other photo and want the brick to be changed to stone that matches the stone in the second picture. Ideal skills and experience for the job include: - Proficiency in photo editing software - Experience with exterior design and color selection - Ability to replicate specific styles from reference photos Please note, the primary color for the new house exterior will be a medium tone. The stone finish for the brick parts will be the same as in my reference photo, so attention to detail is crucial.
I'm looking for a skilled Excel developer to create a custom Excel form for me. This form should automate the generation of professionally designed, formal and professional PDF donation receipts. The Excel form will need to collect: - Donor information - Donation amount and date - Custom messages or notes The ideal freelancer for this job should have extensive experience in Excel, PDF generation, and ideally has a background or understanding of creating formal and professional documents. The final output should be a single receipt per PDF.
I'm in need of an AI voice robot specifically for my restaurant. This bot will help in taking orders (both for delivery and dine-in), handling reservations, and answering FAQs. The bot should trigger a payment link via GHL on stripe once an order is placed. It should also update our Client POS after the payment is received. Key Responsibilities: - Taking orders: The AI should efficiently manage the order-taking process. - Handling reservations: The bot should help in managing table bookings. - Answering FAQs: The bot should have a comprehensive understanding of the restaurant's FAQs. - Payment process: After an order is placed, the bot needs to trigger a payment link. - Delivery Management: The bot should handle delivery orders based on ZIP CODE. The AI voice robot shou...
I'm seeking a talented designer to update my current logo into a round shape. The new design should maintain the core elements of the current logo - a shield in the middle with ivy going around it, and the word MAX at the top. Below the logo, the words "Oral, Facial and Implant Surgery of Chicago" should be included. Design Preferences: - Style: The updated logo should adopt a modern design style. - Color: The color scheme should be similar to the current one. Additional Notes: - The ivy design should not incorporate any additional elements. The ideal candidate for this project should have experience in modern logo design and a portfolio showcasing similar work. Strong skills in vector graphic design software, like Adobe Illustrator, are essential. Please provid...
