Find Jobs
Hire Freelancers

Simple vb code to remove spaces from my excel ledger system

$10-30 USD

Terminado
Publicado hace más de 7 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 11821753

Información sobre el proyecto

26 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 0 día
5,0 (260 comentarios)
6,5
6,5
26 freelancers están ofertando un promedio de $27 USD por este trabajo
Avatar del usuario
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 we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$25 USD en 1 día
4,9 (146 comentarios)
7,1
7,1
Avatar del usuario
i can do it for you quickly and exactly
$30 USD en 1 día
4,9 (125 comentarios)
7,1
7,1
Avatar del usuario
i can do very fast.
$15 USD en 1 día
4,9 (67 comentarios)
6,5
6,5
Avatar del usuario
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 design the simulation model for the business and also create the dynamic Spreadsheet for users to use. You can see more of my profile and expertise here: my project feedback in http://www.freelancer.com/users/feedback_2698784.html I have read your requirement and your attachment...it is clear that the way you use the "Sheet1!" formula is not suitable for your work...let me design this for you... I will write the VBA code this way... 1) you can daily input in the Cash Book or Weekly depends on your work process. 2) on the Cash book, you will have 1 button, of course assign VBA code, so that after finish inputting the data to the Cash Book, just push the button. 3) Then the code will check all transaction on cash book, then correctly book them to relevant sheets. 4) remove the already booked, from the Cash book... 5) Then next time you push the button, the new data goes to the last line of each ledger automatically. Of course, for this time, you also just push one click then all will be book to each ledger correctly. Hope to have chance working for you.. Kind regards, Pichart Y.
$50 USD en 1 día
4,9 (39 comentarios)
5,4
5,4
Avatar del usuario
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 requirement is to have one place to create new records with data validations and list use then have a macro that will do advance filter into the ledger cards. we can discuss further over the site chat so feel free to pm me. brgds, itay.
$35 USD en 1 día
5,0 (12 comentarios)
4,2
4,2
Avatar del usuario
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 administration and maintenance with Linux/Unix and Windows Networking.
$30 USD en 2 días
4,9 (22 comentarios)
4,3
4,3
Avatar del usuario
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 en 0 día
5,0 (7 comentarios)
3,5
3,5
Avatar del usuario
I am an expert Excel user. I can complete your job with the lowest possible budget and shortest time. Hire me!
$10 USD en 1 día
5,0 (8 comentarios)
2,6
2,6
Avatar del usuario
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 to hire me then contact me so we can discuss further details about the project. I am really looking forward to work with you.
$20 USD en 1 día
5,0 (5 comentarios)
1,6
1,6
Avatar del usuario
you can do this yourself and save your money. it isnt a big deal, just google. I can help you anyway
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 show in your project title than I am the right person for you. available 24-7. a trusted Freelancer. Regards & Thanks Piyu Jain
$23 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
timely delivery
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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. Thank you, Miguel Gonçalves
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
$50 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm an Excel & VB expert with more than 18 years of experience, besides I'm always able to meet deadlines.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SRI LANKA
Akurana, Sri Lanka
4,8
22
Forma de pago verificada
Miembro desde jul 7, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.