Sort a partial block of data of variable length

**kencoburn** · 05-15-2017, 05:27 AM

I want to sort a list of names in a table in alphabetical order - easy enough. But I want only to sort a limited block containing these names but NOT any entries below the list of names. I have used the following VBA code to try to accomplish this task and two images showing the selection of only the names and then the resulting sorted list. You will note that the line below the list of names that was not selected has also also been sorted - which is not what I want to happen. There is a header cell at B5 and the first name in the list is in cell B6.

I would be grateful for any assistance.

Please Login or Register  to view this content.

**PFDave** · 05-15-2017, 06:57 AM

Is your table a Data table? that might complicate things, might not.

A sample workbook in this instance would be required.

Thanks

**kencoburn** · 05-15-2017, 07:16 AM

The cells adjacent to the names in column C have the following formula format:

=VLOOKUP(B145,'Nov 2016'!D:Z,13,FALSE)+VLOOKUP(B145,'Dec 2016'!D:Z,13,FALSE)+VLOOKUP(B145,'Jan 2017'!D:Z,13,FALSE), etc up to 'Oct 2017'

The line that I do not want sorted has no formula in row C, only a value.

Do you want me to append a copy of the relevant worksheet and, if so, how do I go about doing that.

Thanks for responding so quickly.

**sintek** · 05-15-2017, 07:36 AM

Originally Posted by Pete_UK
To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post

**kencoburn** · 05-15-2017, 09:43 AM

I have attached a copy of the worksheet shown above. The worksheet is part of a relatively complex workbook which is controlled
by command buttons in another worksheet and underlying VBA code, in addition to the small section of VBA code above. The full workbook
size is 1.6 MB.

**kencoburn** · 05-15-2017, 10:19 AM

It occurs to me that a fuller extract of the Form vba code may help to resolve the above problem. I have had to delete repetitive code because of the limit imposed by this forum.

You will see that the code used to insert names and then sorts them alphabetically for each monthly worksheet that is named Nov 2016, Dec 2016, ....etc. is almost exactly the same as the code used for the events worksheet (e.g. Vets & Partners). I have entered a new transaction manually at the bottom of the monthly worksheets, leaving a space below the list of names, and it sorts properly (does not include the added transaction). Yet when I do the same for the event worksheets the added transaction gets sorted - which is not what I want.

Please Login or Register  to view this content.

Sort a partial block of data of variable length

LinkBack

Thread Tools

Rate This Thread

Display

Sort a partial block of data of variable length

Re: Sort a partial block of data of variable length

Re: Sort a partial block of data of variable length

Re: Sort a partial block of data of variable length

Re: Sort a partial block of data of variable length

Re: Sort a partial block of data of variable length

Thread Information

Users Browsing this Thread

Similar Threads

Sort a block of data of variable length

“Object variable or With block variable not set” error while adding data into ArrayList

[SOLVED] Trying to sort using a variable for length of spreadsheet

[SOLVED] Needs to Sort a block of Data by Title A-Z and keep rows togther.

sort variable length column for min value--number of rows is variable

Sort Ascending for variable Report length

Graph with variable data length

Bookmarks

Bookmarks

Posting Permissions