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.