PDA

View Full Version : Automatically pull new data VBA



vradhak7
09-13-2016, 02:15 PM
Hello Experts,
I have attached the file for reference.
Whenever a new data populates in the worksheet "Source" for the data in column (GOE_FOUR and GOE_FIVE), the corresponding data should populate itself in Worksheet "Dashboard". I want the macro to automatically do this.
So whenever i hit refresh, the new data populates in the worksheet("Dashboard").
Inputs are greatly appreciated!17073

Not posted in any other thread as of now.

vradhakr

SamT
09-13-2016, 03:28 PM
So whenever i hit refresh,
What is "Refresh"?

ThisWorkbook Code Page

Option Explicit

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name = "Source" And Target.Column = 3 Then _
Target.Offset(, -2).Resize(, 3).Copy Sheets("Dashboard").Cells(Rows.Count, "A").End(xlUp)
End Sub

vradhak7
09-13-2016, 04:10 PM
The worksheet"Source" is connected to a web data. Hence Whenever I hit refresh it populates new data.

vradhak7
09-13-2016, 04:47 PM
@Samt

Does this private sub go in the module ?

SamT
09-13-2016, 05:58 PM
It goes in the ThisWorkbook Module.