Forum Discussion

RAJ GUJARE's avatar
RAJ GUJARE
Copper Contributor
Apr 17, 2018

How to copy and paste data automatically with power query

Hello,   Please refer to the attached image.   I have imported data from another worksheet into a master excel file and loaded it which is seen in the attached image.    How do I copy and paste...
Macros and VBA
power bi
training
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Apr 17, 2018

Hi Raj,

 

Just specify excel file names in macro.

 

Sub Macro1()

Windows("<another worksheet name>.xlsx").activate
Sheets("<specify the sheetname>").Select
Range("C2:H24").Select

Selection.Copy

Windows("<master worksheet name>.xlsx").Activate

Sheets("<specify the sheetname>").Select

Range("C2").Select

Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

End Sub

 

Ask in any clarification.

Resources