On Feb 5, 7:35 pm, Gord Dibben <gorddibbATshawDOTca wrote:
There are no spaces and please don't post the actual address.

I don't need the spam-bots picking it up.

Gord

On Thu, 5 Feb 2009 01:02:56 -0800 (PST), "Michael.Tarnowski"
wrote:

On Feb 5, 12:07 am, Gord Dibben <gorddibbATshawDOTca wrote:
My posted email is gordibbATshawDOTca

On Feb 4, 11:00 pm, Gord Dibben <gorddibbATshawDOTca wrote:
If you want, send me your workbook by email and I'll have a look at it.

Change the AT and DOT to appropriate punctuation.

Gord

On Wed, 4 Feb 2009 14:41:28 -0800 (PST), "Michael.Tarnowski"
wrote:

I would prefer that to stumbling along here.

Change the AT and DOT as required.

Gord

On Wed, 04 Feb 2009 13:37:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
I am confused.......easily done<g

"Configuration" sheet contains text in cells in a range
"dynComments" of row 8

You want the text from each cell in this range to go into Comments in cells
of row 9 of "ActionItemsList" sheet

Am I close yet?

Gord

On Wed, 4 Feb 2009 11:01:58 -0800 (PST), "Michael.Tarnowski"
wrote:

Gord you got it - thats exactly what I'am looking for. Dynamic updates
would be great!
Thanks Michael

Gord,
thank you for the extention to a dynamic version. It works - but in
the wrong direction ;-(
I assume I mixed something up so you did not get the point.
To clarify my intention:

Sheet "Configuration" helds in A8:AF8 the comment text - since this
row may expands I defined a dynamic range "dynComments" for this
In sheet "ActionItemList" the cells in row a9:AF9 shall get the
comment of each cell in dynComments.

Your code assigns to all cells in "Configuration" (dynComments) the
comments of cells in range dynComments by change of sheet
"ActionItemList" - in your posting Sheet2.

How should I change your code?
Thanks Michael

Gord,
sorry about your confusion - my fault!

"Configuration" sheet contains text in cells in a range
"dynComments" of row 8

Sheet "Configuration" helds in A8:AF8 the comment text...
for the cells A9:AF9 of sheet "ActionItemList"

You want the text from each cell in this range to go into Comments in cells
of row 9 of "ActionItemsList" sheet
Yes

If you want, send me your workbook by email and I'll have a look at it.
Thank you very much for your courtesy, I appreciate this very much

Change the AT and DOT as required.
Hmm? - What do you mean? - I have the plain HTML gui only.

Michael

Hi Gord

I always receive the Mailer-demon error (the spaces in your address
were inserted by me):

"Hi. This is the qmail-send program at mail.gmx.net.
I'm afraid I wasn't able to deliver your message to the following
addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<gordibb @ shaw . ca:
64.59.134.8_does_not_like_recipient./
Remote_host_said:_550_#5.1.0_Address_rejected_gor dibb @ shaw . ca/
Giving_up_on_64.59.134.8./"

I inserted the spaces to protect your email-address from robots;
please send me a mail with your address to emte69ATgmxDOTde
Sorry for any inconvience
Have a nice day
Michael