Simple vb code to remove spaces from my excel ledger system

In Bearbeitung

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.

Fähigkeiten: Buchführung, Excel, Visual Basic

Mehr sehen: remove hidden code excel, vb code import data excel ke sqlserver, vb code excel unicode, vb code excel check duplicates column, vb code excel, vb code create data entry excel, vb code bidding processmacro excel, source code simple restaurant system vb net, free code simple quiz vb net, find record excel vb code, excel vb code save title property word files, excel vb code optimization, copy data web site table excel sheet vb code, close excel vb code, add vb code addin excel

Projekt-ID: #11821753

Vergeben an:

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 Tagen
(190 Bewertungen)
6.1

29 Freelancer bietetn im Durchschnitt $27 für diesen Job an

$100 USD in 1 Tag
(248 Bewertungen)
7.6
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 Mehr

$25 USD in 1 Tag
(93 Bewertungen)
6.2
zebracaro

i can do it for you quickly and exactly

$30 USD in 1 Tag
(77 Bewertungen)
5.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 Mehr

$50 USD in 1 Tag
(35 Bewertungen)
5.2
$30 USD in 1 Tag
(48 Bewertungen)
5.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 Tagen
(6 Bewertungen)
3.4
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 Mehr

$30 USD in 1 Tag
(3 Bewertungen)
2.6
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 Mehr

$30 USD in 2 Tagen
(9 Bewertungen)
2.5
edualzate

Finance Analyst with Master degree. Proficient with databases, excel, access, visual basic for applications and design of business and finance models. Six sigma enthusiastic. SAP FICO master data expert, SAP scripting Mehr

$30 USD in 3 Tagen
(4 Bewertungen)
1.9
$25 USD in 1 Tag
(1 Bewertung)
1.8
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 Mehr

$35 USD in 1 Tag
(2 Bewertungen)
1.3
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 Tag
(1 Bewertung)
0.4
rohitkadlag

I am a .NET developer with 2.5 years experience. Have a descent experience in creating the excel addins. Have a descent experience in microsoft excel developement.Looking at your requirement i think its completely rela Mehr

$25 USD in 1 Tag
(0 Bewertungen)
0.0
rinisWD

I understand your requirement. I am good in Excel macros (VBA) and I can remove the empty lines as per your requirement. I am planning to add a sheet before "Cashbook" sheet and there I will add a button. After enterin Mehr

$20 USD in 2 Tagen
(0 Bewertungen)
0.0
vjnder7

A proposal has not yet been provided

$20 USD in 1 Tag
(0 Bewertungen)
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 Tag
(0 Bewertungen)
0.0
ellyf

A proposal has not yet been provided

$15 USD in 1 Tag
(0 Bewertungen)
0.0
$50 USD in 2 Tagen
(0 Bewertungen)
0.0
rheenalcover

Hi I'am Rheena A. Alcover . I'm the one who made some report of the office where i work before, encoding all the information in every transactions and specially in the MS Excel.The MS Excel is needed for some data wher Mehr

$15 USD in 1 Tag
(0 Bewertungen)
0.0
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 Tag
(0 Bewertungen)
0.0