Thank you Dave and Earl. I have no managed it using the transpose
function, albeit without the macro Dave (I have saved it though). Earl
the Access option wouldn't work as the spreadsheet had some functions
embedded in cells that Access could make no sense of. Brian


--
zigeuner
------------------------------------------------------------------------
zigeuner's Profile: http://www.excelforum.com/member.php...o&userid=27527
View this thread: http://www.excelforum.com/showthread...hreadid=470476