I have several rental properties. I get Guest Surveys, and list the name of a
house in column A, and the comment on the house in Column C. On a seperate
worksheet, I want to type in the name of a house in, lets say, A1, and
generate a list of comments from the first sheet that correspond to that
house name. Any help?