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