Find Jobs
Hire Freelancers

Data sort using VBA

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
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 ....
Project ID: 11690823

About the project

32 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (165 reviews)
6.7
6.7
32 freelancers are bidding on average $113 USD for this job
User Avatar
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 in 3 days
5.0 (142 reviews)
7.2
7.2
User Avatar
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 in 2 days
4.9 (160 reviews)
6.9
6.9
User Avatar
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 in 3 days
4.8 (137 reviews)
6.5
6.5
User Avatar
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 in 3 days
5.0 (41 reviews)
6.4
6.4
User Avatar
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 in 3 days
4.9 (127 reviews)
6.2
6.2
User Avatar
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 in 3 days
5.0 (78 reviews)
5.8
5.8
User Avatar
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 in 3 days
4.9 (54 reviews)
5.6
5.6
User Avatar
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 in 3 days
4.9 (58 reviews)
5.5
5.5
User Avatar
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 in 1 day
5.0 (31 reviews)
5.3
5.3
User Avatar
Hello I can help you with it I'be strong VB experience Which Excel version do you have? Regards Marcos
$166 USD in 7 days
5.0 (43 reviews)
4.8
4.8
User Avatar
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 in 2 days
5.0 (53 reviews)
4.8
4.8
User Avatar
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 in 3 days
4.5 (50 reviews)
5.0
5.0
User Avatar
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 in 1 day
4.9 (22 reviews)
4.4
4.4
User Avatar
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 in 0 day
5.0 (3 reviews)
2.4
2.4
User Avatar
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 in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am building many excel, word based macro as template. I will get this done Please give a chance to serve you.
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tyler, United States
5.0
2
Payment method verified
Member since Oct 1, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.