Vba reconciliation macro jobs

I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first closes...

Are you seeking a professional to streamline your bank reconciliation process and provide insightful financial analysis? Look no further! I offer comprehensive bank reconciliation services tailored to your business needs. Services Offered: Bank Statement Conversion: Convert PDF bank statements to Excel format for easy analysis and reconciliation. Expense and Income Categorization: Thoroughly categorize expenses and incomes to provide a clear overview of your financial transactions. Bank Reconciliation: Reconcile your bank accounts with your financial records to ensure accuracy and identify discrepancies. Profit and Loss Statement Creation: Develop Excel-based profit and loss statements or create them using accounting software to assess your business's...

I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowled...

...linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...

...I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • G...

I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.

Adjust the VBA code to exclude names

Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.

I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee T...

I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human r...

...record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...

I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data...row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user-friendly interfaces within Excel for ease of customization by the end user w...

As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.

hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by us...project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible...

I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.

Please Sign Up or Login to see details.

...Responsibilities: - Automating repetitive tasks within the Excel spreadsheets, to increase efficiency and accuracy. - Customizing the spreadsheets to better suit the specific requirements of my business. I have a specific deadline for this project, so it's important that you are able to work efficiently and effectively within the given time frame. Skills and Experience: - Proficient in Excel and VBA - Experience in spreadsheet automation and customization - Strong communication skills to understand and implement my requirements - Ability to deliver within a set deadline - Previous experience in similar projects would be a plus. If you're an intermediate Excel developer with a solid understanding of automation and customization, I'd love to hear from you. Pleas...

I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deliver eff...

I'm in need of an experienced freelancer with ex...QuickBooks Online (QBO) to handle a large volume of financial transactions. Specifically, the task is to reconcile bank, credit card, and PayPal transactions amounting to approximately 3000 transactions for the past 3 years. These transactional data are all available in Excel CSV format. The successful freelancer should be skilled at: - Extracting data from Excel CSVs into QBO - Performing reconciliation processes in QBO - Categorizing transactions accurately into Income and Expenses - Handling a large volume of financial data Your attention to detail and accuracy will be critical to the successful completion of this project. I look forward to working with a trustworthy professional who can ensure the integrity of my fin...

I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools wou...

I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools wou...

I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.

I'm seeking a highly competent freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way ...

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:

Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks

I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, please reach out and explain your approach.

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

...should be able to generate invoices for my clients and help them keep track of payments. - Bank Reconciliation: The system should be able to reconcile bank statements and help in comparing the transactions with the actual bank statement. - Expense Tracking: It's essential that the system can track expenses and provide insightful reports that my clients can use. User Interface Design: The user interface should be designed with a step-by-step guidance in mind. I want the software to be user-friendly and easy to navigate for clients with varying tech-savviness. Ideal Freelancer: - Experience in developing cloud-based accounting software - Proficient in Invoicing and Billing, Bank Reconciliation, and Expense Tracking systems - Adept at creating software with step-by-st...

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

I'm in need of a developer adept at using Visual Basic for Applications (VBA) within Excel to scrape exchange rate data from the web. Key aspects of the project: * The focus is on extracting textual content and tables from exchange rate websites. * The specific data to be extracted includes: * Currency codes * Exchange rates * Date and time Ideal candidate's skill set: * Proficiency in Excel VBA with a focus on data extraction from the web. * Familiarity with financial and exchange rate data is a plus. * Ability to implement robust error-handling processes within the script. * Clear communication and timeliness. I look forward to engaging with a knowledgeable freelancer who can fulfill these requirements promptly.

I'm in need of a skilled freelancer bookkeeper adept in QuickFile accounting software for my bank reconciliation tasks. This task needs to be performed on a weekly basis. Initially there is a task to reconcile last year full transactions (12 months), tagging and classifying transactions. Matching bank receipt against and Airbnb invoices. The volume of transactions processed each week is less than 100. It's vital for the candidate to process these transactions accurately, ensuring that my financial records are correct. Ideal Skills and Experience: - Proficiency in QuickFile accounting software. - Experience in bank reconciliation. - Strong attention to detail. Doing the work in Excel is OK.

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...

I'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.

