The IF statements work fine for just one sheet.

Like I mentioned, this is only a sample. The actual spreadsheet record
alot more information from 2 different sources (Sheet 1 & 2). Sheet
takes only some of the data.

I posted the actual spreadsheet last week, search down the lis
somewhere.

I moved onto this smaller sample to try and get the basic cod
required.

- Darren

--
Darren
-----------------------------------------------------------------------
DarrenG's Profile: http://www.excelforum.com/member.php...fo&userid=3652
View this thread: http://www.excelforum.com/showthread.php?threadid=56422