Do you have to keep your stuf in Excel? Or is transferring it to Access
an option?
This volume of data and comparing "records"to search if they already
exist and the looking up based on productnumber or all products that
have a yellow variaty can be done far better in Access.



--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=399696