Category Archives: Excel

Excel Lookup Lists with Tables

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

Advertisements

Build SQL from Excel sheet

Use this Excel function to build insert statements from Excel data:

=”insert into [table name] select max(id)+1 , ‘”&A2&”‘ from [table name]”


Excel row formatting rules

A great tutorial on different formatting rules:
https://www.ablebits.com/office-addins-blog/2013/10/29/excel-change-row-background-color/