Sorting as per sequence

Hello there
This is the site suggested by my friend and trying for the first time.
Kindly correct me if I go wrong anywhere.

I have a list of numbers in the Project sheet which can go for
more than 5000+ .

In Sorted sheet I have the column names in row1 which is already
defined. In row2 , as per the requirement I receive I mention the range
for that particular group ( but everyday you get a different range ).

I needed if I run the command or say click of a button it program reads
the range from Project sheet and sorts it in the same Sorted sheet (shown in black).

I have attached the sheet.

Have a nice day
gdemi

Try this:-
Code to produce sorted data in specified columns in sheet "SORTED", from Data in sheet "PRODUCTS"
You will need to alter the "Select Case" in the code to cater for other columns in sheet "Sorted" that are not yet defined by Number range.

Please Login or Register  to view this content.

Regards Mick

http://www.dec.org.uk/

Thanks for the reply MickG.
I will get back on this issue because I donot know how
to make use of the code.
I will have to first study the process of using the code.
In case if I have any problem , I will get back to you on this link.

Thanks again.
gdemi

gdemi,

This is how I read your problem.
Try the attached.

Please Login or Register  to view this content.

Hello again
I checked the options provided by both MikeG and Jindon.
The actual required result was useful by the one provided by Jindon. But I also make use of the
method by MikeG which is slightly different.
Thanks for the solution.
as per the rules I need to mark solved, but to both of them.
I needed one more added option in the code only if possible , since it was not
mentioned in the question.
After it sorts and displays the data in Sorted sheet. If it can delete those numbers from the
Project sheet
Thanks again.

Change to

Please Login or Register  to view this content.