Collate Worksheets into single workbook

J

jw4774

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?
 
J

jw4774

This is nearly what I need to do and the Ron de Bruin Add-In seems to work
well, but is there anyway of keeping the merged data on seperate worksheets
within the new work book?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print (physical or pdf) not respecting format of source document 0
Shift Collate sheet 1-20 when printing entire workbook? 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Use a master workbook to carry over changes to multiple workbooks 1
Columns appearing from nowhere, formatting going weird 0
moving worksheets 1
Creating a Search using a combo box and then creating a report. 4
Sharepoint not capturing staff name when automation runs 0

Top