I have an array b8:k500 (excluding headings on B7:k7). I am trying to get VBA to sort it depending on what the user nominates (from dropdowns to validate entry) in cells j2:j4, based on j2 condition firest, then j3 and then j4. Obviously the dropdowns are represented in the column headings. Please can someone point me to where I might find an answer - battled all afternoon with no result.
Last edited by BRISBANEBOB; 01-23-2014 at 11:39 PM.
Perhaps to take a look to advanced filter option.
Also keep in mind that.
Be sure that best way to describe your problem is to upload a sample workbook.
Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
G'day mate,
Could you post a simplified sample of what you are trying to do?
Alternatively, this youtube video proposes a dynamic solution using formulas. I am not sure this is what you need but it might be useful.
http://www.youtube.com/watch?v=7oPaxWdx1xQ
-Phil
Sample attached
Hi BRISBANEBOB,
maybe so
Please Login or Register to view this content.
HI Nilem
Perfect! I was miles off track the way I was trying to do it. Thanks
HI Nilem
Once question if I may? Where do you specify the sort range or maybe that should be how do you specify the sort range? That is where I was going wrong.
Range("B7:K7").CurrentRegion is the range to sort
x = Range("J2:J4").Value is an array of numbers of columns that are sorted.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks