Load data from multiple spreadsheets into one master spreadsheet

S

Scarlet

Hi All,

I am looking to load data from a number of spreadsheets into one master
spreadsheet using VBA.

These are timesheets, so all are the spreadsheets are the same format
but each one will contain different numbers of rows.

The name of the spreadsheets will change every week but all sheets will
be placed in the same directory every week. These will be the only
files there.

The master spreadsheet will be of the same format.

So in short, i need to be able to open up the spreadsheets in turn read
the data row by row and copy it into the master spreadsheet (inserting
the rows as i go). Once there are no more rows to read. The next
spreadsheet is open and read etc etc until there are no more sheets to
read.

Ideally I am looking for some VBA examples to get me going, first on
getting the files in the directory and then loading the data.

Any help / coding examples woould be very much appreciated.

-Scarlet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Macro to Consolidate Data from Various Excel Files 1
Macro to Format Multiple Sheets based on "Master" Format 0
Copy from one source to multiple spreadsheets 1
Extracting data from an excel spreadsheet 3
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Combine two spreadsheets into one 3
export data between spreadsheets 2

Top