"To be a warrior is not a simple matter of wishing to be one. It is rather an endless struggle that will go on to the very last moment of our lives. Nobody is born a warrior, in exactly the same way that nobody is born an average man. We make ourselves into one or the other." --Kokoro
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.
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.
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. Â