| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collate Worksheets into single workbook
I have a number of a folder containing a number of workbooks each of which
contains a number of worksheets. I am trying to combine just one worksheet from each of these workbooks into one workbook preserving the information and formatting, without all of the workbooks having to be open. I have been trying to use Worksheet.Copy but have had trouble losing the formatting. Currently I have been using a manually editted text file to list the worksheets which I wish transfer, would it be better to list them in another spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I combine multiple worksheets into a single workbook? | Excel Discussion (Misc queries) | |||
| macro for copy data from all worksheets of a workbook to single sh | Excel Discussion (Misc queries) | |||
| Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
| Compile all Worksheets in a Workbook in to a single Worksheet? | Excel Worksheet Functions | |||
| HOW DO i COLLATE MULTIPLE WORKSHEETS INTO ONE WORKSHEET | Excel Discussion (Misc queries) | |||
Threaded Mode
