Hi!

I am currently working with two raw data files in excel, one sheet is updated weekly using a external software.

This post have some similarities to my problem: http://www.excelforum.com/excel-prog...hing-rows.html

This macro does almost exactly what I am looking for. But instead of using the active sheet and the one next to it as destination and source, is it possible to use two spesific sheets instead?

Also, instead of checking the entire sheet can we implement a range i.e. Column A to I. So that the macro only check and insert information from that range?

Please ask if there's anything that's unclear about my problem

Appreciate any help!