First and foremost, I know nothing about Macros (setting them up, writing them, etc.), so if you respond you're basically responding to an idiot. That being said, after doing some reading, I'm fairly sure a Macro is what I'm looking for.
So here's the situation... I've set up web queries for historical data from Yahoo Finance (so that way I can run automate updates on the data set). There's two web queries to upload two sets of data - 1 for the historical prices of an index, and the other for the historical prices of the ETF following that index. The data loads great and is aligned well EXCEPT for a small detail of the ETF data. The ETF data, in addition to loading the same exact date range as the Index, also downloads the dividend payout (while the index doesn't include that), so the dates no longer match going across the row.
For the tests I'm trying to run, it's imperative that the dates for the ETF and Index data match. Which leads me to what I'm looking for - a Macro capable of deleting/excluding only the cells containing the dividend payouts of the ETF that would then shift up the cells below it.
Here's a link to the file on Google Drive should anyone like to see it.
Bookmarks