Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
Hi community,
I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
You can try copying the row of comments and choosing the Edit, Paste Special,
Comments command to paste the comments into the other row. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
Assuming cells in row 9 of Sheet B are linked to Sheet A
This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote:
Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? Gord you got it - thats exactly what I'am looking for. Dynamic updates would be great! Thanks Michael |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
A little late getting back to you.
Try this revision which updates the Comments' contents. Sub Comment_Add() Dim addtext As String Dim cmt As Comment Dim rng As Range Set rng = Sheets("Sheet2").Range("A8:M8") For Each cell In rng Set cmt = cell.Comment addtext = cell.Offset(1, 0).Text If cmt Is Nothing Then Set cmt = cell.AddComment cmt.Text Text:=addtext Else cmt.Text Text:=addtext End If Next cell End Sub To be truly dynamic, you could call it from some type of worksheet event like calculate. Private Sub Worksheet_Calculate() Comment_Add End Sub The event code would be inserted into the Sheet2 module and would trigger when you made a change in any of the row 9 source cells in Sheet1. Gord On Sun, 1 Feb 2009 06:26:01 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote: Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? Gord you got it - thats exactly what I'am looking for. Dynamic updates would be great! Thanks Michael |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 2, 6:14 pm, Gord Dibben <gorddibbATshawDOTca wrote:
A little late getting back to you. Try this revision which updates the Comments' contents. Sub Comment_Add() Dim addtext As String Dim cmt As Comment Dim rng As Range Set rng = Sheets("Sheet2").Range("A8:M8") For Each cell In rng Set cmt = cell.Comment addtext = cell.Offset(1, 0).Text If cmt Is Nothing Then Set cmt = cell.AddComment cmt.Text Text:=addtext Else cmt.Text Text:=addtext End If Next cell End Sub To be truly dynamic, you could call it from some type of worksheet event like calculate. Private Sub Worksheet_Calculate() Comment_Add End Sub The event code would be inserted into the Sheet2 module and would trigger when you made a change in any of the row 9 source cells in Sheet1. Gord On Sun, 1 Feb 2009 06:26:01 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote: Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 2, 6:14 pm, Gord Dibben <gorddibbATshawDOTca wrote:
A little late getting back to you. Try this revision which updates the Comments' contents. Sub Comment_Add() Dim addtext As String Dim cmt As Comment Dim rng As Range Set rng = Sheets("Sheet2").Range("A8:M8") For Each cell In rng Set cmt = cell.Comment addtext = cell.Offset(1, 0).Text If cmt Is Nothing Then Set cmt = cell.AddComment cmt.Text Text:=addtext Else cmt.Text Text:=addtext End If Next cell End Sub To be truly dynamic, you could call it from some type of worksheet event like calculate. Private Sub Worksheet_Calculate() Comment_Add End Sub The event code would be inserted into the Sheet2 module and would trigger when you made a change in any of the row 9 source cells in Sheet1. Gord On Sun, 1 Feb 2009 06:26:01 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote: Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 2, 6:14 pm, Gord Dibben <gorddibbATshawDOTca wrote:
A little late getting back to you. Try this revision which updates the Comments' contents. Sub Comment_Add() Dim addtext As String Dim cmt As Comment Dim rng As Range Set rng = Sheets("Sheet2").Range("A8:M8") For Each cell In rng Set cmt = cell.Comment addtext = cell.Offset(1, 0).Text If cmt Is Nothing Then Set cmt = cell.AddComment cmt.Text Text:=addtext Else cmt.Text Text:=addtext End If Next cell End Sub To be truly dynamic, you could call it from some type of worksheet event like calculate. Private Sub Worksheet_Calculate() Comment_Add End Sub The event code would be inserted into the Sheet2 module and would trigger when you made a change in any of the row 9 source cells in Sheet1. Gord On Sun, 1 Feb 2009 06:26:01 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote: Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? 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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 2, 6:14 pm, Gord Dibben <gorddibbATshawDOTca wrote:
A little late getting back to you. Try this revision which updates the Comments' contents. Sub Comment_Add() Dim addtext As String Dim cmt As Comment Dim rng As Range Set rng = Sheets("Sheet2").Range("A8:M8") For Each cell In rng Set cmt = cell.Comment addtext = cell.Offset(1, 0).Text If cmt Is Nothing Then Set cmt = cell.AddComment cmt.Text Text:=addtext Else cmt.Text Text:=addtext End If Next cell End Sub To be truly dynamic, you could call it from some type of worksheet event like calculate. Private Sub Worksheet_Calculate() Comment_Add End Sub The event code would be inserted into the Sheet2 module and would trigger when you made a change in any of the row 9 source cells in Sheet1. Gord On Sun, 1 Feb 2009 06:26:01 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 31, 12:45 am, Gord Dibben <gorddibbATshawDOTca wrote: Assuming cells in row 9 of Sheet B are linked to Sheet A This macro will place whatever is in Sheet B A9:M9 into Comments in A8:M8 Is that what you want? Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Sheets("Sheet2").Range("A8:M8") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Offset(1, 0).Text End If Next r End Sub Comments will not update if values are changed. Do you need something dynamic? Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 10:48:53 -0800 (PST), "Michael.Tarnowski" wrote: Hi community, I have an Excel application where I append a new line (by a VBA macro assign to a button) from a kind of template. Sheet A is the application, sheet B contains the "row template": Sheet B: cells in row 08: each cells is a comment text 09: each cell is a header description 10: each cell contains a formula Row 09 in sheet A is the table's heading defined in sheet B, 09. The application uses row 03 of Sheet B to append a new line in sheet A. What I want to achieve is that all comments (sheet B, row 8) are Excel real comments of the cells of sheet A, row 9. Any ideas? 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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
If you want, send me your workbook by email and I'll have a look at it.
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 |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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. 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 |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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. 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 |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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 |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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_gord ibb @ shaw . ca/ Giving_up_on_64.59.134.8./" |
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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./" |
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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 |
#18
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
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 |
#19
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
My mistake............left out one of the d's
I have sent you an email. Gord On Thu, 5 Feb 2009 14:08:06 -0800 (PST), "Michael.Tarnowski" wrote: 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 |
#20
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 6, 1:27 am, Gord Dibben <gorddibbATshawDOTca wrote:
My mistake............left out one of the d's I have sent you an email. Gord On Thu, 5 Feb 2009 14:08:06 -0800 (PST), "Michael.Tarnowski" wrote: 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 This community is really great! - It's an union of gorgeous and generous people (like Gord) in helping others with the pitfalls of Excel and VBA. Michael |
#21
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building comments from text cells
On Feb 6, 1:27 am, Gord Dibben <gorddibbATshawDOTca wrote:
My mistake............left out one of the d's I have sent you an email. Gord On Thu, 5 Feb 2009 14:08:06 -0800 (PST), "Michael.Tarnowski" wrote: 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 This community is really great! - It's an union of gorgeous and generous people (like Gord) in helping others with the pitfalls of Excel and VBA. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Text in Comments box. | Excel Discussion (Misc queries) | |||
Text Box Comments | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Text disappearing from cells and comments? | Excel Discussion (Misc queries) | |||
Lookup Text in Comments | Excel Worksheet Functions |