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:
 
Back
Top