Cancelled

Write a vb macro to improve my excel ledger system

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 to have:

1. Userform (in VB) where user will enter daily transactions to cashbook. When one finishes entering a transaction, a button should be there for clicking

This userform should also have a dropdown selection for which ledger page( sales,rent or expenses,......).

2. Through this process, updation should be done automatically in such a way that LEDGER PAGES SHOULD HAVE NO EMPTY ROWS. (this mistake could be seen in my screen shot)

3. Trial balance gets updated properly as the data flow from balances. So need not be changed

4. Plz help me with instructions as to how to add more ledger pages to the system such as dropdown etc

. i have uploaded a doc file illustrating all the SHEETS. you will write vba code for these tasks.. please go through the screen shot and communicate with me.

Skills: Accounting, Excel, Visual Basic

See more: vb macro convert word excel, excel vb macro, excel macro write txt, excel macro write text file, excel macro write multiple text files, excel macro write html file, excel macro write txt file, excel macro write xml file, excel data fill macro, excel vba repeat macro times, excel lock fields macro, microsoft excel print invoice macro, excel data generate macro, excel cut paste macro, excel data formatting macro

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

Project ID: #11815419

16 freelancers are bidding on average $29 for this job

katilinas

Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$23 USD in 1 day
(65 Reviews)
5.3
TonmoyRoy111

A proposal has not yet been provided

$80 USD in 3 days
(121 Reviews)
5.6
abhinovpankaj

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

$35 USD in 4 days
(32 Reviews)
5.0
Iwin

Hello, I have very good experience with VB/VBA programming and MS Office Application Automation, including MS Excel. I have also completed several similar projects here I have looked at the description as well More

$30 USD in 1 day
(27 Reviews)
5.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$25 USD in 1 day
(46 Reviews)
5.0
MoohHHooM

Hi, i am ready for this project, please let me know more about it. .

$25 USD in 1 day
(9 Reviews)
4.2
Topfreelancer4

Feel fee to contact me for.Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the clients.Make payment only after the work done.Thank yo More

$30 USD in 1 day
(3 Reviews)
2.6
SergeyKyiv

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

$30 USD in 1 day
(1 Review)
2.4
nevo1234

Hi, I am an Economist (BA+MA) and expert with excel. overall it look like u have a rather basic accounting in excel. in order to minimise mistakes i would suggest u to do the below option - whichdo not need VBA co More

$35 USD in 2 days
(2 Reviews)
1.3
roamabdul

Respected Sir.. I have applied before for the same job to you and I have done the sample to and showed you.. If you still need my help, please let me know, Best Regards Roamabdul

$45 USD in 3 days
(2 Reviews)
1.0
martInghia

Hello, my name is Martín Ghia from Argentine. I'm industrial engineer and I have been working using excel and VBA macros modeling for 12 years. Currently I'm working in a large food processor company and start doin More

$35 USD in 3 days
(1 Review)
1.0
Adminsuport

Hi, I am interested to your job. I am expert in web research, extracting email, data mining, Google, Bing, Yahoo, MS Office (Full), Google Docs, Google Document, Google Spreadsheet, Adwords, Analytics, Webmaster, SEO, More

$25 USD in 1 day
(0 Reviews)
0.0
ganomix

Hi! I have worked with VBA and Excel extensively while doing my Master's Thesis. To be specific, I've been working on an Excel-based investment appraisal tool that I have implemented with VBA. I can easily make the mac More

$15 USD in 1 day
(0 Reviews)
0.0
Sunboss3000

I have a bachelor degree from the National University of Rwanda, and many trainings in Project Management, Business administration, ICT,…with 13 years of experience in Data Entry services. I am a Translator consultan More

$25 USD in 1 day
(0 Reviews)
0.0
techwizards3

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 c More

$23 USD in 7 days
(0 Reviews)
0.0
ruben2001ve

build macros according to specifications

$20 USD in 1 day
(0 Reviews)
0.0
$25 USD in 2 days
(0 Reviews)
0.0
hpmixco2004

A proposal has not yet been provided

$35 USD in 1 day
(0 Reviews)
0.0
CyonSpace

Hello!, I'm a professional programmer with a lot of experience doing VBA solutions. I'm really good at developing fully automated excel databases. You can trust me, I can solve your needs and provide the easiest wa More

$15 USD in 5 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0