nevi Wrote:
but will not blank out Details!D6 when H1 is changed from 1 to 2.


the only way you can do this, is to use VBA. If you use a formula,
then each time you change H1, all the other formulas will change too.
If you want to email me a sample of the spreadsheet, I will create a
macro for you.
I will PM you my email address

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552857