Opening CSV File in Excel, Offering a DropDown, and Automatically Resave CSV with Change

Hello,

I am trying to create a status editor for a work project for sales leads. I have a file located in C:/Project/Leads.csv. This worksheet has customer information through Column O (the status column). I want each customer line to have a dropdown box in Column O with 5 statuses:

"0 - Not Interested"
"1 - Email"
"2 - Phone"
"3 - Quote"
"4 - Sold"

Ideally, when a dropdown on a line is changed, the macro would automatically save Leads.csv.

The customer list changes every week, so hopefully I can just refresh the leads.csv file and all the new information would appear for the next week (versus having to just build a whole new file each time).

Thanks in advance.

A CSV file is a text file, not a native Excel file (compare the appearance of a CSV and XLSX file by opening both in Notepad). So there is no way to save the CSV with an inserted drop-down list.

Artik