EXCEL - Combining different worksheets into ONE?

[OrionStar]

I have many worksheets....or files that I need to combine into ONE large file so that I can use Crystal Reports to run a report on using it as a DataTable

Is it possible to combine these in some automated way, or is manually opening, "cutting and pasting" the only way???

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[SkipVought]

Hi,

It depends on how the data is formatted in these multiple sheets.

If the data has identical columns (If you were to copy 'n' paste, which columns would go with what???) and the data is configured as one table per sheet, you could use MS Query via menu item Data/Get External Data/New Database Query -- Excel Files -- YOUR WORKBOOK -- YOUR TABLE (Sheet)......

The data can be "stacked" joining them in a UNION query.

Let me know.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}