p45cal last question on your GetValues3 code.

If i wanted to get the values from Column A from Sheet2 into Column D of Sheet1 by comparing values of Column B of Sheet1 and Sheet2 would I need to use offset somewhere in the rng2 worksheet name?

Thanks

Fra