I've attached a sample doc to illustrate what I am looking to do. First, I want to delete any row where the both the Start Date and End Date are earlier that 2010 or add rows until I get to a point where the Start Date and End Date are both earlier than 2010. The values in those cells are controlled by "Initial Date" and "Interval" cells at the top.
Second, and I am not sure how to build this out in an example doc, is to place resulting data in a single continuous table. The URLs you see in the spreadsheet will be submitted to a webpage as query which will return several rows of data. That data I would like to put in a new worksheet but in a continuous table. Since the first two rows of the returned data contain heads I would need to remove those before pasting to the next available row in the table.
Hope this makes sense.