Is there a way to display the contents of a cell adjacent to another cell if
that cell meets a certain criteria? Example: Cell b3 equals 2 so c3
displays on the new worksheet only if it is 2. I have a parking list 1-16
but they are not aligned on the first worksheet. But the 2nd worksheet is
outlined showing what 1-16 is and the bumper number accociated with that
number.