Kapalı

Excel 2010 Quick help needed with SMALL sort problem.

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.

Beceriler: Excel, Yazılım Mimarisi, VB.NET, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: how to sort by date in excel, how do you sort in excel but keep rows together?, advanced sorting in excel, how to sort data in excel using formula, excel filter data with drop down arrows, how do i sort in excel with multiple columns?, excel sort function, excel sorting problems, excel project help needed, getafreelancer message sql query help needed, python projects help needed, marketing help needed, excel vba programmer needed small projects, excel macro visual basic help needed urgent, case problem excel 2010, excel 2010 case problem, excel 2010 case problem kenai, excel 2010 case problem page 224, 2010 excel polar plot help, excel 2010 vba help

İşveren Hakkında:
( 777 değerlendirme ) Woburn, United States

Proje NO: #17217267

Bu iş için 40 freelancer ortalamada $20 teklif veriyor

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(640 Değerlendirme)
8.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1061 Değerlendirme)
7.5
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(289 Değerlendirme)
7.6
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(166 Değerlendirme)
6.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(171 Değerlendirme)
6.9
katilinas

Greetings, I'm ready to work on "excel 2010 quick help needed with small sort problem." project. I have 5 years experience in Visual Basic, Excel, Visual Basic for Apps. 20 USD - proposed project budget, including co Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(123 Değerlendirme)
6.4
best4best

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

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(130 Değerlendirme)
6.3
crazynightwalker

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(105 Değerlendirme)
5.9
archanaoswal

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(86 Değerlendirme)
5.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(87 Değerlendirme)
5.9
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(70 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
5.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)
5.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(68 Değerlendirme)
5.3
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(68 Değerlendirme)
5.3
sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(82 Değerlendirme)
5.2
sorinacho88

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(43 Değerlendirme)
4.9
Taisho

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

in %bids___i_period_sub_35% gün içinde18%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
4.8
JackieXu

hello. how are you? i am expert of excel and excel VBA. i did some work like this excel and excel macro project before. so i can do this project in short time. kind regard.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(35 Değerlendirme)
4.8
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)
4.7