I have a worksheet with several columns of data.
I have a macro that sorts the data by a field name (Cost).
It works very well.
However, sometimes I need to sort the same sheet by a different field name, like Date Orderd.
Instead of having 2 or 3 different Macros, is there a way to modify my current Macro and have it ask me what field name to sort the worksheet by?
A co-worker said he thought it could be done with an Input Box.
I have a macro that sorts the data by a field name (Cost).
It works very well.
However, sometimes I need to sort the same sheet by a different field name, like Date Orderd.
Instead of having 2 or 3 different Macros, is there a way to modify my current Macro and have it ask me what field name to sort the worksheet by?
A co-worker said he thought it could be done with an Input Box.