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.
28 Freelancer bietetn im Durchschnitt $26 für diesen Job an
Hi there! I am an expert on MS Excel. I can finish this project within 1 hour of awarding it. Looking forward to hear from you. Warm regards, Naseef Ummer