Hi there,
From what I understand in the brief, you are looking for an Excel function called IMPORTFEED that when provided with a RSS URL, a list of terms to return (full items by default), and the number of items to be returned (all matches if not specified or set to 0), will populate the spreadsheet with the RSS items that match the criteria.
This is a fairly simple project that can be implemented using VBA, along with XML data import and XML map, functions that were introduced in Excel 2003.
I pride myself on clean, minimal code with appropriate comments and helpful documentation, this is mostly because I am very lazy, in the sense that I prefer to do something right the first time. I'm not a fan of rework. This will make it easier for you to maintain and extend the function in-house, if you so desire.
Please provide me with your test criteria, which I will use to supplement my own.
I look forward to hearing from you soon.
Kind Regards
Shaun McDonald