Dynamic sort with dynamic sort criteria

Hello,

My problem is this. I need to sort a range, apply a formula to the sorted information and then sort again by the results of the new formula. After that I need to keep the top row of information as is, recalculate all the remaining rows with the same formula. The second row uses values from the first row. After the recalculation is done I need to sort the new values again and then sort them. This process repeats until all the rows are done. I am new at coding and I have pieced together some code which is close but I am having trouble updating my new sort ranges on each iteration. Here is what I have so far.

Please Login or Register  to view this content.

I highlighted the section which is not correct. It seems like that would be an easy thing to do, but like i said I'm new to this language and my vocabulary is limited.

By the way most of the code I have is copied from recorded macros or from this forum so if the code looks familiar its probably yours and thank you.

David

Hi, David,

maybe just like this:

Please Login or Register  to view this content.

Ciao,
Holger