Try revisited code, this is just slightly tested,
so let me knof how it will do the work
Works fantastic! The only minor issue i see is that is places the numbers in decending order, largest to smallest. If that could be fixed in the routine it will be perfect, if not no biggie we can do it via excel.
Thanks a ton for all your effort!!!
Again show me file or picture coz I could not understand this good enough
Do you want to sort all the data by row or by column?
The way you have it going horizontal across the screen is perfect (by rows). The example excel I sent you shows the largest to lowest numbers left to right. We discovered this morning that we need to list the smallest number first ascending to the largest. Smallest far left, largest far right. Opposite of what I showed in my example. Just need to reverse the order of placement in excel.
I do apologize for any confusion I am causing.
Well I added sort by row in there
see how it works
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register