Move Row based on a cell value then merge and unmerge cells - attached sample workbook

Hi all,
I am very new to VBA and this is a bit over my head. I am creating a training plan and need to make it as easy as it can be for other users. I have attached a sample workbook.

• If someone inserts a row at the bottom of the table and in the trainer cell they type a name, the macro would automatically move the row to where the rest of the same name under trainer is. IE if they enter "Beta", then the whole row would be moved up to where the rest of the trainer BETA are
• then column B would unmerge and then merge again included the new "beta" trainer.

I hope someone can help, I found codes merging horizontal and difficulty understanding how to change to vertical.

Thank you so much in advance!

Hi, welcome to the forum.
One thing you should seriously try to avoid is MERGED cells, they llok nice on the sheet but are a P in the A when it comes to processing.
I will download your file and see if what you're explainign is clear to me, but honestly, avoid MERGED cells, I'm not the only one that's going to tell you this

Here goes nothing:
The file points to 'PTL Training Plan 2021 - Copy.xlsm' which is unreachable for us.
There are NO macro's in the file so I don't knwo what you're using.
Avoig external links in attached samples and include the macro syou use.
Try again

Well you can merge it when you create the Gantt Chart, but Okay, it can be Unmerged and Meged Again but I don't see the macro anywhere

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time.)

Try this one, if you change the table lay-out like you did with this version (it's different than the table in Example 2 ) the you will have to change the macro code too if it affects the Trainer column

You're welcome
We all learn from errors, no problem

My msitake, I had that one in mind but when the other worked forgot to test it.
Works now

Sorry to bother you again, I received some feedback and the users would prefer to have the "test" be the one that's the merged and grouped instead. When I changed the code for the tblRow to 2, it does merge it but not move it up and group it with the others. What else do I have to change this in the code to make it possible? Is it also possible to also change the trainer in alphabetical so its still in a way groups it too (unless it already does that)? I also attached example.

You forgot to change the column that is sortet, now is Trainer change it to Test but the sorting will not be nice because after Test 1 it will Test 10 and Test 2 will be somewehre below.
If you want it sorted nicely chnage Test 1 to Test 01 and Test2 to Test 02 etc up to Test 9

You’re welcome
Happy coding

Don’t worry, there’s nothing wrong with asking questions, and no, I’m not annoyed, if you don’t ask you’ll never get an answer and yes the macro is written for the worksheet with the table
I do not understand why the button needs to be copied to the sheet with the Gantt chart

Here's my approach and simplified the macros