The run schedule will be dynamic. As an example, one internal customer may want the report run on weekdays 2,4,6 or Monday, Wednesday, and Friday. Each day it's ran it will go back to the last time it was ran to pull data in. Today being Monday, there is no value to the left to subtract exactly, but in that case we know that the last day it was run would be the last day of the array so in that case that's 6 or Friday so I know that's 3 days or as I was saying "2,4,6" becomes "3,2,2". On Monday go back 3 days, on Wednesday, go back 2, and on Friday also go back 2 days. Again, this is just an example and schedules could vary and it might be once a week or twice a week. I figured I could use the new particular matching value from "3,2,2" array which could be called "Previous_dates_to_include" to subtract from today's date when today's weekday is in the original schedule array. There will be potentially a couple dozen different schedules so this will all be "macrotized" and I was considering potentially converting it at the same time I convert the Excel spreadsheet to macro variables. Thanks for getting back so quickly with your thoughts and additional questions!
... View more