[Mac]

Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.

[Gord Dibben]

See Ron de Bruin's site for code assistance.

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

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 11:34:03 -0700, Mac wrote:

Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.

[Mac]

Thanks for the link. It answered questions I haven't yet asked but I dont
see that it answered the one I did ask. OR maybe it did and I'm too green to
recognize it.
Thanks for giving it a go.

"Gord Dibben" wrote:

See Ron de Bruin's site for code assistance.

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

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 11:34:03 -0700, Mac wrote:

Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.

[Gord Dibben]

Are the worksheets to be gathered from multiple workbooks?

http://www.rondebruin.nl/fso.htm Copy sheet from each workbook

Create a summary sheet in a new workbook with data from multiple workbooks.

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


Gord

On Tue, 10 Jun 2008 16:53:01 -0700, Mac wrote:

Thanks for the link. It answered questions I haven't yet asked but I dont
see that it answered the one I did ask. OR maybe it did and I'm too green to
recognize it.
Thanks for giving it a go.

"Gord Dibben" wrote:

See Ron de Bruin's site for code assistance.

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

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 11:34:03 -0700, Mac wrote:

Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.