Vba macro reconcile bank data jobs
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I urgently need a passionate legal expert with proficiency in corporate law, specifically in relation to mergers and acquisitions. The main deliverable I expect is: - A detailed case study analysis addressing the topic Research topic: In the midst of increasing global crises, the World Bank is undertaking an “evolution” to deliver development impact more effectively and efficiently for people and the planet. In this context, do you agree or disagree with the following statement? “The World Bank should prioritize support for global public goods and addressing cross-border challenges that affect many countries, as opposed to individual member country-specific challenges and development priorities.” Discuss the potential legal and policy considerations w...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
...contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to ...
I'm looking for a Python script that uses PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and ignore the left panel. Second section: because this is sendkeys basically we will use the keyboard to navigate. A text box stating how many tabs until we get to the first web object button to select, Then a second text box to state how man...
I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...
...not yet purchased. Thirdly, users must choose to either rent a rifle for £20 per hour or bring their own rifle for free. Fourthly, they must acknowledge and accept the privacy policy, terms and conditions, and the safety agreement. Fifthly, users should enter their full name, phone number, and email address, and be able to purchase the lanes (and any rented rifles) with Apple Pay, Google Pay, or bank card to pay for the items from the booking system directly. Users should never be redirected to a separate website to process payments. This should process the user’s payment with PayPal and take out the full amount owed as soon as possible. Sixthly, users receive a virtual receipt to confirm the booking and what it includes via email. They should also be able to add it t...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
2 excel files with VBA macro as per customer requirement
I'm looking for a talented logo designer to create a modern and sleek logo specifically for our POS (Point of Sale) system tablet based , This POS system is not a bank swipe machine it's a system for taking orders. Key aspects: - Design a logo suitable for a POS system: The logo should be designed keeping in mind that it will be used in a sales transaction system. - Incorporate the Company Name: The logo should prominently feature our company name. - Modern and Sleek: I'm looking for a modern, sleek and professional design, in line with the modern POS system usage. Company Background: We are a company offering a Point of Sale (POS) system. We currently have a logo for our company but are looking to create a new logo specifically for our POS system, cropping our comp...
I am in need of a comprehensive business plan focused on a technology industry, primarily crafted to secure a bank loan. As such, the business plan should instill confidence in our financial viability and be convincing enough for loan approval. Key responsibilities would include: - Researching and understanding the nuances of the technology industry - Detailed financial planning including projected revenues, costs, and profitability Ideal freelancers for this job will: - Have a deep understanding and experience in the technology industry - Have strong financial planning capabilities - Show a proven track record in crafting successful business plans for securing bank loans - Be able to communicate technical and financial details in an understandable and compelling way.
One excel file with macro as per the customer requirement
We need to make improvements to the existing website or create a new one from scratch, using as a basis what we already have. Additionally, we require conducting a competitive analysis to identify the keywords that will allow us to effectively compete with other air taxi services. The revamped or improved page should include an integrated Local Bank payment gateway to accept all credit cards. It should also have a booking system that allows customers to select dates and destinations. The system will display the different available aircraft, as well as additional services, such as escort from arrival at the international airport to the domestic flight terminal, or customized tours and overflights on the destination route. The flight route should also be displayed on a map of Costa ...
I, ("Person 1" in the explanation below), am in need of an attorney in Virginia, USA able to appear before a judge in Fairfax County, VA in person or by phone/video according to the rules of the VA court system. Does VA require you to be a member of the bar to appear before a judge? - Person 2 is resigning and Person 1 agrees, so it wa...is my primary reason for seeking a VA attorney myself. Goal: settle matter as fast and inexpensively as possible. The parties are mostly in agreement. Filing in court was not necessary so forcing Person 1 to pay the legal bills of Person 2 might be contestable however. The entire task should be completed within a month. Turnaround time is significant as I aim to resolve the dispute swiftly so bank accounts can be unfrozen. I can prov...
I'm looking to hire a talented designer and developer with solid experience in Fintech for a digital bank project. Here's a brief overview: - The digital bank should have key functionalities such as account management, online payments - Online payments should support credit card payments, mobile wallet payments, and bank transfers. - The ideal user interface would be professional and corporate in design. Your main responsibilities will include the design and development of this digital bank. Ideal candidates should have a strong background in Fintech, and be able to create a professional and user-friendly digital bank that fulfills these specified requirements. If you're confident in your ability to deliver high-quality work in these ar...
...contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to ...
...multiple files, provide personal details, and make payments using Paypal, bank transfer, or credit card. I want this form to be simple, reliable, and secure. Key Requirements: - File Upload: The form should allow users to upload multiple files. There should be a clear indication of the allowed file types and a size limit. The uploaded files should be go to a Google Drive where a file handling automation script can be used. - Personal Details: The form should have fields for essential personal details. Although the specifics were not provided earlier, it's safe to assume this would include common fields like name, email, phone number, etc. - Payment Gateway Integration: The form should support payment via Paypal, bank transfer, and credit card. Ensure the payment proc...
...oversight - Advise team members and clients on Canadian tax strategy - Maintain knowledge of Canadian tax laws - Assist with client communication as needed Other Responsibilities (could include): - Prepare and maintain financial records, including general ledger accounts, financial statements, and other reports - Assist with month-end and year-end close processes - Perform bank reconciliations and ensure accuracy of financial data - Conduct account analysis and reconciliation to identify discrepancies or errors - Assist with financial audits and provide necessary documentation and support - Utilize accounting software (such as Sage, Xero, QuickBooks) to record and track financial transactions - Assist in the preparation of budgets and forecasts Qualifications: - Bachel...
I'm new to MYOB and currently need assistance in understanding and fixing journal entries, specifically after pay run. The project deadline is immediately, hence I'm looking for a trainer who can guide me on this immediately. Ideally, the freelancer should: My books are basic. I just want to do bank reconciliation. I expect explaining this will take a maximum of 1 hour with screen share.
We are seeking a reliable and efficient Virtual Assistant (VA) to assist us in setting up a company bank account in the UK. The ideal candidate will have experience in navigating the process of opening business bank accounts and be familiar with the requirements specific to the UK banking tried Wise but it's not working . Responsibilities: - Research and identify suitable banking options in the UK that offer virtual card options and can be accessed remotely. - Assist in gathering and organizing the necessary documentation and information required for the bank account application. - Liaise with banking representatives as necessary to ensure a smooth application process. - Troubleshoot any issues that may arise during the setup process and provide timely solutions...
I am seeking a proficient developer to incorporate additional methods of adding funds to a Telegram wallet. These should include Credit Card, Debit Card, and Bank Transfer - offering users a diverse range of options to suit different preferences. The funds should be processed instantly, providing real-time updates to the wallet's balance. For enhanced security, the system should integrate Two-factor Authentication (2FA), safeguarding the transactions of each user. Ideal Skills: - Expertise in payment gateway integration - Knowledge in Telegram API - Profound understanding of 2FA mechanisms - Experience in developing secure digital wallet systems
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...
...offer features that require user accounts. - Contact form: To facilitate communication between users and the site administrators. Additional features I need: - Gift vouchers: The ability to create and issue gift vouchers on the site. - Charity vouchers: Similar to gift vouchers, but specifically for donations to chosen charities. - Deposit funds in bank: A secure system that allows users to deposit their earnings from recycling into their bank accounts. Ideal skills and experience: - Proficiency in modern web design, including e-commerce features. - Experience in developing user account systems and secure transaction processes. - Understanding of environmental initiatives and recycling concepts would be a plus. Please reach out if you have relevant experience and can ...
I'm seeking a talented web developer to create a user-friendly, professional and corporate styled website from scratch for a charity. The primary objective of the website is to collect donations, hence, a reliable and secure payment system is crucial. The payment methods should facilitate: - Credit Card Payments - Direct Bank Transfers While the website can be a single page, it must be designed to look professional, yet be simple for visitors to navigate. Ideal candidates for this job are those with: - Proven web development experience, particularly with charity websites - Expertise in creating secure online payment systems - A keen eye for professional and corporate design - A track record of creating user-friendly interfaces - Respect for budgetary constraints Your...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...
As the client for this project, I'm seeking a skilled developer for an effective e-commerce website that handles both physical and digital products. This site needs to be specially developed for seamless bank transactions. Key requirements include: 1. Capability to list and sell both physical and digital products 2. A secure system for processing bank transfer payments 3. Immediate project commencement with swift completion Strong applicants should come with experience in e-commerce website development, payment gateway integration (specifically for bank transfers), and efficient project delivery capabilities. Familiarity with both physical and digital product catalogs is crucial for this job.
...financial loss to a customer. The research will be used to support a court case that we're preparing. Key Requirements: - Research Focus: The research should be centered around finding legal cases where banks have been held liable for negligence leading to financial loss for the customer. - Outcome: The ultimate goal is to obtain detailed information that can be used to build a strong case against the bank in question. Ideal Freelancer: - Legal Research Expertise: A background in legal research and a good understanding of banking law would be very beneficial for this project. - Attention to Detail: The freelancer should be meticulous in their research, ensuring all relevant information is accurately gathered. - Strong Writing Skills: The ability to present complex legal i...
I'm in need of a skilled bookkeeper who's proficient in Xero. The ideal candidate will have experience handling a variety of tasks, including: - Invoicing and payments - Expense tracking - Payroll processing I have 2 bank accounts that require reconciliation. The perfect freelancer for this job will have a comprehensive understanding of accounting principles and be able to manage bookkeeping tasks with precision and attention to detail. Please highlight your experience with Xero in your proposal.
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...
I am in need of a proficient Excel expert who can create a...if working over 12 hours. Overtime is paid at 1x between 06.30 and 18.30 Mon-Fri and 1.5x between 18.30 and 06.30 and on weekends. Overtime is paid at 2x on bank holidays and if urgently required last minute. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of complex calculations and formulas - Previous experience in creating similar spreadsheets for payroll or HR purposes would be highly advantageous - Attention to detail is crucial to ensure the correctness of the calculations The successful candidate will need to provide a user-friendly template that will make it easy for me to enter the necessary data each month. Please submit your proposal along with any relevant examples of yo...
Create an small ecommerce for selling tours in different locations with a landing page, a city page, tours (integration with an existing wp plug in from another system), a cart page and integration with a payment method with our bank (plug in with woocommerce)
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
Website needs to be upgraded in terms of design and improve how product photos are presented. See attached current website. Additional photos need to be added from image bank. Website has to optimise speed of photos display. Website has to be online before Sunday 21st April 2024
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
We need someone with experience in supabase and react native/expo, the main task is develop the business logic that we need in the app. Features: Authentication Post Post detail Post filter Create offers for those post List of offer...app. Features: Authentication Post Post detail Post filter Create offers for those post List of offers and filter View users profile and info List of transaction's Invoices list and detail Wallet like system (deposit and withdrawal) List of tables and columns: Profile, 9 columns Homework, 10 columns Offers, 4 columns Review, 6 columns Invoice, 10 columns Wallet, 7 columns Transactions, 8 columns Bank list, 4 columns Subjects, 4 columns The app is done in react native, we have the project with all design implementation, just need to integrate w...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
...analysis for my bank. My primary goal is to identify growth opportunities within our current operations. Key Responsibilities: - Perform a comprehensive financial analysis of our bank's operations - Identify any potential growth opportunities based on the analysis - Present your findings in a clear and concise report Ideal Skills and Experience: - Proven experience in financial analysis, specifically within the banking industry - Strong understanding of financial markets and banking operations - Excellent data analysis and interpretation skills - Proficiency in using Python to analyze financial data - Ability to think strategically and identify opportunities for growth - Experience in company's financial statements, market research reports, and c...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is...
I'm seeking a seasoned trader with in-depth experience in Index Futures and Options Trading. The goal is to maximize my capital by at least 60/70% a month. Here are some key aspects ...month. Here are some key aspects of the project: - **Skills Needed**: The ideal candidate should have strong capabilities in technical analysis, risk management, and algorithmic trading. - **Involvement**: I prefer a hands-on approach to the trading process, where I'm actively involved in decision-making. - **Markets**: The trading focus will be on Stock indices, with particular interest in Bank Nifty, Nifty, and Finnifty indices. Overall, I'm looking for an expert who can help me make informed trading decisions, manage risks effectively, and ultimately boost my capital signific...
...Alliances, Download) • Home Admissions (Online Admission Form, Official Representatives) • Departments (Academic Index, Code of Conduct, Faculty, Hospitals) • Publications • Press gallery. • Contact • Student Login • Parent Login • Consultant Login • Staff Login • Admin Login • Want to be a partner. 1. Student Login: 2. Login 3. Fee Details 4. Marks 5. Fee Receipt upload • Paid at College • Paid at Bank 6. Notifications 7. Graphical Representation 2. Parent Login: 1. Login 2. Fee Details 3. Student Grades 3. Consultant Login: 1. Login 2. Fee Details 3. Student Grades 4. Staff Login: 1. Login 2. Fee Details 3. Student Grades 4. Account Section 5. Attendance and Marks details 6. Accounts (Transactions Section) 7. ...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
...platinum from the drop down list as of now. The bidding value will be 1% more than the real time price-Admin fees (2.5%) (This will be functional once the live streaming will start working). So as such no extra work is needed in it. The locking period is 3 working days. It can be checked on the admin as it is already functional. (Just need to check) The sales amount to be transferred to the miner’s bank account manually and once the payment is done admin should update that on the miner’s table which would show the process as completed on both admin and miner dashboard.
