Previous Topic Next Topic

Copy text frm a cell n append it thru macro

Solved/Closed
abhi - Mar 9, 2012 at 01:06 AM
 abhi - Mar 9, 2012 at 01:50 AM
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...

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 9, 2012 at 01:30 AM
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
0
abhi
Mar 9, 2012 at 01:50 AM
it's working perfectly !!!
Thanks a lot :)
0

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response