Excel 2007 : VBA and XML use with Excel 2007 (multi-part question)

Unfortunately I don't know VBA hardly at all. If I'm pointed in the right direction I can usually piece together what I need.

Currently I'm working on a project which involves a table in Excel that has data dependant on other data. I need a way to have Excel select at random an item from Column A, randomly select another item from Column B within the data range under Column A, then all the items within that range under Columns C, and D.

\1

The second part, is there a way to have Excel send the random and gathered information to an XML format or XML file?

Thanks in advance for any advice.
-Mike

P.S. Sorry for the image starting the data on Column B. It's just an example, not the actual table as the table itself has some sensitive information in it. There are some blank cells in the actual table also.