Macro Command Button: Combine Save As CSV and Delete Unsed Rows Macros

I am new to macros and command buttons, so I have no idea where to even start. I have a spreadsheet that, once saved as a CSV, is used to import data.

I need to create a command button (e.g. "Save As CSV"), that will save the file as a csv and also removed any unused rows based certain cells being blank. I would like the rows to remain in my xlsm sheet (to be used again in the future by the user) but the CSV to be clean and only show the relivant data.

I have attached my spreadsheet, in the example, rows 2-10 have good data (row 1 = header)... in my CSV file only rows 1-10 should populate.

Thanks
Kara