I have 6 identical ranges (cost centres with same accounts and fields)
that are in separate worksheets. I want to compile into one dataset
and save as a text file. Do I loop through the ranges and copy and
paste into a worksheet then create the text file from that worksheet
or can I compile a dataset to save as a text file without creating the
worksheet as an interim?

Any help is fantastic. Thanks heaps!

Dean

Hi Dean,

'---------------
I have 6 identical ranges (cost centres with same accounts and fields)
that are in separate worksheets. I want to compile into one dataset
and save as a text file. Do I loop through the ranges and copy and
paste into a worksheet then create the text file from that worksheet
or can I compile a dataset to save as a text file without creating the
worksheet as an interim?
'---------------

I think that you would initially need to create a summary sheet.

For sample code to create the summary sheet, visit Ron de Bruin at:

Merge cells from all or some worksheets into one Master sheet
http://www.rondebruin.nl/copy2.htm



---
Regards,
Norman