ChristineJ
09-25-2009, 06:23 PM
I have a list of statements in Column B of Sheet1. Users will enter an "a" in Column A for each statement that they want to appear on Sheet2, Column B.
Sheet1
https://web.gsc.edu/fs/cjonick/new_pa1.gif
Based on Sheet1 above, below are the results that I want to show in Sheet2.
Sheet2
https://web.gsc.edu/fs/cjonick/new_pa2.gif
I'd rather not have all the results from Sheet1 be on Sheet2 and then hide those without an "a" in Column A. I just want a list of those with in "a" in Column A on Sheet1.
Any ideas for doing this are appreciated!
Sheet1
https://web.gsc.edu/fs/cjonick/new_pa1.gif
Based on Sheet1 above, below are the results that I want to show in Sheet2.
Sheet2
https://web.gsc.edu/fs/cjonick/new_pa2.gif
I'd rather not have all the results from Sheet1 be on Sheet2 and then hide those without an "a" in Column A. I just want a list of those with in "a" in Column A on Sheet1.
Any ideas for doing this are appreciated!