Simple question which nobody seems to be addressing. I'm selecting only some rows in a Table trying to sort only these rows (e.g. rows 11 thru 75 in a 200 row table), but when I hit Sort Excel always overrides my selection by selecting all the rows in the table instead. The same thing happens in VBA. I'm using Excel 2007.
Am I missing something
Thanks
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Alan, are you sure you read and understood the question, cause your robotic reply does not show that!
Perhaps if you had read and understood Alan's "robotic reply", you would realise that his request for a sample workbook, is so that he can see what you are working with, thereby avoiding guessing at answers, and wasting both your's and his time.
Besides, asking for FREE help, and then giving a response like that, when asked for additional information, is not exactly the best way to go about things here
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Again you are missing the point. If you read the question carefully you will see that this is a widely general and basic question about ANY table in Excel.
I can create 3 column by 10 row table but so can anyone or they can try it on any of their existing tables. In my opinion that would be faster than downloading, uploading files and reviewing someone else's table
@Matrex
Why are you consisting not adding a workbook?
If it is so easy to solve (in your opions) I wonder why you ask a question.
I agree with the statement below.
Responds like that, will make you will get no answers at all, since forummembers won't work on your question.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Matrex- I read it and understand it. I will offer you help when and if you supply a workbook that has your issues. We are all volunteers here with limited time. If you want help, then make it easy for us to assist and provide data when requested.
Thank you all for your interest in this
Here is the file with a sample Table. Need to sort on column B for only rows 11 thru 15 on
Note1: converting the table to range, or resizing table are not really what I'm after
Note2: solution with vba is also welcome
matrex
Last edited by matrex; 05-11-2014 at 02:52 PM.
If you change the table to a range and apply a filter, you will have some of the abilities of a table but you will be free to select the rows for Maria and sort only those rows without affecting the other rows of the whole range.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks but converting to range (as noted) is not an option
Maybe you can try this:
Convert the table first to a range
Make the sort you want
Convert back to a table.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
popipipo's solution will work.
You can't do what you want while the data is in table form due to the nature of tables.
In fact you can. One way to do it while the data is in a table form is to resize the table, but I am trying to avoid altering the tableOriginally Posted by newdoverman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks