How to transfer data from one pc to another pc using Advance Excel-yawot

Transfer Data from one pc to Another pc is very useful for the data scientist and data management to sharing data from one pc to another pc for many projects. yes! in this blog do you have completely understand how it’s possible

So let get started!

Data Transfer one pc to another via LAN or Ethernet cable using IP Address. Another way is to Transfer Data from one Pc to Another USing USB CAble

First, HERE Is the Code for DATA Transfer via LAN or IP addresses


'open file in other computer and bring data to first sheet
strpath = "\\192.168.0.106\Desktop\rpm\rpm2.xlsx"

Workbooks.Open (strpath)
Dim wBk2 As Workbook
Dim wBk1 As Workbook
Set wBk2 = Workbooks("test")
Set wBk1 = Workbooks.Open(strpath)

With wBk1
wBk1.Worksheets("Sheet1").Range("R1:R2").Copy

With wBk2
wBk2.Worksheets("sheet1").Range("R1:R2").PasteSpecial Paste:=xlPasteValues

End With
End With
Application.CutCopyMode = False

how-to-transfer-data-from-one-sheet-to-another-sheet

Sub send()


Sheets("Sheet1").Range("A1:c100").Copy Destination:=Sheets("Sheet2").Range("A1")

Sheets("Sheet1").Range("A1:c100").Clear
End Sub

How to Create Button

go to Developer tab on excel
go to insert tab
click on first icon name button form control
left click to open option to select assign macro above code

Before Data Send

After Data Send