This will create a folder for each month 01-12.  Inside each month folder will be 30 or 31 folders for each day of the month except for Feb. which will have only 28.  This can be changed to 29 if it happens to be a leap-year.

 

 

Data coming from different spreadsheet.

B25 = local cell which you are using for the search
URL = url from separate google sheet
sheet1 = name of other sheet your pulling data from
!a1:e = range of the search
After the search
3 = which column you wish to pull the data from
false = will your results be sorted?

If you get #REF when you first try this, just click your mouse on that and it will bring up a “allow access” dialog. You need to allow access if your pulling data from another spreadsheet.

Here’s how to locally pull data from another sheet.  For example, you have a sheet1 and sheet2.

B3 = cell you want to use for search

Sheet2 = Sheet your pulling data from

!C3:E3 = range you want to pull data from

3 = which column you want data from

false = results will not be sorted.

This typically happens if the files (ie pictures) originated from a Windows host.  I’ve found it’s much easier to just remove the spaces in the files than to deal with trying to properly quote your escapes in your loops. Â