I have a large number of worksheets, all with the exact same format. I would
like to be able to have them all in one one worksheet, without having to
spend a large amount of time using the copy and paste functions. Therefore,
is there anyway of combining a number of worksheets within a workbook into
one worksheet, so that the data from one worksheet appears directly beneath
the next one?
Ron de Bruin - 10 Jan 2008 15:29 GMT
See this page Steven for a VBA example
http://www.rondebruin.nl/copy2.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
>I have a large number of worksheets, all with the exact same format. I would
> like to be able to have them all in one one worksheet, without having to
> spend a large amount of time using the copy and paste functions. Therefore,
> is there anyway of combining a number of worksheets within a workbook into
> one worksheet, so that the data from one worksheet appears directly beneath
> the next one?