I have a spreadsheet that has lastname in column B. The lastname can be
repeated several times in column B. In column C are comments that I want to
capture. (Sheet1)
I want to capture the comments on Sheet2. I have another worksheet (Sheet2)
that I want to capture all of the comments if lastname = Jones. So in other
words, if lastname = Jones and there are five comments in column C, then in
Sheet2, cells B2, B3, B4, B5, I want to put the comments.
Thanks in advance for any help I can get with this.
Bookmarks