Hi,

I'm looking for some help with my problem. I want to export the data I have in the sheet through a button.

I have 6 columns from A to F.

In the column name I have the country name or Language, from row 6 to below. If the A column contain any keywords I want that entire line to be exported to a CSV file.
The idea is to have a vba button on the sheet and when clicked, it would export ALL lines from row 6 to below that contain any keywords in the column A.

If column A does not contain any keywords/blank, then ignore that line and do not export.

This is my excel file:
excel_data.png

Output should be similar to this:
output.png

Can anyone help?

Thanks