Merge Multiple workbook sheets into one workbook

A

adamm340

Joined
Aug 6, 2014
Messages
1
Reaction score
0
Hi

I am using Microsoft Excel 2010. Every Monday I use SQL Server reporting services to run weekly reports and save them to Excel. There are 7 reports that same as 7 separate workbooks. I then create a Master Excel Work book and keep it open then open all the other workbooks and right click on the 1st sheet (the first sheet always contains the report data) and use the copy/move option and select the master workbook.

This is currently a long process. Is there a way I can copy 7 workbooks/sheets onto to one master workbook?

Thank You
 

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

Combine multiple workbooks into one workbook 1
Editing Data in Multiple Worksheets/Workbooks 1
Connecting a master sheet to other sheets within the same workbook 3
Copy formulas to another workbook 4
Multiple Worksheets 6
Link one worksheet in a workbook to another worksheet in same work 1
Convert multiple workbooks to different worksheets in 1 workbook 2
Excel hyperlink within workbook and SharePoint drafts 2

Top