| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile 6 identical ranges(size and fields) into a text file.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defining a name that represent identical ranges in every sheet | Excel Discussion (Misc queries) | |||
| Defining identical names that represent different ranges of cells | Excel Discussion (Misc queries) | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| How do I make pies identical size in Excel? | Charts and Charting in Excel | |||
| How do I make all pie charts identical in size | Excel Worksheet Functions | |||
Threaded Mode
