Sorry for the delay, I got pulled to another project for a bit. OK there are
three factors first is month. then name, then comments. I have a sheet that
autopopulates everything based on the first two. The problem is getting the
comments to pull over to the sheet. I can get it to do one but I need it to
find all of the comments that match the month and name. All comments are
located in the same column.

"Gord Dibben" wrote:

Debra hangs around these news group quite a bit.

I think if you wait around, she may drop in on this thread.

What specific changes to her code would you require?

From where would you "dump the info"?


Gord


On Fri, 1 Dec 2006 14:44:01 -0800, Scott@CW
wrote:

Is there a way to contact Debra Dalgleishi, I looked at the web site and they
are close to what I need but not quite there. I have all the sheets already
made and need the info dumped to them. Thank you for the help.

"Gord Dibben" wrote:

Scott

To place the contents of a comment into a cell see Debra Dalgleish's site for
info.

http://www.contextures.com/xlcomment...l#CopyAdjacent

May do what you want.


Gord Dibben MS Excel MVP

On Fri, 1 Dec 2006 10:26:01 -0800, Scott@CW
wrote:

I have a survey that consists of 17 questions. The first question is
formatted to provide me with the name that goes with the survey. The last
question is an open for comments. The data is pulled into excel for
reporting. I have formulas set up to pull everything to one worksheet per
name. I cannot figure out how to pull the comments. There are 90 plus name
and upto 17 surveys per name. Help.