combining several excel files into one file on same worksheet

  • Thread starter Thread starter cpointer
  • Start date Start date
C

cpointer

Hi,

I'm trying to combine several excel files (monthly data) into one file
for analysis. I need the macro to put the data from each file
successively, by row on one worksheet (e.g., January data has 15 rows,
February data has 20 rows and when combined, February data is put on
the same worksheet as January data begining on row 16)? Can this be
done? If so, please let me know how. I'm not a programmer and very
new to using macros.

Thanks in advance! :confused:
 
You must log in or register to reply here.

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

Combining data from multiple worksheets into one 4
Combine multiple ranges into one worksheet 1
how do i combine excel worksheets 1
Combine Several Worksheets within a Workbook 1
combining data from several excel files into one file 3
Cannot copy worksheet to another file 2
Combine 3 of 6 worksheets 1
How do I combine these columns into one? 2

Back
Top