Excel 2010 Quick help needed with SMALL sort problem.

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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.

Excel Software Architecture VB.NET Visual Basic Visual Basic for Apps

Project ID: #17217267

About the project

35 proposals Remote project Active 5 years ago

35 freelancers are bidding on average $21 for this job

schoudhary1553

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. W More

$35 USD in 1 day
(556 Reviews)
8.5
paris2785

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 23 More

$30 USD in 0 days
(498 Reviews)
8.4
vano101

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 codi More

$18 USD in 1 day
(1450 Reviews)
7.9
periyannas

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 an More

$10 USD in 0 days
(182 Reviews)
6.9
ksriniravi

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 macro More

$15 USD in 0 days
(254 Reviews)
7.1
best4best

Hi, I have resolved the issue. Rectified the mistake in Macro. Now it is sorting the rows correctly. Regards Soni

$15 USD in 0 days
(150 Reviews)
6.4
archanaoswal

I have excellent command on MS Excel VBA and know how to work with sorting data

$25 USD in 1 day
(104 Reviews)
6.2
crazynightwalker

Hi. This problem with the Excel file you have attached is not major, I can fix it in 30 minutes or less

$15 USD in 1 day
(118 Reviews)
5.9
sorinacho88

Hello, I have already fixed it. Please open a chat with me if you like to discuss Kind regards, Sorin

$15 USD in 1 day
(74 Reviews)
5.6
renesontiongson

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 in 1 day
(73 Reviews)
5.7
abhinovpankaj

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 Applicat More

$25 USD in 1 day
(72 Reviews)
5.7
nagybatonyi

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 de More

$25 USD in 0 days
(64 Reviews)
5.7
Taisho

Hello, I have this fixed, descending sort works correctly now, I can send You the file ASAP. Best Regards

$18 USD in 0 days
(63 Reviews)
5.3
sajidkhan45

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 Tha More

$15 USD in 0 days
(63 Reviews)
5.8
Phooka18

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 in 0 days
(13 Reviews)
4.4
AnumZia

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 More

$30 USD in 0 days
(14 Reviews)
4.3
vijayvizzu7

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 in 1 day
(10 Reviews)
4.2
manishadk

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 More

$20 USD in 1 day
(20 Reviews)
4.3
lherreraz

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 fi More

$25 USD in 0 days
(15 Reviews)
3.8
dayakmlt

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 ce More

$15 USD in 1 day
(17 Reviews)
3.7