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.

Δεξιότητες: Λογιστικά, Excel, Visual Basic

Δείτε περισσότερα: 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

ID Εργασίας: #11793822

20 freelancers κάνουν προσφορές με μέσο όρο $28 γι' αυτή τη δουλειά


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% Περισσότερα

$30 USD σε 2 μέρες
(47 Αξιολογήσεις)

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 Περισσότερα

$25 USD σε 1 μέρα
(32 Αξιολογήσεις)

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 Περισσότερα

$30 USD σε 1 μέρα
(39 Αξιολογήσεις)

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 Περισσότερα

$30 USD σε 1 μέρα
(26 Αξιολογήσεις)

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 book.You have to treat the Περισσότερα

$35 USD σε 1 μέρα
(45 Αξιολογήσεις)

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 σε 0 μέρες
(7 Αξιολογήσεις)

Hello There, I have done many complex work using excel formula, vba and access. You can check the below link. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15. Περισσότερα

$80 USD σε 5 μέρες
(3 Αξιολογήσεις)

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 Περισσότερα

$25 USD σε 1 μέρα
(1 Αξιολόγηση)

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 σε 1 μέρα
(1 Αξιολόγηση)

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 Περισσότερα

$66 USD σε 4 μέρες
(2 Αξιολογήσεις)

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 σε 1 μέρα
(1 Αξιολόγηση)

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 σε 3 μέρες
(1 Αξιολόγηση)

With the long span of time that I handle recording of cash receipts I know I can help you in your job offer. Please consider my application. Thank you, Ellen Dinio

$35 USD σε 1 μέρα
(0 Αξιολογήσεις)

Hi I have been working in excel almost daily as I have many projects to automate the various things and data in excel sheets. There are many organisations that works in excel and need to get there data updated. I can Περισσότερα

$30 USD σε 4 μέρες
(0 Αξιολογήσεις)

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

$15 USD σε 1 μέρα
(0 Αξιολογήσεις)

Your task seems quite simple and very doable in a very short amount of time. I have a multitude of experience with Excel and VBA and I know I will be of tremendous value to you.

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)

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 Περισσότερα

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
$13 USD σε 2 μέρες
(0 Αξιολογήσεις)

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 Περισσότερα

$23 USD σε 7 μέρες
(0 Αξιολογήσεις)

A proposal has not yet been provided

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)