Combine multiple sheets within workbook

's Computer Specifications

I know this is out there but I haven't been able to find it. Does anyone have
existing code to combine the data from multiple worksheets into one
worksheet. I need to be able to code in which worksheets to include because
there are sheets in the workbook that will not be used in this exercise. (All
sheets have same column data). Thanks!!
--
Thanks,
Sherry

's Computer Specifications

Found it. Thanks!

http://www.rondebruin.nl/copy2.htm
--
Thanks,
Sherry

"Sherry" wrote:

> I know this is out there but I haven't been able to find it. Does anyone have
> existing code to combine the data from multiple worksheets into one
> worksheet. I need to be able to code in which worksheets to include because
> there are sheets in the workbook that will not be used in this exercise. (All
> sheets have same column data). Thanks!!
> --
> Thanks,
> Sherry

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open multiple workbook then combine into single workbook butdifferent sheets	geniusideas	Microsoft Excel Programming	3	25th Nov 2009 11:47 PM
Combine sheets in a workbook into one sheet?	msnyc07	Microsoft Excel Misc	1	24th Nov 2009 04:42 PM
How do I combine 50 spreadsheets into 1 workbook with 50 sheets	excel@moorehead.net	Microsoft Excel Worksheet Functions	1	27th Oct 2008 01:10 PM
Combine CSV files into 1 Excel Workbook as sheets	=?Utf-8?B?SkVGRg==?=	Microsoft Excel Programming	2	20th May 2006 11:00 PM
How can I combine many excel sheets into one workbook	Elliott Alterman	Microsoft Excel Discussion	1	20th Mar 2004 09:45 PM