Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations pierreick on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by keithalewis

  1. keithalewis

    Hiding rows based on cell contents from another sheet.

    In Sheet2!A1 enter =IF(Sheet1!$A1<>0,Sheet1!A1,0). Copy and paste to appropriate range in Sheet2. Tools > Options : View, then uncheck Zero values. Keith A. Lewis High performance Excel add-ins http://xll.codeplex.com

Part and Inventory Search