Export to CSV rows populated

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

1 and 2) Ideally it would go to the root folder where this file is create a folder "Lists" with the names "uk.csv" and "us.csv" (different tabs on the excel)
Just need it to save the file each time I click on the button.

3) Colum F will always have data.

CL1.xlsm

The problem is that using the auto filter wont eliminate the blank rows when exported.

Thanks

Hi JBeaucaire,

That works! I only have some last questions.

1) I am using some formulas now to pull the values you see in the data. So, the country, name etc are pulled from other sheets onto the applicable country ones such as USA , UK etc.
When I use this code without the formulas it works, but with the formulas I get this behavior: error.png

2)In my original file I have nearly 40 tabs (I know its crazy). 30 of them are the ones that I want the data to be pulled and they all start with the word "Scenario", as in "ScenarioUSA" , "ScenarioUK" and so on.
Is it possible to run this code only in the tabs that start with the word "scenario" in my entire workbook?

Thanks in advance,

Had to use xlPasteValuesAndNumberFormats as the date format was coming as 4144, but thanks for the hint! It helped.

2) I started with just a few tabs, hence my initial idea of clicking in a few buttons on every tab worked. But now has developed to 30 tabs and makes it time consuming to go through all and clicking the tabs to export the data. Is it possible to do a main button to use this code on all tabs that have a name that starts by "Scenario.."?

Sorry JBeaucaire, I am still getting an error message when I try to run the script "run-time error '1004' method 'saveas' of object '_workbook' failed".

When I hit the debug it shows me that the error is in this line:
ActiveWorkbook.SaveAs fPATH & fNAME & ".csv", FileFormat:=xlCSV, CreateBackup:=False

What could it be?.. Thanks

Thank you!! That worked like a charm :D