Creat macro to display data and save edits based on value in drop-down list

I am working on creating a project management tracker in excel for a department within my office and I am wondering how I would create a macro that would allow me to save progress within a table/checklist, based upon the value selected in the drop-down list. The data in the drop-down list is pulled from another column on the same sheet and is automatically updated as new projects are added to this column.