Thanks Bilbo,

I didn't look at you sample workbook in detail earlier, from other threads I thought I was not explaining my problem correctly. I like the use of the button update, it will be very helpful in other macros I use.