Hi,

I'm trying to create an excel file with multiple worksheets managing different attributes of the same list of names.

I want to be able to add rows within the list and have it automatically be added in all the worksheets (ie the first column has names with different attributes in the following columns) I want to create a macro that will automatically add in the new row with the name in the first column and blank in the rest of the columns to fill in accordingly for each worksheet.

I was thinking there would be a way to create a button that you click once you've added the new row on a "master list" that will create the new row in all of the other worksheets. But I only want to copy over the first column name with the rest of the columns blank.

Is this possible?

Here is an example worksheet... Test_MasterList.xlsx