Lists from second workbook

ryansm05

Board Regular
Joined
Sep 14, 2016
Messages
129
I've had a go at your initial suggestion and done a little research myself - it seems to work with the below code.
However, how would I manipulate this code to:

1) Make it open automatically
2) Duplicate the macro to pull in data from a second tab in the Master and drop it in a second tab in the summary

Thanks



Sub GetDataClosedBook()


Dim src As Workbook
'location of the file and data to copy


Set src = Workbooks.Open("I:\Accounts\2018\Financial Reporting\BRD\NewRev\Data.xlsx", True, True)
'bring to this workbook


ThisWorkbook.Activate


Worksheets("Time").Range("A1:X15000").Formula = src.Worksheets("Time").Range("A1:X15000").Formula


src.Close False


End Sub
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,089,216
Messages
5,406,897
Members
403,111
Latest member
Donbozone

This Week's Hot Topics

Top