Find Jobs
Hire Freelancers

Data sort using VBA

$30-250 USD

已完成
已发布超过 7 年前

$30-250 USD

货到付款
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: 11690823

关于此项目

32提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (165条评论)
6.7
6.7
32威客以平均价$113 USD来参与此工作竞价
用户头像
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 在3天之内
5.0 (142条评论)
7.2
7.2
用户头像
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 在2天之内
4.9 (160条评论)
6.9
6.9
用户头像
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 在3天之内
4.8 (137条评论)
6.5
6.5
用户头像
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 在3天之内
5.0 (41条评论)
6.4
6.4
用户头像
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 在3天之内
4.9 (127条评论)
6.2
6.2
用户头像
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 在3天之内
5.0 (78条评论)
5.8
5.8
用户头像
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 在3天之内
4.9 (54条评论)
5.6
5.6
用户头像
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 在3天之内
4.9 (58条评论)
5.5
5.5
用户头像
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 在1天之内
5.0 (31条评论)
5.3
5.3
用户头像
Hello I can help you with it I'be strong VB experience Which Excel version do you have? Regards Marcos
$166 USD 在7天之内
5.0 (43条评论)
4.8
4.8
用户头像
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 在2天之内
5.0 (53条评论)
4.8
4.8
用户头像
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 在3天之内
4.5 (50条评论)
5.0
5.0
用户头像
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 在1天之内
4.9 (22条评论)
4.4
4.4
用户头像
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 在0天之内
5.0 (3条评论)
2.4
2.4
用户头像
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 在1天之内
5.0 (1条评论)
0.6
0.6
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am building many excel, word based macro as template. I will get this done Please give a chance to serve you.
$250 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (1条评论)
0.0
0.0
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Tyler, United States
5.0
2
付款方式已验证
会员自10月 1, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。