Copy worksheets from several workbooks into one workbook
 

Hi All,

How can I copy the worksheets from several workbooks in a folder to one
master workbook, preserving the formats of the original worksheet.

Thanks

--
Message posted via http://www.officekb.com

if you have fewer worksheets that need to be moved say less than 10-15 sheets.

open workbook, right click on the tab and choose "MOVE or COPY", choose destination workbook and copy the worksheets.

all the best