VBA to copy validation from last cell to new cells?

[backstabbathX]

Hello everyone


I am currently utilizing a 'master' excel sheet to keep track of records that get sent to my team on a daily basis. I am connecting to this master sheet via Power Query to populate another tool to assign 'category' attributes to the records, and using Power Pivot to create reports with this information.

Inside the tool that is connected ton the original 'master' sheet I have a column added that contains a data validation list for the 'category' attributes that get assigned to each record. The problem I am running into, is when I refresh the data source, the added records are not pulling the data validation down to the new records. Here is a small screenshot;

I would like column AL (Schematic Category in the table) to carry down the validation rules from the cells above it automatically.


Can anyone point me in the right direction towards a VBA code to use here?


Thank you!