Excel vba automate macro add ins일자리
I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.
...comprehensive report summarizing findings, assumptions, and recommendations. Present financial models in an easily interpretable format for stakeholders. Key Deliverables: Financial feasibility model in Excel or equivalent software. Detailed investment and cash flow projections with supporting assumptions. Sensitivity and scenario analysis results. Executive summary with key insights and actionable recommendations. Qualifications: The ideal candidate should possess: Expertise in financial modelling for real estate projects. Strong knowledge of residential real estate market dynamics. Proficiency in Excel and financial analysis tools. Demonstrated experience in conducting feasibility studies for comparable projects. Engagement Timeline: The financial feasibility mode...
Sou dentista e preciso de uma tabela que será apresentada com orçamento para pacientes. Com intuito de padronizar a nomenclatura e agilizar o processo, preciso que o valor apareça de forma automática ao preencher o procedimento. Essa tabela precisa ter um bom design e possuir um tamanho imprimível. Podendo ser usada o moledo abaixo
I am looking for an Excel expert to assist with data analysis tasks. I already have the data for analysis and need help in identifying trends and making predictions based on the data. The desired outcome is to gain insights from the data for decision-making purposes. Ideal skills and experience for this job include: - Strong proficiency in Excel and its formulas and functions - Experience in data analysis and visualization - Knowledge of statistical analysis techniques - Ability to interpret and communicate findings effectively
I need a skilled photo editor to help me add a person to a photo in a casual setting. I've got the picture of the person to be added, and I have a rough idea of where they'd fit in the image. Ideal skills and experience: - Proficiency in photo editing software such as Adobe Photoshop or similar. - Prior experience in photo manipulation and editing. - Good understanding of perspective and spatial relations in photography. - Ability to follow vague instructions and make creative suggestions.
I am looking for a skilled professional who can automate regression testing for my web application. The application is built on Java and the testing needs to be done exclusively on Chrome. Key Requirements: - Extensive knowledge and experience in Java - Proficiency in creating automated tests for regression - Strong understanding of testing principles and methodologies - Experience with Chrome browser testing - Familiarity with various testing tools and frameworks Your role will be to set up and implement a comprehensive regression testing automation plan, ensuring the reliability and performance of the application with each update.
General Description The main objective is to automate betting within a specific tab of a mobile application (Android and iOS). The system should: Search for odds within a predefined range in the application interface. Place bets with a set amount, ensuring no bets are placed if there is already an open one. Continue repeating the process, searching for new odds and avoiding duplicate bets. General Considerations No API available: Automation will rely on techniques such as OCR, scraping, or similar methods to extract information directly from the app’s screen. Compatibility: The tool must work on both Android and iOS devices, operating in the background on the same mobile device. Access Restrictions: The development requires functional access to the mobile application, which...
Read current economic data and forecasts from and transfer them to an Excel table. See appendix for a list of indicators. Countries: USA, Europe, UK, Australia, New Zealand, Switzerland, Canada and Japan. Only the first page of the Excel sheet will be important to me. I would like to see the indicator(s) from the selected countries superimposed in a diagram using a checkbox. updating the data from the website should be possible at "the push of a button"
I'm in need of a skilled Data Entry Operator. The job involves working with text data from digital files, specifically Excel spreadsheets. You will be responsible for entering data into various computer databases and maintaining effective record keeping. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Strong organizational skills - Experience with data entry no
I need an expert in Excel to apply Color Scales conditional formatting on an Excel sheet containing number ranges. The color scale should span from Green to Red. Ideal Skills: - Proficiency in Microsoft Excel - Expertise in Conditional Formatting - Ability to work with number ranges Please ensure that you are able to deliver a well-formatted Excel sheet with the required conditional formatting.
I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.
I'm looking for a Google Sheets specialist who can help automate some of my data processing tasks. Specifically, I have a lot of data that needs to be transformed and formatted. Ideal Skills: - Proficient in Google Sheets, especially in using scripts for task automation. - Experienced in data transformation and formatting. - Capable of understanding and meeting specific data processing requirements. Your role will be to streamline my data processing tasks, making my workflow more efficient.
I need assistance with manual data entry. The data has to be extracted from video and organized into Excel spreadsheets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with manual data entry - Ability to accurately extract data from PDF files
...absentees or trends. *Total Students Present: Displays the number of students present in real time for each class or session. *Attendance History: Maintains detailed records of attendance for all students, accessible for review anytime. Staff *Staff Profiles: Maintain detailed records of teaching and non-teaching staff. *Task Assignment: Assign duties and track their progress. *Payroll Integration: Automate salary calculations and disbursements. Transport Real-Time GPS Tracking: Allow parents and administrators to monitor bus locations. Safety Features: Integrate panic buttons and emergency response alerts. Admission Management: * Online application and admission process * Student information management (personal details, contact information, etc.) * Fee structure and pa...
Build a excel spreadsheet identical to the photo listed Must have the formulas to make the boxes work correctly I need to have these in there Daily sales Cost of goods Total cars Job averages Sales projection Monthly targets Daily targets cost of goods will be total cost minus daily sales total Total cars will need to be calculated off of total sales and divided which will bring the job averages Monthly target will make a daily target depending on days in the month and Daily sales will affect sales projection
I'm seeking an expert to track and compile a list of properties from for properties all around London only with date it was uploaded to Rightmove. The list needs to be in Excel format and should include the address of each property & identification when a property updates to sold or under offer. I have included a screenshot from Rightmove and arrows showing the data that needs to be captured. Ideal Skills and Experience: - Proficient in data collection and analysis - Familiarity with Excel - Knowledge of real estate data tracking Key Requirements: - Regularly updated list of properties with the date it was uploaded/reduced around London on Rightmove - Regularly updated list of properties that has changed its status to Sold or Under Review - Picture
Lead Generator for Instagram Influencers Are you skilled in finding Instagram influencers? Join us on a simple but rewarding project! Role: We need a Lead Generator to hunt do...Role: We need a Lead Generator to hunt down qualified Instagram influencers within a specific target market (we’ll provide details). Responsibilities: Find influencers based on our target market. Provide qualified leads in a Google spreadsheet. Compensation: $1 for every 10 leads. The first milestone is 100 leads. Plenty of similar projects are available for long-term collaboration if you excel at this task! What We’re Looking For: Someone efficient and detail-oriented. A good understanding of Instagram influencer niches. If this sounds like a good fit, let’s work together! Rea...
I'm seeking an Excel expert to create a comprehensive budgeting and forecasting tool. The tool will need to accommodate: - Expense & Revenue tracking - Expense & Revenue forecasting using drivers The data will be manually entered, so the interface needs to be user-friendly, with clear instructions for inputting data. The ideal candidate will have: - Extensive experience with Excel, particularly with creating complex spreadsheets for budgeting and forecasting - A strong understanding of budgeting and planning - Proficiency in creating and implementing Excel macros The end goal is a robust, easy-to-use Excel file that will help me keep track of my finances and forecast future expenses and revenues.
I need assistance with my Microsoft Excel spreadsheets to delete duplicate rows without moving any data. The duplicates are identical rows. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with data cleaning and management - Attention to detail to ensure all duplicates are removed accurately and efficiently.
remove the nurse image and the text at the top of my website, and replace them with the slider I mentioned earlier in our conversation.
...in need of an Excel expert to transform a spreadsheet into a comprehensive inventory system. The system should be capable of receiving and logging orders, generating invoices, and providing a form for data entry. Additionally, there should be a way to attach drawings to the relevant items. Key Requirements: - Order tracking and logging - job scheduling - Invoice generation - Form for entering details - Capability to attach files as objects in Excel The system needs to accommodate more than 200 different types of inventory items. Ideal Skills: - Advanced Excel proficiency - Experience with inventory management systems - Familiarity with invoice generation in Excel - Ability to create user-friendly data entry forms Please bid only if you have extensive ex...
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...
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
