Adding data from one column to existing column in excel using Macros

Question

I am new to excel and using macros, how can i achieve below inquiry

How to add data to another column by pressing a button in excel?

When user press "SAVE", data from column B2 will be added to column of column F.

I tried to do below code but i doesn't work

Sub ButtonSave_Click()
Range("B2").Value = Range("F" & Row).Insert
End Sub

How to deal with this?

thanks in advance!

QHarr · Accepted Answer · 2018-06-07 16:25:24Z

3

Use the following and replace Activesheet with the actual sheet name e.g. Worksheets("Sheet1")

Code:

Option Explicit
Public Sub ButtonSave_Click()
With ActiveSheet '<== replace with actual sheet reference
    .Range("F" & .Cells(.Rows.Count, "F").End(xlUp).Row + 1) = .Range("B2")
End With
End Sub

edited Jun 7, 2018 at 16:25

answered Jun 7, 2018 at 5:59

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jedi Ablaza Over a year ago

Hi QHarr, thank you for your answer, it works but it replaces the cells, i need is it adds up per row

Jedi Ablaza Over a year ago

Thanks a lot QHarr!

Lee Li Fong · Accepted Answer · 2018-06-07 05:59:37Z

0

Row=Range("F1").End(xlDown).Offset(1,0).Row
Range("F" & Row).Value=Range("B2").Value

answered Jun 7, 2018 at 5:59

Lee Li Fong

2491 silver badge6 bronze badges

Collectives™ on Stack Overflow

Adding data from one column to existing column in excel using Macros

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related