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