As an individual who has taken the first steps towards digitizing data management, I am seeking a proficient Android developer who can transform my existing Excel-based userforms into an enticing Android appl...- A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, experience in database sync technologies is a must. All in all, a successful candidate should demonstrate ample experience in Android application development, a knack for intuitive UI/UX design, and familiarity with data syncing between Android and Excel. While the knowledge of VBA isn't required, it could be advantageous to understand the context of the userforms better. Let's enhance the usability of our userforms and bring this vision to the fing...

As a beginner in Excel and VBA Programming, I am actively seeking an experienced and knowledgeable tutor who can guide me on the journey to developing structural analysis software. I am reckoning on an efficient and in-depth learning experience tailored around my unique learning pace and style. Key Objectives: - Understand Basic to Advance VBA coding and its application in Excel - How to implement complex algorithms in VBA - Grasp of data analysis functions and graphical interface capabilities in VBA Ideal Tutor's Profile: - Qualified tutor with solid and demonstrable grasp of VBA and Excel - Proven experience teaching VBA with commendable patience and understanding - Proven experience developing structural analysis software will be a plus ...

We are looking for a bookeeper to assist with ongoing functions for 2 businesses including: - Pay roll management in Xero - Cash reconciliation - Accounts receiveable and payable - Running of monthly reports such as P and L and cashflow - Managing debtors Ideally someone CPA qualified that is an EXPERT in xero and able to work in Australian time zones. Must be able to attend all staff meetings, and be online to answer questions inside Australian working hours.

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are ...

I am currently encountering an issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues relate...

...schools and reconciliation : Canada confronts its history. Toronto: University of Toronto Press, 2017. Milloy, John S. A National Crime. Winnipeg: Univ. of Manitoba Press, 2017. Redhage, K. R. “A Genocide the World Has Ignored: Holding Governments and the Catholic Church Accountable for Residential and Boarding Schools through the Icc.” Brooklyn Journal of International Law 48, 2 (2023): 801–34. Smith, Mark. “Beyond a Single Story: Peripheral Histories of Boys Brought Up in a Residential School.” Ethics & Social Welfare 16, (3 2022): 290–305. doi:10.1080/17496535.2022.2036789. Truth and Reconciliation Commission of Canada. The survivors speak : a report of the Truth and Reconciliation Commission

...talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. • Previo...

I am looking for a QuickBooks Desktop 2023 specialist to assist me with data entry and reconciliation tasks for entries exceeding 100 in number. SKILLS AND EXPERIENCE: - Proficiency in QuickBooks Desktop 2023 is non-negotiable. - Prior experience with large scale data entry and reconciliation tasks. - Familiarity with handling electronic records and financial institution statements is a must. TASKS: - An accurate data entry of electronic records and financial institution statements into QuickBooks. - Ensuring proper reconciliation of these entries. Please highlight your relevant experience in your proposal. Proven track record in similar tasks will put you in a privileged position. I am aiming for a smooth, error-free process and your expertise can make that ...

I need to automate the creation of tasks and subtasks in Microsoft Planner from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable ...

I'm in need of an expert in VB/VBA development to assist with my software solution, primarily dealing with a scale system for a food company. Understanding Macola software would be highly beneficial. The core focus will be on: - Error fixing in current functionalities when they occur like label printing and commimocation errors - Developing and integrating new features into the system - troubleshooting errors as there arent many but I need the person to be able to support US EST (East coast US) hours The exact errors to address are not currently available, but a strong analytical mindset will be crucial in tackling this project. The ideal candidate should be knowledgeable in VB/VBA, demonstrate solid problem-solving skills, and have experience working with Macola softw...

...of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate: The ideal candidate should be an exper...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

I am looking for an Excel expert who can set u...a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the count in the dashboard the sample file for problem solving. Ideal skills and experience: - Expertise in Excel: A deep understanding of Excel's functionality and the ability to customize it to meet specific requirements. - VBA programming: Experience with VBA programming is a plus as it will be needed to create the custom formulas and set up the automation. - Automation: Proven experience in automating tasks within Excel and making processes more efficient. - Attention to detail: It's crucial that data is handled accurately and that the formulas are correctly implemented to ...

Quick Book Reconciliation and finalization of accounts