Simple vb code to remove spaces from my excel ledger system

This project was successfully completed by watersev for $12 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
Project Description

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 in the form a button on cashbook sheet to remove empty rows from ledger sheets so that all ledger pages start at row 8 and continue without any empty rows.

i have uploaded a doc file illustrating all the SHEETS. please go through the screen shot and communicate with me.

Completed by:
Skills Required

Looking to make some money?

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

Hire Freelancers who also bid on this project

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