Hello Don,

Thank you for the help!
The macro runs smoothly, without any errors.
However, I have another question.
How would you capture data in column I?
You see, my contracts are in column E. My logic was that if I did
Vlookup Function, i could then set the result as the active cell.
Furthermore, I thought that I could set the range to be the active cel
plus 24 rows down. I could then copy this data to the desired sheet.
Unfortunately, I am not quite there. Therefore, I am thankful i
advance for any suggestions that are provided... Thankyo

--
oakma
-----------------------------------------------------------------------
oakman's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=31436