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

Try this Mike

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message ...
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

Doe it matter if I am on Excel 97?

Mike
"Ron de Bruin" wrote in message
...
Try this Mike

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message
...
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

No


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message ...
Doe it matter if I am on Excel 97?

Mike
"Ron de Bruin" wrote in message
...
Try this Mike

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message
...
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



"Ron de Bruin" wrote in message
...
No


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message
...
Doe it matter if I am on Excel 97?

Mike
"Ron de Bruin" wrote in message
...
Try this Mike

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message
...
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