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
Bookmarks