hey ive tried both of these methods... using the pivot table jst meant i
had the right columns and headings but for the numbers i jst got loads
of 0's in the correct boxes but not the numbers for that id. and weneva
i ty and use that code it keeps crashing! ne help?? email me at
i can show file if needs b


--
philawde
------------------------------------------------------------------------
philawde's Profile: http://www.excelforum.com/member.php...o&userid=29030
View this thread: http://www.excelforum.com/showthread...hreadid=487582