Why does it need to be a Macro? In your OP you state
Quote:
I would like some help probably only with a macro unless there is an easy way.
|
Well there is an easy way as shownI think you are making it harder than it needs to be, the process i gave you above works and is quick. A macro will take time.
I didnt notice that you wanted to group the data with the number at the end, so the last step needs to be to sort the table by number.