Write a vb macro to improve my excel ledger system

  • Status Geschlossen
  • Budget $10 - $30 USD
  • Anzahl der Angebote 21


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.

Erhalten Sie kostenlose Angebote für ein Projekt wie dieses
Erforderliche Fähigkeiten

Möchten Sie Geld verdienen?

  • Legen Sie Ihr Budget und Ihren Zeitraum fest
  • Stellen Sie Ihr Angebot kurz dar
  • Bekommen Sie Geld für Ihre Arbeit

Heuern Sie Freelancer an, die auch auf dieses Projekt geboten haben

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online