Find Jobs
Hire Freelancers

Excel 2010 Quick help needed with SMALL sort problem.

$10-30 USD

Zamknięte
Opublikowano prawie 6 lat temu

$10-30 USD

Płatne przy odbiorze
The enclosed Excel worksheet has one small problem. Two almost-identical sort buttons, one for Ascending Row 2, and one for Descending Row 2, have what looks like the same exact VB code (except for the commands for ascending and descending). Yet the Descending is not sorting correctly. Why? Note: when I had just 4 or 5 Row 2 cells with values in it, it seemed to be working OK.
Identyfikator projektu: 17217267

Informację o projekcie

35 ofert
Zdalny projekt
Aktywny 6 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
35 freelancerzy składają oferty o średniej wysokości $21 USD dla tej pracy
Awatar Użytkownika
Hello, I can help with you in your project Excel 2010 Quick help needed with SMALL sort problem. I have more than 5 years of experience in Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$35 USD w 1 dzień
4,9 (556 opinii)
8,5
8,5
Awatar Użytkownika
Hi, there. My name's Paris Pallas and I'm an experienced and skilled Excel developer. You're welcome to visit my portfolio where you'll get an idea of my professionalism and work quality. I've completed more than 230 projects over the last 5 years and this makes me rather confident that I can assist in completing successfully yours as well. I elaborated the bug. There was a programming error inside the code. I can deliver immediately, once you award me. I won't ask for any payment in front. I'll let you test the file thoroughly before I claim my milestone. I'm looking forward to hearing from you soon. Paris
$30 USD w 0 dzień
5,0 (498 opinii)
8,4
8,4
Awatar Użytkownika
Hello I have installed Excel 2010 on one of my virtual machines, I am going to reproduce this bug on my machine and maybe I will have ideas how to fix. Meantime, I am able to write sorting algorithm with pure VBA coding, if needed
$18 USD w 1 dzień
4,9 (1450 opinii)
7,9
7,9
Awatar Użytkownika
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I have checked the issue. you could award and setup milestone, I will fix and deliver it within 30 minutes. Willing to take up your project. Thank you, Regards.
$10 USD w 0 dzień
5,0 (182 opinii)
6,9
6,9
Awatar Użytkownika
Greetings! I have reviewed the code and now understand what is happening. The ascending / descending range is dependent on row 3 data. There is data only up to Col I in Row 3. Both the ascending and descending macros are designed to sort only up to Col I. If you would like that to be changed so that the entire data in Row 2 is considered for sorting, I can come up with a quick fix. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. I come across such situations often. Have a Great Weekend! Srinivasan Krishnamoorthi
$15 USD w 0 dzień
5,0 (254 opinii)
7,1
7,1
Awatar Użytkownika
Hi, I have resolved the issue. Rectified the mistake in Macro. Now it is sorting the rows correctly. Regards Soni
$15 USD w 0 dzień
5,0 (150 opinii)
6,4
6,4
Awatar Użytkownika
I have excellent command on MS Excel VBA and know how to work with sorting data
$25 USD w 1 dzień
4,9 (104 opinii)
6,2
6,2
Awatar Użytkownika
Hi. This problem with the Excel file you have attached is not major, I can fix it in 30 minutes or less
$15 USD w 1 dzień
4,9 (118 opinii)
5,9
5,9
Awatar Użytkownika
Hello, I have already fixed it. Please open a chat with me if you like to discuss Kind regards, Sorin
$15 USD w 1 dzień
5,0 (74 opinii)
5,6
5,6
Awatar Użytkownika
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$25 USD w 1 dzień
4,9 (73 opinii)
5,7
5,7
Awatar Użytkownika
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. 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 VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts 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
$25 USD w 1 dzień
4,9 (72 opinii)
5,7
5,7
Awatar Użytkownika
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. Pretty simple! I have a solution ready for you. Regards
$25 USD w 0 dzień
4,9 (64 opinii)
5,7
5,7
Awatar Użytkownika
Hello, I have this fixed, descending sort works correctly now, I can send You the file ASAP. Best Regards
$18 USD w 0 dzień
5,0 (63 opinii)
5,3
5,3
Awatar Użytkownika
Hey, I am an excel VBA expert. I went through the file and have a good idea of whats wrong with it. Please go through my profile and reviews so that you can be confident about me Hope to chat with you soon Thanks Sajid Khan
$15 USD w 0 dzień
4,2 (63 opinii)
5,8
5,8
Awatar Użytkownika
BUGFIXED THE PROBLEM, CAN SEND YOU THE WORKING FILE IMMEDIATLY Hello, im sure that i can help you. i would be happy to do this work for you. (please have a look to my portfolio) best regards, Michael
$15 USD w 0 dzień
5,0 (13 opinii)
4,4
4,4
Awatar Użytkownika
HI there! I have a large experience in Excel, MACROS, and VBA I have all tools and tricks, I assure you, you will be more than satisfied with our work Can you please share more description and file? We are ready to provide a free sample For a quick sample click the links below https://www.freelancer.com/projects/excel/Excel-Spreadsheet-Formula-Work/ https://www.freelancer.com/projects/excel/AXIS-CHART-AXIS-CHART-HISTOGRAM/ https://www.freelancer.com/projects/excel/would-like-hire-Excel-word/ https://www.freelancer.com/projects/excel/Quick-vowel-sorter-spreadsheet-macro/ Awaiting for your response Thanks!
$30 USD w 0 dzień
4,9 (14 opinii)
4,3
4,3
Awatar Użytkownika
I checked the code, seems that it captures the range wrongly. I can fix it for you. I have years of experience in Advance Excel, VBA, MAcros and other office integration development
$15 USD w 1 dzień
5,0 (10 opinii)
4,2
4,2
Awatar Użytkownika
Hi, I have checked sorting code and resolved the issue. Descending function is also working now. I can provide you solution. Please select me as service provider or let me know if we can chat through freelancer site. Thanks, manishadk
$20 USD w 1 dzień
4,8 (20 opinii)
4,3
4,3
Awatar Użytkownika
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB. I am already seeing the file and analyzing the Code, I know that I will fix this very fast. The most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$25 USD w 0 dzień
5,0 (15 opinii)
3,8
3,8
Awatar Użytkownika
Presently row is sorting up or down only till column I and not considering entire active cells or row 2. u want entire row to sort based on active cells in that row? Presently macro sorting row 2 data based active cells in row 3. In your file, C3:D3 is having data(either 1 or 0) so accordingly sorting till that range
$15 USD w 1 dzień
5,0 (17 opinii)
3,7
3,7

O kliencie

Flaga UNITED STATES
Woburn, United States
5,0
803
Zweryfikowana metoda płatności
Członek od sty 19, 2004

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.