Sort table based on criteria typed in the sheet

[brunces]

Hey, guys. What's up?

I'd like to know if it's possible to sort some data based on criteria randomly typed in cells.

For example, I have a table with 5 columns. Above each column, I'll put the criteria for the sorting, typing numbers (for the order of the columns) and A or D (for Ascending or Descending).

I've attached a file (with macro) for a better understanding. I hope you can help me with that.

--- EDITED ---

Actually, I just managed to get it working with my poor coding (new file attached). The problem is... For this attached example file, I created a table with 5 columns only; however my "real sheet" has 68 columns. I could duplicate the code 68 times, one for each column, but I am pretty sure there must be a more intelligent way to do it. So, please, could you help me create a smoother code? I would really appreciate it.

Thanks in advance, guys. Cheers.

brunces

[karedog]

Maybe :

Please Login or Register  to view this content.

That's all folks.

[brunces]

Fantastic, karedog!

I knew someone would come up with an intelligent "for/next" code. I need to learn how to use that.

Thank you very much for your attention.

brunces

[karedog]

You are welcome brunces. Thanks for marking the thread as solved.


Regards