Write a vb macro to improve my excel ledger system

Budget $10 - $30 USD
Bids 21
Average Bid $29
Status Closed

I have an excel file .xlsx which has around 7 sheets handling ledger handling.

Cashbook ,Sales,Purchase,Expenses,Rent,Capital,Trial balance

In this, cashbook is updated manually with user entering data to respective cells. As a result, other sheets get updated automatically with each ledger page pulling the data from cash book using “sheet!” mechanism. Because of this, some ledger pages have spaces in them between entries.. I need someone to write a vba code to have:

1. Userform (in VB) where user will enter daily transactions to cashbook. When one finishes entering a transaction, a button should be there for clicking

This userform should also have a dropdown selection for which ledger page( sales,rent or expenses,......).

2. Through this process, updation should be done automatically in such a way that LEDGER PAGES SHOULD HAVE NO EMPTY ROWS. (this mistake could be seen in my screen shot)

3. Trial balance gets updated properly as the data flow from balances. So need not be changed

4. Plz help me with instructions as to how to add more ledger pages to the system such as dropdown etc

. i have uploaded a doc file illustrating all the SHEETS. you will write vba code for these tasks.. please go through the screen shot and communicate with me.

Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • nimroen Profile Picture


    Ekaterinburg,  Russian Federation

  • Iwin Profile Picture


    Ilorin,  Nigeria

    Expert VB/VBA, VB.NET, C# and Office Application Automation developer. Proficiency in Statistics, Data Acquisition, Analysis and Presention

  • MoohHHooM Profile Picture


    Dubai,  United Arab Emirates

    Programming Languages : ✪ VB .NET ✪ VB6 ✪ VBA ✪ ASP .NET ✪ HTML ✪ JavaScript ✪ CSS ✪ MYSQL Skills : ✪ Web Scraping ✪ Data Processing ✪ Data Mining ✪ EXCEL (Scripts, Pivot tables, Reports...) i am excellent in Microsoft office tools (MACROS) and have a scripting experience with many other programming languages. Skype : MooHHHooM

  • SergeyKyiv Profile Picture


    Kiev,  Ukraine

    25+ years experience in programming: Assembler, Pascal, SQL, VBA, Ruby, bash, HTML5/CSS3, JS. User friendly, easy in use and time saving solutions: - databases: developing and supporting (MS Access, Excel based, MySQL) - automation (shell scripts, daemons) - data syncing, encryption, backuping Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later.

  • ganomix Profile Picture



    A 26-year-old Finnish guy with a Bachelor's degree in Industrial Engineering and Management. Currently finishing up my Master's Thesis about using VBA for an investment appraisal tool. Excellent English skills.

  • Sunboss3000 Profile Picture


    Kigali,  Rwanda

    I have a bachelor degree from the National University of Rwanda, and many trainings in Project Management, Business administration, ICT,…with 13 years of experience in Data Entry services. I am a Translator consultant and Data Entry Specialist with main activities in Project design, Agricultural engineering, Horticulture, Agribusiness, Religions, Sciences, social sciences, Business Plan and Strategic Plan, Impact Assessment of projects/Programs, ICT,… I have done many translations and data Entry services where I work closely with Public, Private, international institutions, Banks and other institutions (World Bank, UN/FAO, MINAGRI, PSF, Churches, NGOs, DAY TRANSLATIONS, Translatorscafe.com, TRAVOD, USADF/USAID,...) I have also a high knowledge in ICT: M. Word, M. Excel, M.Access, M. Power Point, M. Publisher, MSTATC, SPSS for Windows, Business in Box, Epi-data, Internet skills, accounting software (Sage 50 accounts, Tally, ...). My speed level is 40 words per minute (40 WPM).

  • nevo1234 Profile Picture


    haifa,  Israel

    I am an economist (BA+MBA) by profession and have got more than twenty years of work experience. I can do almost all jobs related to business, accounting and finance. My area of expertise are: 1. Financial Analysis 2. Report Writing 3. Assignments related to accounting, finance, management and auditing 4. Academic Writing 5. Excel expert – Model making, reports, forms, data base designee, macros, problem solving etc. 6. Project and Industry evaluation 7. Preparation of Financial Statements 8. Pricing and Valuations 9. Cost benefits analysis and ROE calculations. My priority is to provide the best services to my clients at a reasonable price, so that to work for a longer term with the client. I do my work with professional attitude.

  • martInghia Profile Picture


    Rosario,  Argentina

    I am Industrial Engineer graduated in 2005 with a certification as Project Manager Professional in September 2015. I have been working during the last 12+ years in industrial management in leading companies of Argentina, Mexico, Colombia and Brazil. This experience has enriched my skills as a professional in terms of multidisciplinary teamwork and effective coordination of teams of different cultures. In recent years I have worked in areas such as logistics and supply, quality assurance, continuous improvement of products and processes, strategic planning, among others. I specialize in providing Excel based solutions, including template design for reporting, interactive dashboards, business and financial modeling, application development, VBA programming, and data analysis. Additionally, I made models in Arena Simulator and I have good command of English and Portuguese. I am looking for a long term association based on the "Good faith and mutual trust" principle.

  • ruben2001ve Profile Picture



    I have developed in Visual Basic applications for over 10 years and managed and created schemes ORACLE database, including stored procedures and functions for eight years, while I've ridden and managed Linux servers with Xen virtual machines.

  • TonmoyRoy111 Profile Picture


    Mumbai,  India

    I am a graduate in B.E Electrical. I have worked in a reputed Private Power Company. Hardworking and Punctuality is my success MANTRA. My strong areas of work include: > Excel Macro > Web Scrapping > Data Analysis > Interactive Dashboards > Creating attractive Userforms > Pivot Charts, Gantt Chart, Gauge Chart > PowerPoint Presentation