Hi all,

I have used XML maps to capture data from RSS feeds into excel. I have saved the data for each feed in a separate sheet. Now, I have multiple sheets which have data in a table format with the same headers:

pubDate title description link

I would like to consolidate the data into a single sheet. While consolidating the data, I would like to remove rows which have duplicate entries, leaving behind a table of only unique values.

To explain what I am trying to do here - I am tracking news from various sources through RSS - once I hit refresh, the new articles will overwrite the old ones. I want to consolidate all the new articles into a master sheet - keeping only the unique values there.

Is this possible?

Thanks,
Sa'ad

(P.S.: This is my first post - I hope I have not overcomplicated my problem :))