Oh, and yes, it's also possible to have the VBA program update Sheet2 every time Sheet1 is changed...though thinking through the implications first may be a bit more complicated.