Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Copy text frm a cell n append it thru macro [Solved/Closed]

Report
-
 abhi -
Hello,


I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the same workbook. I am able to copy a cell to another worksheet but it's overwriting it but i want the text to get concatenated with the existing text in the the cell of another worksheet.

Any help please...
See more

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
suppose the relevant cells are A1 in sheet1 and A1 in sheet 2

try this macro 

Sub test()
Worksheets("SHEET2").Range("a1") = Worksheets("SHEET2").Range("A1") & " " & Worksheets("sheet1").Range("a1")


End Sub
Report

it's working perfectly !!!
Thanks a lot :)
Ask a question