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

Question

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

Report

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
How to compare two cell values in excel using macro ✓ - Forum - Excel
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software
What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel
Highlight at most 7 cells so that all unhighlighted cells are next to a highlighted cell - Forum - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2012-03-09T01:30:09-0500

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
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

Report

abhi
Mar 9, 2012 at 01:50 AM

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

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

1 reply

Your reply

Subscribe To Our Newsletter!