Hello,
I'm having a bit of trouble finding the most elegant way to prune some data from a spreadsheet that contains some stock price data.
Some of the data I have is incomplete and as a result, some of the rows contain the following string of data: "#N/A N/A"
What I'd like to be able to do is get a macro that looks for the last row in the spreadsheet that contains this string and delete every row where that occurs but stops at row 3
I was wondering if anyone knows if I might be able to do this. I have attached a copy of an example spreadsheet.
Many Thanks in advance for your suggestions,
Kindest Regards,
twills
Bookmarks