Find Jobs
Hire Freelancers

Data sort using VBA

$30-250 USD

Ukończony
Opublikowano ponad 7 lat temu

$30-250 USD

Płatne przy odbiorze
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 ....
Identyfikator projektu: 11690823

Informację o projekcie

32 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (165 opinii)
6,7
6,7
32 freelancerzy składają oferty o średniej wysokości $113 USD dla tej pracy
Awatar Użytkownika
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 w 3 dni
5,0 (142 opinii)
7,2
7,2
Awatar Użytkownika
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 w 2 dni
4,9 (160 opinii)
6,9
6,9
Awatar Użytkownika
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 w 3 dni
4,8 (137 opinii)
6,5
6,5
Awatar Użytkownika
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 w 3 dni
5,0 (41 opinii)
6,4
6,4
Awatar Użytkownika
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 w 3 dni
4,9 (127 opinii)
6,2
6,2
Awatar Użytkownika
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 w 3 dni
5,0 (78 opinii)
5,8
5,8
Awatar Użytkownika
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 w 3 dni
4,9 (54 opinii)
5,6
5,6
Awatar Użytkownika
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 w 3 dni
4,9 (58 opinii)
5,5
5,5
Awatar Użytkownika
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 w 1 dzień
5,0 (31 opinii)
5,3
5,3
Awatar Użytkownika
Hello I can help you with it I'be strong VB experience Which Excel version do you have? Regards Marcos
$166 USD w 7 dni
5,0 (43 opinii)
4,8
4,8
Awatar Użytkownika
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 w 2 dni
5,0 (53 opinii)
4,8
4,8
Awatar Użytkownika
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 w 3 dni
4,5 (50 opinii)
5,0
5,0
Awatar Użytkownika
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 w 1 dzień
4,9 (22 opinii)
4,4
4,4
Awatar Użytkownika
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 w 0 dzień
5,0 (3 opinii)
2,4
2,4
Awatar Użytkownika
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 w 1 dzień
5,0 (1 opinia)
0,6
0,6
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am building many excel, word based macro as template. I will get this done Please give a chance to serve you.
$250 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (1 opinia)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Tyler, United States
5,0
2
Zweryfikowana metoda płatności
Członek od paź 1, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.