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.
23 freelancers are bidding on average $28 for this job
Hello, I am audit manager and I can do this for you using visual basic macros. Feel free to contact with me and ask any questions you have before awarding me or someone
Have been working on VBA projects since last 4 years. Hands On exp. in excel VBA. Would love to take this opportunity. Most of the projects completed in Excel VbA only.
Hello. May I look at the actual Excel file. The task may be done with VBA or, may be without VBA, if you allow to use additional "technical" columns. Best regards, Alexander.
Hi I have gone through the requirements. Yes, it is doable. I have 6+ years of experience in writing excel VBA macros. I should be able to help you in automation more than what you expect.
Hello, I am an excel master. I can rearrange the formulas for the space issues of ledger and create the drop-down menu of excel form. Hope to work with you.