Simple vb code to remove spaces from my excel ledger system

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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 in the form a button on cashbook sheet to remove empty rows from ledger sheets so that all ledger pages start at row 8 and continue without any empty rows.

i have uploaded a doc file illustrating all the SHEETS. please go through the screen shot and communicate with me.

Accounting Excel Visual Basic

Project ID: #11821753

About the project

26 proposals Remote project Active 7 years ago

Awarded to:

watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only.

$12 USD in 0 days
(260 Reviews)
6.5

26 freelancers are bidding on average $27 for this job

rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before More

$25 USD in 1 day
(146 Reviews)
7.1
zebracaro

i can do it for you quickly and exactly

$30 USD in 1 day
(125 Reviews)
7.1
thinkitltd4

i can do very fast.

$15 USD in 1 day
(67 Reviews)
6.5
Pichart

Dear Employer, I am an excel developer with the Retail business / Supply Chain / Inventory control / Replenishment Planning and Sales Data analysis back ground. I always use Excel both excel standard and VBA coding to More

$50 USD in 1 day
(39 Reviews)
5.4
nevo1234

Dear sir, I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. What i suggest for your re More

$35 USD in 1 day
(12 Reviews)
4.2
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$30 USD in 2 days
(22 Reviews)
4.3
naseefo

Hi there! I am an expert on MS Excel. I can finish this project within 1 hour of awarding it. Looking forward to hear from you. Warm regards, Naseef Ummer

$30 USD in 0 days
(7 Reviews)
3.5
dangphap

I am an expert Excel user. I can complete your job with the lowest possible budget and shortest time. Hire me!

$10 USD in 1 day
(8 Reviews)
2.6
BilalAshraf772

Hey I have completely understood your needs. And i believe in punctuality because it plays a vital role in professional career. I can assure you that i will complete your work in the given amount of time so if you want More

$20 USD in 1 day
(5 Reviews)
1.6
Nitla

you can do this yourself and save your money. it isnt a big deal, just google. I can help you anyway

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

Hello Sir/Mam, Me And My Employees are Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. If you are looking for data entry or search work as you More

$23 USD in 1 day
(0 Reviews)
0.0
balamissy

timely delivery

$20 USD in 1 day
(0 Reviews)
0.0
fergonsil1

Hi, a VBA code to remove empty cells is very simple. I can do that for the price that I am asking. If you want the userform that you are asking in the attachment, that will be an extra expense but I can also do it. More

$10 USD in 1 day
(0 Reviews)
0.0
$50 USD in 2 days
(0 Reviews)
0.0
ziadabdelgalil

I'm an Excel & VB expert with more than 18 years of experience, besides I'm always able to meet deadlines.

$10 USD in 1 day
(0 Reviews)
0.0
vjnder7

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0