Easiest way to automate spreadsheet merge?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have from 2 to 5 worksheets that I need to merge. Eack sheet will contain
column titles in row 1. Each sheet will contain data in columns A-O. The
number of rows is variable and there are no named ranges. The columns will
always be in the same order.

Is there a simplw way to do this? How do I find the range of data on each
sheet?

Thanks
Mike
 
Thanks for your response. I just found out that I need to merge(i guess
this is the word) the tables. If I have 3 worksheets I will need the

Any Row one it contains column names
Row2 from sheet 1
Row2 from sheet 2
Row2 from sheet 3
Row3 from sheet 1
Row3 from sheet 2
Row3 from sheet 3
.....

Do that make sense. Any simple way to do this or do I need to loop through
each row?

Thanks again
Mike
 
Back
Top