VBA to sort a table for values between

[JR Montana]

Need VBA to sort a table for values in a specific range.
I'm new to VBA but I think it may provide a solution to a problem I have processing some table data. However, as you know learning a new language is challenging and takes a while.

I've tried all the excel standard formulas to do this, but it is a kind of batch processing and nothing in regular excel, formula-wise, really works for what I need. I am attaching an Excel workbook so you can see the problem I have to resolve.

The table data to process is in 9 columns.

After any negative values are removed, each Column needs to be sorted to have all the values in each column in ascending order.

I've been able to get the macro below to do that for me and in my attached sample sheet it has been run.

Please Login or Register  to view this content.

Now I need to know how to edit that macro into a new one to extract ranges of numbers to pull those values out and paste them into a new table shown below the first in my example.

The bracket groups into which I want to organize my column data are:
>=1 and <=60
>=61 and <=121
<=122 and <=182
>=183 and <=243
>=244 and <=304
>=305 and <=365
>=366

If anyone can help me I'll be grateful.

Jim

[xladept]

Hi JR,

Maybe:

Please Login or Register  to view this content.

[JR Montana]

Thank you very much. That works perfectly.

Can you clarify for me which values to change if I place this in another sheet? I think I've figured out pretty much what are row and column numbers, but I need to know what to edit if I can't place the charts at exactly the same column and row locations.

The VBA book I have sucks, and I can't find a lot of this in there to help me modify it on my own.

Thanks again for your great reply resolving my problem.

JR

[xladept]

You're welcome!

Please Login or Register  to view this content.

As long as the tables are aligned, then the red code (and the j values) is where you should edit

[JR Montana]

Thanks again. I just clicked on the "Add Reputation" and commented that you saved me hours. I really appreciate your taking the time, and being there on the forum to save some of us from ourselves. :-)

Jim

[xladept]

You're welcome and thanks for the rep!

[xladept]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.