Good article on Excel lookup validations using a table column as the value source:
http://www.myonlinetraininghub.com/excel-tables-as-source-for-data-validation-lists
Good article on Excel lookup validations using a table column as the value source:
http://www.myonlinetraininghub.com/excel-tables-as-source-for-data-validation-lists
Use this Excel function to build insert statements from Excel data:
=”insert into [table name] select max(id)+1 , ‘”&A2&”‘ from [table name]”
A great tutorial on different formatting rules:
https://www.ablebits.com/office-addins-blog/2013/10/29/excel-change-row-background-color/