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