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

If a xlsx or xlsm file is saved in the csv format only one tab is saved (the current or selected one). The csv file will only contain those rows with values, while the original file will remain the same. Of course, to look at the original file, you will have to open it again.

In order for the spreadsheet to function correctly, the formulas are copied through row 1091, so the blank rows are not really empty as they have #N/A due to the formula... I have those cells conditional formatted to be white if the cell has an error, so the users are confused.

For example, the user populates 91 rows with data, I want them to be able to click a single button that will create a CSV file AND delete the remaining 1000 rows. Otherwise the import with have errors and not be excepted.

Thanks