VBA code which append all the data to the Master sheet

[Closed]
Report
Posts
1
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
October 15, 2013
-
 Blocked Profile -
I have A Master Excel sheet which I have linked to 15 different excel files with same variables. I need a VBA code which append all the data to the Master sheet when I run a macro on my master book.


Thnaks,
Tes

1 reply


Good Morning,

What do you have so far for this? Which part are you stuck on?

To reference another workbook,worksheet use the following:

Dim wbCopy As Workbook
Dim wsCopy As Worksheet
Set wbCopy = Workbooks.Open("C:\YourPath\copyBook.xlsx") 'change path
Set wsCopy = wbCopy.Worksheets("Sheet1")

After you load the sheet, grab a range and copy and paste.

Post back if you get stuck.