Creating a workbook

[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

 

[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]

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