Creating a SEC 13D filing table with web query

Originally Posted by ShosMeister

Here's a start. Take a look at the code as well as I have some comments in there.

Big question now is how you want to manage the last sheet. Could be done with formulas but would require some other things be in place first and some minor rules to follow. Advantage is it would always be updated.

Or could be via VBA but you'd have to run a macro (or click a button) whenever you wanted an updated view.

I looked into the spreadsheet. It looks great! Just a few comments/questions I have at this point:
1. On the "Query" worksheet, I don't need any of the items that are in cells A3-A74. Would it be possible to remove those items so that the item currently in A75 (Choose day to view: ) appears at the top of the sheet, in A3? ( basically I want everything in A75 and below to appear at the top)

2. I'm guessing you haven't coded the spreadsheet to rearrange the data from the Query to fill in "My Sheet1" and "My Sheet2." To your above question, having to click a button is fine for those sheets (its actually more useful for my purposes than to have it be automatically updating).

I looked through the code (which I don't really understand), but it seems to be good! This is amazing progress on this. Thanks so much.