Excel vba automate macro add ins일자리
I need someone who is: 1) Experienced in using QuickBooks Online. 2) Experience...Understands or is able to learn Thailand accounting methods (not too complicated but need to be aware of Withholding Tax and some other taxes which can be explained) 5) Is methodical and organized and accurate in their work. Great attention to detail. 6) Can have a regular call (1-2 times daily if needed) until job finished. Work: - Review existing QuickBooks account to check and confirm accuracy with Excel. - Where there are inconsistencies, to highlight these first. After confirm with me then to make adjustment in the Quickbooks system to correct any errors. - Prepare Trial Balance Sheet, P&L statement And account summary (closing balances). - Ensure all accounts are accurately reflected in the ...
I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge
...fitness level, preferences, and goals, from strength training to cardio and flexibility exercises. # Nutrition Guidance: Balanced meal advice that complements your fitness goals, helping you fuel your body effectively. # One-on-One Coaching: Virtual or in-person sessions where I guide you through workouts, ensuring correct form, motivation, and progression. # Progress Tracking: Regular check-ins and adjustments to ensure you stay on track and achieve sustainable results. #Support & Motivation: A dedicated trainer who is always available for questions and encouragement, keeping you accountable. Whether you’re new to fitness or a seasoned athlete looking to refine your approach, I’m here to help you take the next step in your fitness journey. Let'...
...for Bulk WhatsApp Messaging Project Description: I am looking for an experienced developer or team to create a web application for sending bulk WhatsApp messages, designed specifically for businesses. The application should include the following key features: Bulk Messaging Functionality: Companies can send WhatsApp messages to multiple recipients. Recipients can be: Uploaded directly via an Excel sheet during message creation. Selected from the company’s pre-uploaded contact list or groups. Company Profiles: Each registered company will have its own profile. Profiles should include a history of sent messages and a log of recipients for each message. User Registration & Payment Integration: Simple registration process for companies. Payment gateway integration to ...
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.
create analysis in power bi and VBA for a company the analysis will include report for weak point and strengths needed to improve prefomance
...accurately identified the specific multisignature permission that needs to be eliminated. What I Need: - Guidance on a step-by-step process tailored to removing the identified multisignature permission from my Tron wallet. - Advice on safeguard measures to prevent future unauthorized modifications to my wallet settings. - If necessary, the creation of a simple tool or script that could automate the removal process or add an extra layer of security to my wallet. Ideal Skills and Experience: - In-depth knowledge of the Tron blockchain and familiarity with its wallet structure. - Experience in dealing with and resolving issues related to multisignature permissions. - Proficient in blockchain security best practices, especially related to the recovery and safekeeping of comp...
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? Within a month
I need a Python expert to help me with workflow automation using the Crisp chat system: Key Responsibilities: - Build custom functions that cater to specific client needs - Automate the customer service Ideal Skills: - Proficiency in Python - Experience with workflow automation - Familiarity with ticketing systems - Experiences with is a plus Expert in AI, Cursor (IDE), AIder (Coder assistant) Knowledge in pompting, parsing llm output, creating endspoint Open compatible
...super admin, admin and user profiles, upload content to our blog and news pages - and collect visitor analytics and data. The dashboard needs to manage all our systems - and user accounts - as well as content and blogs and articles - easily and quickly. It will be the main control centre for the whole website and all its functions and visitors. 4. Option to write a monthly newsletter - and automate this as an automatic send out to members and registered news readers - we would like to work with someone who has extensive knowledge of Ai systems - and who can help us to maximise the use of Ai technology. 5. I’d like to be able to check any names and addresses of anyone who has signed up to a news letter or as a blogger or journalist and soon, we will have customers - a ...
Zlecę wykonanie w excelu miesięcznego grafiku dla pracowników. Z podsumowaniem dni wolnych, pracujących, urlopów i dni do odbioru.
...accounts and is designed for both admin and evaluators. Key Features: - Admins can upload answer sheets in PDF format along with the corresponding mark scheme. - Evaluators assess the answer sheets using provided annotation tools: text comments, highlighting, and drawing. - Each student is able to view their individual scores and receive feedback on their answers. - All scores are exportable to an Excel sheet with detailed question-wise marks. - Feedback for students is sent via email notifications. Ideal Skills and Experience: - Proven experience in web-based application development. - Familiarity with creating systems for educational purposes is a plus. - Proficiency in implementing secure, user-friendly interfaces. - Experience in integrating with Google and Outlook services...
I'm seeking a professional who can set up a system that fully automates the updating of my investment portfolio Excel sheet with the daily NAV values from a specific website. Currently, I access the NAV values through manual browsing. This project requires: - Creating an automation system that fetches the daily NAV values from the website without any manual intervention on my part. - Updating my Excel sheet with the fetched data. The ideal freelancer for this project should have extensive experience with web scraping, Excel automation and ideally has worked with investment portfolio data before. The aim is to have a seamless process where my Excel sheet is always up-to-date with the latest NAV values. Please note that the specific format of the daily NAV...
Just create a new form to submit and view the listing submitted only.
I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, implied volatility and total open interest. You need to ...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. NEED TO CALL AND DISCUSS SOME DETAILS BEFORE STARTING WORK
### Description: I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. ...
I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, implied volatility and total open interest. You need to ...
I'm in need of a Windows-based offline software solution with a GUI to manage our residential campus. The software should support Admin and User roles, and automate tasks such as allottee registration and billing for utilities and maintenance. Key Features: - Allottee Registration: Track occupancy and vacation in various buildings. - Billing System: Generate monthly bills for electricity, water, DG set usage, and maintenance charges. The ideal software solution should be user-friendly, efficient, and capable of local data storage for offline access. Please recommend suitable options that meet these specifications.
I'm seeking a finance expert who can create a clear financial model with valuation in excel, focusing on our business, Flyer Eats and Swiss Cafe. This valuation is primarily for investment purposes, using the Discounted Cash Flow (DCF) method. I have historical financial data available for the past 3 years. Ideal skills and experience for the job: - Proficiency in financial modeling and valuation - Expertise in Excel - Familiarity with DCF method - Background in assessing businesses for investment purposes - Ability to present financial data clearly and succinctly
I need someone to assist in migrating user data from my online portal account to a CSV/Excel file. Ideal Skills: - Data Migration - Proficient in handling CSV/Excel files - Familiarity with online portals Experience: - Prior experience in similar data migration projects preferred.
...Bridal House 1. Detailed Analysis of Requirements 1.1 Context • The Bridal House is a boutique specializing in renting bridal dresses and accessories. • Identified Problem: A need for a solution to manage clients, prospects, item reservations, payments, and finances effectively. • Users: Internal staff divided into two roles: Employees and Administrators. 1.2 Main Objectives • Centralize and automate reservation management. • Provide precise financial tracking. • Enhance staff productivity. • Ensure sensitive data security. 2. Recommended Technical Specifications 2.1 Language/Framework • Backend: Node.js with Express. • Frontend: React.js. • Database: MongoDB. • Hosting: On-premises. • Accessibility: Res...
I need a freelancer to create a notification system for Jotform check-ins. This system should alert me via Mailchimp when customers have not signed in within a specified time frame. Currently, customer sign-ins are tracked using a Google Sheets document. Key Tasks: 1. Data Integration: You will need to condense and filter data from Google Sheets to identify customers who haven't signed in. 2. Notification System: Develop a solution to notify these customers via Mailchimp SMS. 3. Tools: Utilize existing tools like Mailchimp and Graze Cart for the integration and notifications. 4. Creative Solutions: Provide innovative and user-friendly solutions for automation and improving efficiency. Ideal Skills: - Proficiency in data analysis and integration from Google Sheets. - Ex...
I need a skilled video editor to enhance 9 talking head videos, each a maximum of 60 seconds. The project involves editing, subtitling in French, incorporating light animations, and color grading. Requirements: 1. Editing: Make the videos dynamic with smooth zoom-ins/zoom-outs. 2. Subtitles: Use an AI-generated tool for speed, but ensure to polish and align for accuracy. Subtitles need to be burned-in and clear. 3. Light Animations: Subtle, professional animations to highlight key points. 4. Color Grading: Apply a neutral tone to give a polished finish. 5. Fluent in french. Deliverables: 8 finalized MP4 files ready for delivery within a week. Ideal Skills: Video editing, subtitling, animation, color grading, French language proficiency.
Please note that the Budget is fixed - Need beginner skills users only - budget is as de...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic u...
I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.
I'm looking for a professional and experienced programmer who can help me automate the process of securing sports betting odds data from the website. This task involves using the API to capture data on upcoming events and historical data, then routing it to my hosting servers in XML format. Key Requirements: - Capture data on upcoming sports betting events and historical odds. - Format the data in XML. - Ensure the data is updated in real-time. Ideal Skills and Experience: - Strong programming skills with experience in API integration - Knowledge of sports betting data - Experience with hosting - Proficiency in data formatting, particularly in XML - Ability to execute tasks to a high standard.
I'm looking for a Google Sheets expert to help me automate data entry using checkboxes on a mobile device. Specifically, I need assistance with: - Using checkboxes as buttons for data manipulation (add, delete, edit) on a sheet - Implementing the onEdit function to trigger these actions when checkboxes are edited This project requires a deep understanding of Google Sheets scripting and experience with data entry automation. If you're proficient in creating scripts that can streamline this process for me, I'd love to hear from you!
Ich habe eine PDF mit öffentlichen Einrichtungen und benötige diese als Exceldatei. Im PDF sind diese jedoch nicht in Tabellenform aufgelistet wie benötigt. Diese gehört formatiert, damit die Spalten jeweils sortiert werden können.
I'm looking for a skilled WordPress developer to integrate a grid layout vlog section into my website's homepage. This section will primarily feature personal stories. Key Requirements: - Proficient in WordPress with a solid portfolio of similar projects - Experience with designing and implementing grid layouts - Ability to deliver a user-friendly, visually appealing section - Good understanding of SEO and website performance optimization The project doesn't require social media sharing buttons at this stage, but I may consider incorporating them in the future. Your expertise and guidance in making this section scalable will be appreciated. Looking forward to your bids.
Hi! I need a developer experienced in to add an FAQ page to my existing sales promotion website. I have a wireframe ready to guide the design and functionality. Also, I am facing a bug in the shopping cart you have to fix that too. The page should: - Match the site’s current design and layout. - Be fully responsive for all devices. - Include collapsible sections for a clean FAQ experience. If you’ve worked on similar projects, please share examples. Looking forward to working with you! Cheers, Usman Ali
I'm in need of a professional to assist me in preparing financial reports, analyzing expense data, and ultimately improving our financial performance. The reports should be in Excel spreadsheets.
Join the Top 1% of CRO Specialists! Do you excel at turning landing pages into lead-generating machines? Join our high-performing team! Position Overview We seek a results-driven CRO Specialist to optimize landing pages and digital funnels. Use your analytical and creative skills to drive campaign success and collaborate with clients for measurable results. Key Responsibilities Conduct data analysis and A/B testing for CRO strategies Design and implement conversion-focused strategies Collaborate with clients and internal teams for top-tier results Stay updated on the latest CRO trends Qualifications 2+ years in CRO with proven landing page success Strong portfolio showcasing conversion improvements Expertise with CRO tools (Google Optimize, VWO, Optimizely) Data-driven with exc...
I have a PDF file containing text and numbers that needs to be converted into Excel. Ideal skills and experience for this job include: - Proficiency in Excel - Experience in data extraction from PDFs - Exceptional attention to detail - Ability to work efficiently under pressure.
Rahul, Hello! A few months ago, you helped me to convert a Google Docs based spreadsheet ito an Excel format. I now need to use it for another client & want to change the values in the drop-down menu for the strengths/development areas. I was able to unhide the settings tab and update the dropdown menu source but now it causes a run error for our "start" setup function. What is the cost to fix this & also set it up so i can easily make these changes for other clients? Mary
Web scrape Automation: I can scrape multiple pages using Selenium and Python, extract all the data, and seamlessly convert it into an Excel file.
I'm seeking an Excel expert to assist with semi-monthly payroll calculations. Tasks will mainly involve tracking hours, vacation pay and holiday pay. The project has the following components: - Gross pay calculation: Accurately determining pre-tax earnings based on hours worked and other factors. - Tax deductions: Applying the correct tax rates and ensuring compliance with relevant regulations. - Net pay summary: Summarizing post-deduction amounts in a clear, concise manner. Skills and experience in data analysis and financial modelling are a plus, as is familiarity with macros and automation. The ideal candidate will be detail-oriented, reliable, and able to validate data to minimize errors.
Tenho ums sitema proprio utilizando apenas a linguem vba e o banco de dados acces, atualmente emito nfce e nfe atraves do site do sebrae, mas quero automatizar utilizando apenas o vba e o openssl para a assintura digital para conseguir automatizar o processo. entao o que estou tentando fazer éutilizar um modelo de xml , editando os dados e adicionando os dados de mais itens conforme necessario, assinado digitamente atraves do openssl (isso eu ja tenho pronto, ja consegui estrair os dados e as sub que fazem este processo), falta a estruturação do xml e validação junto a asefaz.
I'm in need of a customizable Excel template specifically designed for project management. This template should allow a user to input a project name and its go-live date, and in response, automatically populate all related deadlines, legal references, and resources. Please note, I will populate the actual document with the data, but require a fully functional template with adjustable formulas. Key Requirements: - The template must include deadline formulas that populate fields based on the proximity of the go-live date, taking into account: - The year (i.e., the year prior, odd years, etc.) - The number of days (i.e., 45 days prior to go-live, 60 days prior to go-live, etc.) - The month and/or day of the week (i.e., first Friday in August prior to go-live, second Thursda...
Project Description 1. Read data from Nse Bhav copy excel file 2. Do calculation as an output I need 9-10 columns after calculation 3. I need a code/ Software which I can use in my laptop 4. This code will ready the input file which I will put in a folder 5. Also calculate OI change activity if it getting in creased or decrease. 6. Oi change calculation input data will be in the same file 7. Calculate OI Interpretation
I am looking for a proficient Excel expert to design an Audit Tracker for me. This tracker will manage and monitor up to 50 separate audits. The tool should be capable of tracking both corrective and preventative actions as statistics. It should also present a live stats dashboard that displays the progress of all audits, current outstanding audits, and their respective progress. Key requirements: - The tracker should be able to identify and reflect audit trends for the year as audits are added. - The dashboard should include visuals primarily in the form of bar charts. - Additional information to be displayed on the dashboard includes: audit completion rate, monthly audit trends, and audit compliance scores. Ideal skills for this project: - Advanced Excel skills, including...
...de cálculo de importación desarrollado en PHP. Este sistema calcula el precio de costo de una compra del exterior, considerando múltiples datos como el precio de costo, el flete marítimo, el almacén fiscal, el agente aduanal, el flete interno, entre otros gastos. Los datos se manejan en dos monedas: USD y CRC, y el cálculo final siempre se convierte a CRC. adjunto el mismo calculo en excel un ejemplo en excel puedo dar acceso via AnyDisk, o por FTP Cambios y mejoras requeridas: Edición de facturas Al editar una factura desde la página principal, se abre otra página. En esta sección, se deben realizar las siguientes revisiones: Campo de porcentaje de gasto: Verificar que el cálculo del porcentaj...
I'm seeking a Machine Learning and TradingView specialist to help automate my trading strategies. The ideal candidate should have extensive experience with TradingView and a deep understanding of machine learning principles. You should be able to develop and implement algorithms that will enhance my trading efficiency and effectiveness.
I am looking for a blockchain developer with expertise in EVM (Ethereum Virtual Machine) to create a smart contract-based system for the supply chain. The primary focus of this project is the automation of transactions using smart contracts. This project will involve: - Designing and developing smart contracts to automate transactions within the supply chain. - Implementing the system on an EVM compatible blockchain. - Ensuring the solution is secure, efficient and scalable. Ideal candidates for this project should have: - Extensive experience in blockchain development, particularly with EVM. - Strong knowledge of smart contracts and their application in the supply chain. - Proven ability to design and implement secure, scalable solutions.
We have designed an industrial building that we need rendering of and then put in to pictures of the building site. The building consists of a lot of glass, sedum roof and solar panels. The pictures will be used for information of the building project. We have taken arial photos into which we want to have the building and the surrounding ground to be implemented. The building is drawn in cad software and a 3d file will be emitted. File format can be discussed, today it is in .stp format.
...information from both platforms in Namibia on a daily basis. The scraped data should be neatly organized in an Excel spreadsheet. Key Requirements: - The scraper should pull data from all relevant sources, including government websites and social media. - Information to be collected includes: the name of the entity or organization, tender advertising date, due date, a clickable link for document download, and contact details. - One of the primary websites to scrape from is: , which mainly hosts government tenders. - The scraper must ensure no tender is overlooked. Ideal Skills and Experience: - Expertise in web scraping and data collection. - Familiarity with Excel and data organization. - Experience in developing scrapers that gather information from both web and socia...
I need an Excel expert to create monthly reports for my crockery and cutlery inventory. Sales Report: - Should include total revenue. Inventory Report: - Should include sold items and quantities. Sold Items Breakdown: - By category (e.g., crockery, cutlery). The ideal freelancer for this project would have extensive experience in Excel and data analysis, with the ability to create clear, concise reports. Familiarity with inventory management and sales reporting would be a plus.
Graphics and design are two important elements in data visualization and effective communication. Here are some tips for creating good graphics and designs: Chart 1. Choose the right graph type (bar, line, circle, etc.). 2. Use contrasting and harmo...6. Use animation wisely. Design 1. Choose a font that is clear and consistent. 2. Use colors that match the theme. 3. Arrange the composition and free space. 4. Create a simple and intuitive design. 5. Ensure alignment of visual elements. 6. Use relevant images and icons. Graphic Creation and Design Tools 1. Adobe Illustrator 2. Canva 3. Tableau 4. Power BI 5. Google Data Studio 6. Microsoft Excel Additional Tips 1. Know your audience and goals. 2. Use accurate data. 3. Create a responsive design. 4. Test and refine. 5. Ensure acce...
