Firstly - the original thread is at http://www.ozgrid.com/forum/showthread.php?t=87587

Now the project got a little more complicated. This is what I have been asked to have Excel perform.

-I now have 2 separate workbooks - the original file (Workbook1) where the data will be coming from and workbook 2 that needs to be updated each week - names will remain the same.

-Workbook 2 will have information added each week - the old data will need to be deleted. The only thing that needs to remain is the header in Row 1.

-From the old workbook jobs that read "No RFE" in column N - we would like the data from that Row - columns C-U copied over to workbook 2.

-Save workbook 2

I am fairly new to VBA and have been learning lots of new things, but this is something that I am having trouble with.

Thanks,
Jimbean