random answers generated from a list

Hi

Using excel 2003

I have a list
its 100 rows long and about 8 rows wide its numbered and formatted so differnt entries are different colours

i want to be able to either press a button or press F9 and a random row (all 8 cell from the row of the list )is selected and appears into the cell i want at the top.

i have the random bit working and i almost solved it by doing the lookup function but only one cell from the row ( will display) if i tell it do more i get error.
Also the colour formatting dosnt travel to the new cell its just normal unformatted.

please help me..i just cant seem to work it out....

also im a noob with excel .im keen but dont know much