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...

Copy text frm a cell n append it thru macro
Spell number in excel without macro - Guide
Run macro when cell value changes - Guide
Run macro when cell value changes by formula - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum

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

abhi
Mar 9, 2012 at 01:50 AM

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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!