AutoFill Certain Columns When a Row is created

[Mr.Steel]

Hello!

Im new to vba and trying to get a grasp on things but im still experiancing lots of problems.

Attached is a version of a Fixed asset ledger i am building for my company. In the userforms section on VBA their is a userform called AddAsset. Contained within this forms VBA under the Sub Okay_Click() is my attempt at making VBA to automatically autofill the cells from a few selected columns R, S, T, W, X, Y when the okay button is hit. (This is just my problem but the other columns are filled with other information pretaining to the specific asset)


Attached is a version of my spreadsheet. Thanks in advance for helping me out on my work! Have a wonderful day.