Macro automation help

Hi guys,

I am trying to automate a task that would help me save a lot of time and hoping this community can help me out. I am trying to copy and paste the word down a column until it reach the "total line" and right after the "total line", I would like to insert a space.

Please see attached example.

Thank you so much for your assistance.

Yayay

Now that I read my post, I found it a bit confusing, what I meant to say is that I need a code to copy and paste the value from cell above to the next blank row for column A & B until it reaches the last row. Also, I need to insert a row right below the word "Total".

Thanks again for taking the time to view my post, much appreciated.

Regard,
Yayay

May I please bother you with some additional formatting change to the worksheet. I want to bold the entire row that contains "Total" and also add top and bottom border to "total line"

Thank you so much for your assistance, this has help me enormously on my everyday data sorting tasks.

Yayay

Please see attached worksheet "v2".

Thanks,
Yayay

Thank you so much, this is very helpful. I have one last question. What do I change in the code if I need to extend my border lines to an extra column. Please see attached worksheet for the extra column "publish date".

Thank you so much.
Yayay

Hi, Thank you so much for your patience with me. Attached is what the original data resembles and on "sheet 2" is what I would like the outcome to be.

This works. Again, thank you for your help.

I will now mark this thread is "solved".

Greatly appreciate your assistance.
Yayay