I find this site useful for my students learning VBA -
Excel Macro Mastery[
^] There are lots of worked through examples and he explains the principles very well.
If you prefer to learn from videos he also has a YouTube channel -
https://www.youtube.com/channel/UCLsnK4MPVaqiVx3DSEqbb1A[
^]
Be aware there are numerous adverts for you to buy his book and/or courses - there is no need to part with your money!
This video might be one to help you with this particular problem -
How to get the Last Row in VBA(The Right Way!) - YouTube[
^]
And this one will help you with moving the data
How to Use Arrays Instead of Ranges in Excel VBA - YouTube[
^]
Hint - because you have recorded a macro you are likely to be using Cut & Paste - don't!