Selecting a Range based in Value and Save it as .CSV

I have two macro that I would like to combine them into one

The first Macro select a range of data based on the value in column J

The second saves the entire worksheet as a csv file.

I want only to save the selected data as csv. can this be done?

Thank You

Please Login or Register  to view this content.

Please Login or Register  to view this content.

See if this is how you wanted.

Please Login or Register  to view this content.

Worked Perfectly.....Thank You!!