The following collection reflects some of the work I have done. Whenever I have used examples from these sources I've attempted to give credits to these and other sources.
Data validation is a groovy little thing.
Amongst other things it allows you to control the data items that are available for entry into cells. This gives you a little drop-down list beside the cells to choose from. Sometimes you want to offer a list of values to a set of cells but you don't want the same value to be selected twice. This utility will list all the files that appear within a selected directory and includes all files in all sub-directories. It even lists the file dtaes and times as well as the file size.