VBA coding is needed for my .xslx cashbook ledger trial balance file

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.

Skills: Accounting, Excel, Visual Basic

See more: general ledger trial balance, develop trial balance aspnet, designing programming trial balance aspnet, generating trial balance oracle, sample trial balance contracting company, gaap trial balance, bookkeeping trial balance, conversion trial balance data till balance sheet, far horizon trial balance sheet, cja pop coding needed, lesson plan accounting trial balance, trial balance lesson plan, trial balance tata steel, steps develop trial balance report

About the Employer:
( 20 reviews ) Akurana, Sri Lanka

Project ID: #11793822

20 freelancers are bidding on average $28 for this job


Hello, I am Excel and VBA expert. Do you realy need userform? Maybe Drop Down menu for Account Title (column B on Cash Book) is better? And VBA macro autofilling others sheets. Please note that I have 100% More

$30 USD in 2 days
(47 Reviews)

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari More

$25 USD in 1 day
(32 Reviews)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$30 USD in 1 day
(26 Reviews)

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your ins More

$30 USD in 1 day
(39 Reviews)

There are spaces in the sheets, obviously, because you have not used the correct formulae. I need to check the formula or macro used. You are making unnecessary duplicate entries in the cash [login to view URL] have to treat the More

$35 USD in 1 day
(45 Reviews)

Hello There, I have done many complex work using excel formula, vba and access. You can check the below link. Project Report Automation - [login to view URL] More

$80 USD in 5 days
(3 Reviews)

Hi, i am ready for this project as i have the required skills to finish it. please share the sheet with me so i can fix it for you.

$25 USD in 0 days
(7 Reviews)

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

$12 USD in 1 day
(1 Review)

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for th More

$25 USD in 1 day
(1 Review)

Hello sir.. I am roamabdul, We had a lot of conversation on the project you posted. I had given you the sample too. I fully understood your problem and I have the ability to solve your problem. I am making my offer More

$66 USD in 4 days
(2 Reviews)

Hello, I would be glad to help you with this project. I will do my best to meet your expectations. Best regards, Jana V.

$25 USD in 1 day
(1 Review)

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.

$25 USD in 3 days
(1 Review)

I have nice experience of accounting excel. I can resolve ur issue.

$25 USD in 1 day
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$23 USD in 7 days
(0 Reviews)

My principle is sincerely promise and mastery of work and the introduction of the reasons for success

$15 USD in 1 day
(0 Reviews)

I have a lot of experience in excel, working on it for past 1 year for 10+ hours everyday. I can definitely do it even in less than a day, probably few hours. Work done would be of quality and you wouldn't get it any More

$20 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
$13 USD in 2 days
(0 Reviews)

I'm very much proficient in Excel, VBA, and Matlab. I've been doing programming for last 7 years. From your job description, I'm very much confident to solve this task within a day. I am PhD candidate at Texas Tech Uni More

$26 USD in 2 days
(0 Reviews)

Hello sir... I am ashina mohamed. I have been into the field of data entry jobs for more than five years. My works are always at 98% of accuracy. I am flexible & being a quick learner, I can easily turn things into ex More

$25 USD in 1 day
(0 Reviews)