Quote Originally Posted by FDibbins View Post
Change the range references to include the new sheet name. The formula is designed to allow you yo copy it down and across, it will pick up the other columns automatically
yes this works ..thanks a lot Ford!