Find Jobs
Hire Freelancers

Data sort using VBA

$30-250 USD

Terminado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
I import excel files from the computer to put them in one excel final sheet. I have done this already . But now on the final sheet I have a lot of data that might go to row (200-500). So what I need to do is : when the data reaches row 30 for example I want to move the rest of the data to the right and so on until the whole data is sorted horizontally not vertically . Means the maximum row I want the data to be on is row 30 then shift to the upper right Column and reach row 30 again then upper right column and so on ....
ID del proyecto: 11690823

Información sobre el proyecto

32 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
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed within a day. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$50 USD en 1 día
5,0 (165 comentarios)
6,7
6,7
32 freelancers están ofertando un promedio de $113 USD por este trabajo
Avatar del usuario
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
$155 USD en 3 días
5,0 (142 comentarios)
7,2
7,2
Avatar del usuario
Hi: Please share the sample data. This will provide more clarity. Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me discuss your requirements in detail.
$80 USD en 2 días
4,9 (160 comentarios)
6,9
6,9
Avatar del usuario
I have reasonable experience in IBM SPSS and R Programming Language,with specialization in examining user data/big data and formulating statistical analysis and business strategies. Dataentry; Database; Data processing; Scraping; Datawarehouse management; Monitoring protocols; Management of corporate information databases; Market analysis; Record linkage; PDF to Excel; PDF to Word; VBA; Acces; Macro; Statistical databases integration, Trasform PDF data to csv, Excel, stata, spss format.
$155 USD en 3 días
4,8 (137 comentarios)
6,5
6,5
Avatar del usuario
Hello Sir, Could you please send me a sample file to review and I should be able to help you on this. This is just an initial bid but I am sure it should be a pretty simple job to do. Thx Aanvik
$35 USD en 3 días
5,0 (41 comentarios)
6,4
6,4
Avatar del usuario
Hi, I have read the project and understand your requirement. I did many work like this with my financial and excel competency. I am a highly trained on Excel and VB Macros. I did any project regarding automated yahoo finance/forex stock update dashboard . I did many project related to KPI template using Excel and so on. I only take work for 5***** review. I will continue the work until you fully satisfied. I take your work for my own responsibility and this is not my automated proposal. Kind regards, Fatima
$205 USD en 3 días
4,9 (127 comentarios)
6,2
6,2
Avatar del usuario
Hello, I am Excel and VBA expert. I can complete this project. Can I see the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$55 USD en 3 días
5,0 (78 comentarios)
5,8
5,8
Avatar del usuario
Hi, I can conclude it 100 ready to use and you will be satisfied because I am strong skilled in tis area. Please read my profile and comments from my clients as a reference. Contact to have a chat when you like.
$50 USD en 3 días
4,9 (54 comentarios)
5,6
5,6
Avatar del usuario
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 various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$100 USD en 3 días
4,9 (58 comentarios)
5,5
5,5
Avatar del usuario
Dear the client, it's a simple task. I don't know why other guys bid so high prices. it's a rip-off. Just create small code to allow you to divide your data automatically I'm an expert in VBA programming and excel models, My sample of works will be provided upon your request Contact me.
$45 USD en 1 día
5,0 (31 comentarios)
5,3
5,3
Avatar del usuario
Hello I can help you with it I'be strong VB experience Which Excel version do you have? Regards Marcos
$166 USD en 7 días
5,0 (43 comentarios)
4,8
4,8
Avatar del usuario
Greetings, I can complete this task using VBA Excel arrays. No copy and paste methods, because they are slow for big data / multiple workbooks. I can reliably determine last row or column with data. Regards
$46 USD en 2 días
5,0 (53 comentarios)
4,8
4,8
Avatar del usuario
I have created many macros in Excel. However, I must admit that I have not understood your projects. From your description, I wondering why you cannot just insert a column and continue entering data.
$55 USD en 3 días
4,5 (50 comentarios)
5,0
5,0
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.
$111 USD en 1 día
4,9 (22 comentarios)
4,4
4,4
Avatar del usuario
hello there, I will introduce myself, I´m a civil/informatic engineer, working as a freelancer for quite a long time, my professional formation allows me to resolve any kind of mathematical and programing problem. this project can be easyly programmed in VBA in order to follow the ordering rules you have deffined, may take maybe 50 lines of program. I have worked mostly all my carreer with MS excel and VBA, so this task won´t be a problem at all for me, I can guarantee you great results, in the shortest time, with very reasonable budget. Let me know
$100 USD en 0 día
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
I have full control on Microsoft office (Excel, PowerPoint, Word). I can do your work as you desire. you Can give me a work which you want. A data entry or some else. Work will be done nicely.
$77 USD en 1 día
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
As far as I understood your problem, you want to copy or import Excel files into a final file and limit the vertical height up until 30 rows. Would a certaiin header needs to be repeated everytime or is this not a requirement. I'm curious though, why you would need such a functionality. Is this for printing purposes or anything like that, because this could be solved way more easily. Anyhow, Excel (and VBA) is one of the main tools that I use everyday, so I think I will be able to quickly solve this for you.
$55 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am building many excel, word based macro as template. I will get this done Please give a chance to serve you.
$250 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Greetings, I found your job proposal and I would love to assist you with your macros. I have more than 6 years of experience designing macros and I can deliver the macro that you need within a day. Please note that my fee includes any revisions you may like and also includes support after delivery. I will be glad to answer any questions you may have! I hope we can work together and I look forward to hearing from you. Warm regards, Fernando Robles
$77 USD en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
Hello, I would like to help you with the project. I am skilled in VBA and working with Excel, so I could do this job in no time. In case you choose me, I have two questions in advance: 1. How do you import the Excel files in the final sheet (e.g. with a macro/VBA, manually)? 2. Which version of Microsoft Excel / Microsoft Office do you use (2003/2007/2010/2013)? I'm looking forward to hearing from you. Sincerely cheapandeasy
$55 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, All I need are Your final file and the sample of source import file. It would be grate to have 5-10 sample rows with dummy data in the files just to understand what is happening. Regards
$49 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Tyler, United States
5,0
2
Forma de pago verificada
Miembro desde oct 1, 2016

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.