Combining spread sheets

[Kokopelli]

I have 65 sheets of data in excel consisting of three columns. I want to
combine all 65 sheets into one long sheet. I am aware that I can just
manually copy each sheet over, however it is a very tedious process and in
the future I may have way too many sheets. I was wondering if there is a
script or something that I can use to quickly combine all of the sheets. thnx
-Rob

[Miguel Zapico]

You have some code examples in this page:
http://www.rondebruin.nl/tips.htm
Look at the section of Copy/Paste/Merge examples.

Hope this helps,
Miguel.

"Kokopelli" wrote:

> I have 65 sheets of data in excel consisting of three columns. I want to
> combine all 65 sheets into one long sheet. I am aware that I can just
> manually copy each sheet over, however it is a very tedious process and in
> the future I may have way too many sheets. I was wondering if there is a
> script or something that I can use to quickly combine all of the sheets. thnx
> -Rob