I have an excel file .xlsx which has around 7 sheets. This has problems of empty spaces in the ledger pages.
,I have a cashbook, ledger pages, trial balance system purely done in Excel. In this, only cashbook has to be updated manually and the rest gets updated automatically with correct formula. But some ledger pages have spaces in them between entries which flow from cashbook with correct formula. I need someone to write a vba code or something similar to avoid having spaces WITHOUT making major changes to the program. i have uploaded a doc file illustrating all the SHEETS.. i want a userform at cashbook from which data will be entered to cashbook and from which auto updation happens to other ledgers and trial balance. so the userform will have a dropdown menu to select between ledger pages( sales,rent or expenses,......). you will write vba code for these tasks. and moreover, the trial balanve should remain balanced. please look at the screen shot and communicate with me.
20 freelancers are bidding on average $28 for this job
Hi, I'm interested in the job. I have rich experiences of Excel VBA programming and can complete the job well on time. Hope we can get in touch soon. Best regards
I have more than a decade experience in excel and vba and I believe that the skills and experiences I've gained will be able to help you out on your project.