Transfer Data from one MS Excel Worksheet to another Automatically

Home More Videos









I am working in a small call center and when our clients call, we take the basic details like user_name, User_id, phone_number, problem. Now what I want is, when a call comes we will note down all the above mentioned details in to an excel sheet and when I click on update this data should be saved in another excel sheet.
Thanks in advance!
Nisha
P.S.: What is a variable in Excel VBA?

Excel VBA Code for the command button:

Private Sub CommandButton1_Click()
Dim CustomerName As String, CustomerProblem As Integer
Worksheets("sheet1").Select
CustomerName = Range("C4")
CustomerProblem = Range("C5")
Worksheets("sheet2").Select
Worksheets("Sheet2").Range("B4").Select
If Worksheets("Sheet2").Range("B4").Offset(1, 0) <> "" Then
Worksheets("Sheet2").Range("B4").End(xlDown).Select
End If
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = CustomerName
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = CustomerProblem
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("C4").Select
End Sub

How to share worbooks on a local area network

How to use SKYDRIVE to share files

Watch the Excel training video below to see how data can be tranferred quickly and easily from one excel worksheet into another using Excel VBA::





Watch the video on youtube