Excel vba automate macro add ins jobs
Attached file that need updating, this sheet will be used on a monthly basis to value works completed and invoiced, the user is not very good with spreadsheets and is unable to track changes etc. What I am looking for is an easy way in which each time they open the sheet they can simply enter the percent complete in column D and columns E,F and G are updated accordingly. Need some wise logic to track rolling-over of valuations with the additions of newer percentages. Also need a provision to save the file as PDF.
... - A $20 bonus (total $50). - The opportunity to earn from the freelance project itself. - Gain valuable insights to improve your client communication and project management. What’s in It for the Client? - Clients gain access to a powerful project management tool that: - Provides real-time project updates without interrupting you. - Let them add milestones, extend contracts, and generate detailed reports. - Eliminates the need for constant check-ins and status calls. Why This Matters Satisfied clients mean renewable contracts, less time wasted on updates, and more time focusing on what you do best—building amazing software. How to Apply If you’re ready to improve your freelancing success and join this exciting experiment, apply now with your resume and...
I'm seeking an RPA expert to help automate parts of our workflow management system. The primary goal is to enhance efficiency and reduce manual workload. Key Tasks to Automate: - Document approval processes: Streamlining the approval of documents to speed up workflows. - Task assignment and tracking: Automating the distribution and monitoring of tasks for improved productivity. - Notifications and reminders: Ensuring timely communication without manual intervention. You'll need to integrate the RPA solution with: - Microsoft Office Suite: Primarily for document handling and task management. - Google Workspace: For email and calendar coordination. Ideal Skills and Experience: - Proven expertise in Robotic Process Automation. - Experience with workflow management a...
I'm looking for a simple Python project that involves creating a Command Line Interface (CLI). The script will automate sending text for specific rules via Python (Selenium). Ideal Skills and Experience: - Proficient in Python programming - Experience in developing Command Line Interface (CLI) tools - Understanding of python and selenium Key Features: - A straightforward dashboard that sends reminder messages automatically Please provide your experience and examples of similar projects you have completed.
I'm seeking a professional to assist with automating my Shopify store order details into a Google Sheet and sharing print files with...a professional to assist with automating my Shopify store order details into a Google Sheet and sharing print files with my print company. 1. Automate Order Details: I need order item details and print files to be fed into a Google Sheet in real-time. The data should be sent without any transformation, just as raw data. 2. Sharing Print Files: The print files are stored on AWS. I need to set up an AWS EC2 instance to either add the files to a google sheet, or email the files to my print team. Ideal skills for this project: - Experience with Shopify and Google Sheets - Proficiency in AWS - Skills in setting up an EC2 instance - Ability...
i am having an excel script which is used to send whatsapp messages , some bug is there through which its not letting through properly , full message is not going NEED AN EXPERT ONLY , lets not waste anyone's time please ***urgent Language : VISUAL BASIC in EXCEL
I'm seeking a skilled data analyst who can help with comparing Excel sheets, data cleansing, and performing descriptive statistical analysis on the data. Key tasks: - Identify differences between multiple Excel sheets - Cleanse and standardize data - this includes removing duplicates, handling missing values, and standardizing formats - Conduct descriptive statistics to provide insights from the data Ideal skills and experience: - Proficient in Excel with strong attention to detail - Experienced in data cleansing and comparison - Skilled in performing and interpreting descriptive statistics - Able to deliver clear and concise reports of findings
I'm in need of a meticulous and dedicated freelancer to assist with manual data entry from scanned documents into Excel spreadsheets. Key Requirements: - Strong attention to detail and accuracy - Proficient in using Excel - Able to handle manual data entry tasks - Comfortable working with scanned documents Ideal Skills: - Data Entry - Excel proficiency - Attention to detail - Ability to work independently and meet deadlines
I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.
I'm looking for a skilled Excel professional to assist with merging data from various Excel sheets. Key Responsibilities: - Merging data from multiple Excel sheets into a cohesive, organized format - Ensuring specific columns or headers are accurately matched during the merging process Ideal Skills: - Advanced knowledge and experience with Excel - Strong attention to detail - Ability to follow specific instructions accurately Experience in working with amenity-based pricing data is a plus. Please provide examples of similar projects you've completed in your proposal.
I have an educational iOS app that currently supports Google login. I'm seeking a developer to integrate the "Sign in with Apple" feature. This app contains paid content, hence it's essential that subscription status is synchronized across devices. Key Requirements: - Implement "Sign in with Apple" feature - Ensure subscription status is synchronized across devices - Allow users to link their Apple ID to an existing account Ideal Candidate: - Proven experience with iOS app development - Familiarity with integrating "Sign in with Apple" - Skills in synchronizing user data across devices - Experience with implementing account linking functionalities
I'm seeking a proficient app developer to create a comprehensive, interactive learning platform for nursing students. This app will be designed for both iOS and Android, featuring: - Interactive Course Modules: Covering crucial nursing topics like anatomy and pha...and pharmacology. - Quizzes and Practice Exams: To aid in preparation for professional certifications such as the NCLEX. - Interactive Flashcards: For quick revisions and reinforcing learning. - User Login: Ensuring personalized experience and progress tracking. The aim is to deliver a user-friendly, interactive, and education-focused app that simplifies nursing studies and empowers students to excel. If you have a knack for interactive app design and a specialization in education-oriented solutions, we would love ...
I am looking for a freelancer to help me add contacts to 10 WhatsApp groups related to scrap dealing. Each group contains up to 1000 contacts, and I will provide 10 CSV files, each with 1000 names and contact numbers of scrap dealers. Responsibilities: - Add the contacts from the provided CSV files to the designated WhatsApp groups. - Ensure each group is populated with 1000 contacts. Requirements: - Experience with WhatsApp groups and contact management. - Attention to detail and ability to ensure no duplicate contacts are added to any group. - Ability to work with CSV files and efficiently upload contacts into WhatsApp. How to Apply: - Please submit your application along with your previous experience related to managing WhatsApp groups or handling large contact lists.
I have a well-developed Kaizen Tracker in Excel that needs some updates. Specifically, I would like to add or update some bar charts and pie charts, rearrange some data columns related to current performance metrics, and improve the presentation of existing graphics. **Do not reply just to reply. Read the skills first** Ideal Skills: - Proficiency in Excel - both programming and user interface - Experience with data visualization - Understanding of performance tracking - Knowledge of Kaizen methodology - Looking for someone to collaborate with together Please submit your bid if you have the necessary skills and experience.
...candidate will have strong expertise in CI/CD pipelines, AWS infrastructure, microservices deployment, and security compliance, with a passion for performance tuning, disaster recovery, and incident management. If you're ready to work with an agile team, and have the ability we want to hear from you! Key Responsibilities CI/CD Pipeline Management Design, implement, and maintain CI/CD pipelines to automate build, test, and deployment processes. Integrate security testing tools into CI/CD pipelines for proactive vulnerability detection. Streamline workflows and version control using GitHub Actions, GitLab CI/CD, or Jenkins. AWS and Cloud Infrastructure Management Design and manage secure and scalable AWS environments, including server and serverless deployments. Implement ...
I need a solution for my Android phone. Id like it to automatically opens links I receive in my default messaging app which is google messaging. The links start off with the same url but follows with different 'keys' and 'id's. I've tried using Macrodroid, but I am encountering difficulties. Key Requirements: - The solution should be reliable and efficient. - It can be an app, a script, or another method, as long as it works. Skills and Experience: - Experience with Android automation tools or scripting. - Familiarity with Macrodroid is a plus. - Ability to provide a user-friendly solution.
We are a small IT company based in Sydney, looking for a simple Purchase Order Application/Automation using Microsoft applications, such as Microsoft Dynamics, Power App or Power Automate. We are currently utilizing Microsoft 365 applications. (The current process is manual)
I'm seeking help with adjusting column widths in Excel to fit text without wrapping. Ideal candidates should have strong Excel skills, particularly in formatting, and be able to deliver a clear and organized spreadsheet.
I need an Excel expert to help me lock an Excel file to restrict any one to bypass my macro password. - The task involves securing an entire workbook with a combination of a strong password and digital signatures. - Ideal candidates should have extensive experience with Excel's security features and macros. - Knowledge of creating and applying digital signatures is crucial. - The goal is to ensure that only authorized individuals can access the macro, while keeping the rest of the workbook secure. sample files attached
I'm looking for a skilled web developer to build a website that can convert various document types. Key Features: - Conversion from PDF to Word, Word to PDF, and Excel to PDF. - A user-friendly interface that allows seamless file uploads and downloads. Additional Skills: - Experience in building conversion tools is a plus. - Strong understanding of web security for user data protection. - Ability to create a responsive design that works on both desktop and mobile. Please note, this project does not require user authentication, progress tracking for conversions, or email notifications for completed conversions. I look forward to seeing your proposals.
I'm seeking a highly skilled CAD specialist to assist creation of bespoke products created to fit extracted edges from a point clouds obtained by 3d scanned models. I need to simplify and automate the process of moving from cloud to bespoke designs that can be 3d printed using open source tools. Ideal Skills and Experience: - Extensive experience in 3D modeling, specifically for product design - Proven track record of creating high-detail models - Proficiency in CAD software - Some experience in programming - Excellent attention to detail - Ability to meet deadlines and deliver high-quality work
I am using Windows 10 and Microsoft office 10 Pro. plus excel version 14.0.7268 32 bit I have one line in Excel that is occassionally repeated. When I execute the macro it should: put 20.25 in column B put 59.70 in column F put 6.95 in column G put 5.21 in column H put 4.31 in column K the numbers stay the same, but when I run the macro i created it always puts the numbers in the same row I created the macro in. I want to macro to run on the line the cursor is in. so if my cursor is at A17, and execute the macro, the numbers should go on row 17.
I'm in search of a talented full-stack developer with a knack for creating interactive web applications. This project focuses on building a nutrition-centric app that will automatically generate meal recommendations based on user inputs. Key Aspects of the Project: - The app will ...or similar. o Strong skills in HTML, CSS, and JavaScript. AI Integration: o Experience with GPT-4/OpenAI API or similar for dynamic content generation. o Ability to work with prompt engineering and fine-tune AI behavior. Nutrition Database Integration: o Experience with APIs like USDA, Nutritionix, or manual database structuring. Testing & QA: o Ability to ensure accuracy and reliability of macro/nutrition calculations. Deployment: o Familiarity with cloud hosting platforms (e.g., Heroku, ...
Need assistance checking my work, formulas, on this spreadsheet for accuracy. Mainly Row's 17 thru 20. This is a cost analysis comparison. I want to ensure the $12.50 + 1 basis point + 3 cents accurately equate to the total in row 20. These mention rows are the cost of doing business relative to the 'Card Volume' and 'Transactions' listed in Row's 5 and 6.
This is at the bottom of priority list I need this report summarized into 6 or so pages As always please recreate the charts and embed Once completed please upload backup excel files You know the drill
...to build a live dashboard for pre-employment medical assessments. The dashboard should integrate with Office 365, be able to use Snapforms events as triggers, and allow for external access. The information below is an indication of what is required. The final scope can be defined in consultation with our subject matter experts. Configure Snapforms submissions to trigger events in Power BI. Automate the placement of PDF files into a designated SharePoint location upon Snapforms submission. Trigger an updated CSV file for questionnaires to be added to the Power BI dashboard. Utilise Power BI to create relationships between data on booking and assessment forms Link to PDF reports added to SharePoint for both online questionnaires and face-to-face (F2F) assessment reports. Generat...
I'm seeking a professional who specializes in Excel and PowerPoint to link the content of my financial dashboard across two Excel tabs to my PowerPoint slides. This will ensure any updates are synced in real-time. Ideal Candidate: - Excel and PowerPoint expert - Financially savvy - Experienced in creating professional presentations Please note: This project does not require marketing or branding expertise. The focus is strictly on financial data and presentation.
I am seeking an experienced RPA Engineer to develop and maintain RPA workflows that integrate with eClinicalWorks, our electronic medical records system. Key Responsibilities: - Automate clinical workflows using RPA - Both create new workflows and maintain existing ones Ideal Skills: - Proven experience with RPA development - Familiarity with eClinicalWorks (preferred) or other electronic medical records systems - Capability to automate complex clinical processes The ideal candidate will have a strong understanding of clinical workflows and how they can be optimized through automation. Experience with patient data entry, appointment scheduling, and billing and invoicing processes will be beneficial. Attached is an existing workflow.
I'm seeking a proficient content writer to improve user engagement through captivating social media updates. The main objective is to automate the process of crafting these updates without compromising on quality or creativity. Ideal Skills and Experience: - Proven track record in content writing, specifically for social media. - Experience with content automation tools. - Understanding of user engagement strategies. - Creative thinking and ability to generate captivating content. - Capacity to maintain quality and creativity in automated content.
I'm looking to turn my WordPress website into a robust e-commerce site that can handle herbal product sales. Key Requirements: - E-Commerce Integration using WooCommerce. - Payment Options for setting-up Cash on Delivery (COD) and manual bank transfer payment methods. - Optimize Checkout for a seamless and user-friendly experience. - Ensure Responsive Design for mobile compatibility and smooth navigation. - Integrate Google Analytics for tracking website performance and user behavior. - Social Media Integration with Facebook and Instagram for product sharing and promotions. - Set up Order Notifications via email to the admin. Additional Information: - The website design and content are complete and ready to use - No payment gateway integration is required, as we will only use COD a...
... Varnish Charge Lamination Charge Glue Charge Plate Charge Total WT Total Making Cost Total Unit Cost Paper cost this is what i am presently doing in excel and i get result, but i need to do it in python as a project, let me explain you what all these and what is my target result. before that can you tell me if i can do it in python? i will explain about all the headers and its funciton after your reply. i want to replicate and enhance current Excel process using Python! i want to be able to Perform calculations on the data (like total material cost, making making cost, unit cost, etc.). Automate repetitive tasks (e.g., updates based on inputs). Analyze and visualize data effectively. Generate dynamic reports. We are carton factory producin...
I need assistance with my Excel line chart. I've been trying to change the maximum bounds on the format axis, but I can't seem to do it. Ideal skills for this job: - Proficiency in Excel - Experience with creating and modifying line charts - Understanding of numerical data handling in Excel
...register and apply for event tickets based on their membership tier. Automate ticket allocation, including a weighted lottery system for contested tickets. Provide an admin dashboard for managing events, tickets, and user data. Notify users of application confirmations, allocation outcomes, and deadlines. Key Features: User Portal: Secure registration/login. Manage membership tiers (e.g., Basic, Silver, Gold, Platinum). View available tickets for upcoming events and apply. Lottery System: Weighted entries based on membership tier. Automated allocation for contested tickets. Direct allocation for uncontested tickets. Admin Dashboard: Add/Edit/Delete events and ticket allocations. Vie...
I'm seeking a proficient Pine Script developer to enhance my existing script with alerts. This is a crucial aspect of my trading strategy, and I need the script to alert me whenever the price crosses a specific level. Key Requirements: - The alert should be triggered for both directions: crossing above and crossing below the specified level and should only trigger once at a time. Should save the price level last triggered. - Alerts should be delivered via email notifications, push notifications, and on-screen pop-ups within the trading platform. Ideal Skills: - Extensive experience with Pine Script and trading platform integrations. - Prior experience with setting up multi-channel alert systems. Please bid if you have the necessary skills and experience.
I'm seeking a talented and creative web developer to build a cutting-edge online search and booking platform. This website needs to function as a comprehensive travel hub, providing effortless booking for ...packages. -Trending blogs highlighting top destinations and daily specials. Subscription and Reviews: -Newsletter subscription option to keep customers updated. -Space for customer reviews to build trust and showcase experiences. Support Pages: -Messaging, text, and call support to assist clients. -Detailed information about payment methods, booking policies, baggage rules, seating, extras, check-ins, and boarding. Client Options: -My Trip section for clients to manage their bookings. -Sign-in functionality for personalized services. -Language toggle for English and Fre...
I need a professional web developer with Elementor and CSS expertise to help me customize the Add to Cart widget on my website. The modifications will include adjusting the color and background, size and spacing, as well as typography to match my established style guide. Key Requirements: - Proficient in CSS with ample experience working with Elementor - Ability to understand and implement changes according to a provided style guide - Past experience with customizing eCommerce widgets will be an advantage - Excellent attention to detail to ensure all modifications are consistent and precise. I would appreciate to get advice on how to replicate this styling to all product page templates
I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurate data capture
I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in 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 c...
I'm seeking an expert to automate the deployment of Windows 11 and Windows 10 (two variants in delivery) using custom configurations. This includes the use of provisioning packages, Windows Configuration Designer (WCD), and various scripts. Key Requirements: - Deploying both Classic (Win32) and Universal Windows Platform (UWP) applications. - Implementing a range of configurations including Network settings, User account settings, Security policies, and shell scripts. - Utilizing multiple script types including PowerShell scripts, Batch scripts, and Shell scripts. Ideal Skills: - Extensive experience with Windows 11/Windows 10 deployment and configuration. - Proficiency in both Classic (Win32) and UWP app deployment. - Advanced scripting skills, particularly in PowerShell, Ba...
I need the word "USA" added below the Cancoil text in a digital file for branding purposes. Key Details: - The current Cancoil text is in a digital file, specifically in a JPEG/PNG format. - The modification should be seamlessly integrated to maintain the integrity of the branding. - The freelancer should have experience with graphic design and branding. Ideal Skills: - Graphic Design - Branding - Proficiency in working with JPEG/PNG files. - Once completed, need the logo converted to hi-res (vector, eps) Please ensure your proposal includes examples of similar past work. Thank you!
Hi everyone! I have a Java-based Password Manager application that needs key enhancements to improve f...Implement encryption for the master password and all stored credentials (username, email, and passwords). 2. **Master Password Unlock:** Create a feature where entering the master password unlocks a screen displaying stored credentials for all applications. 3. **App Management:** Enable adding new applications and ensure they appear dynamically in the app selection list. 4. **Optional Enhancements:** Add a bottom sheet menu for data synchronization and allow direct app connection after saving credentials. The current project files will be provided IN CHAT. I’m seeking an experienced Java developer to deliver a secure, user-friendly solution efficiently. Deadline: 25/12 B...
Budget is low! I'm seeking a skilled Excel/Google Sheets expert to assist with my trading analysis file. The sheet is pivotal for determining entry prices, evaluating trade quality, and tracking profit and loss. Key Responsibilities: - Improving and fixing complex formulas related to entry price calculations - Ensuring all calculations are accurate and reliable Ideal Qualifications: - Proficient in Excel and Google Sheets - Strong comprehension of financial calculations and trading concepts - Experience in data organization and creating visualizations Please note, while the initial focus will be on fixing and enhancing the entry price calculations, I may require additional support with data structuring and visual representation in the future. Accuracy and reliability...
Description: I’m looking for a skilled developer to enhance an existing payment registration window in my application by adding a date picker functionality. Requirements: Add a date picker to the payment registration window (refer to the screenshot provided). This date picker will allow users to select a specific date for payment registration. The selected date should be stored as the official payment registration date. Ensure that the functionality is similar to the date picker already implemented in the Installment view (screenshot available). Maintain consistency in design and behavior with the rest of the application. Key Points: The new feature must integrate seamlessly with the current system and database logic. It should support different date formats (if required) de...
I need assistance with an Adobe Premiere project file. The task is to import the project file and run a script that will automatically export all individual clips from the timeline. To be clear, a batch script would be fine, but in the end, I need all the clips that are on the timeline to be exported and put into a folder, all individual files, for each clip, in an MP4 format. So, I want to import the project file into Adobe Premiere, see the timeline with all the clips, and then somehow run the script, which will take each individual clip from the timeline and put export it, either one by one, or by batch, and put them in a folder. I need help installing these apps, building the script, and running the script, so I can use this in the future. Requirements: - Use Adobe Extendscript to ru...
...flight data from Excel tables. The chart will be used to track both flight schedules and aircraft positions, so it's imperative that it accurately depicts arrival and departure flights, along with their corresponding aircraft registration. Key requirements: - The horizontal axis should represent dates and times, with a red vertical line indicating the current time. - The vertical axis will show the aircraft stands. - Flights need to be depicted as horizontal bars, with the size of the bars determined by the arrival time of each flight. - Bars need to be split in case of aircraft repositioning. All of this data will be sourced from provided Excel tables which consist of flight number, time, aircraft registration, and aircraft stand. The Gantt chart must be created in...
I'm seeking an Excel expert who can add a pop-up calendar to specific cells in my spreadsheet. - Purpose: The calendar is needed for date entry for scheduling purposes. - Format: Dates will need to be entered in the DD/MM/YYYY format. Ideal candidates for this project should have a strong background in Excel, with particular experience in implementing interactive features. Please ensure you can deliver a user-friendly solution that will streamline the scheduling process.
Extract Ealing Landlords data from website and organize into Excel
