Combine Work Sheets

[JR]

Hello,
I have a workbook with many sheets and I need to combine them into one
sheet. The sheets in the workbook may not be in the same layout, so I am
looking for a macro that will combine all the sheets into one, and then I
can manipulate that sheet myself, Any help would be appreciated.

Thanks JR

 

[Ken Wright]

How do you expect any piece of code to know how to combine the sheets if
they are not in the same layout. At the very least you would need to know
the possible ways that the structure could differ such that any code could
handle the different layouts and then combine them correctly.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Beige Bond]

I'd probably do something like:

Create new worksheet
For each worksheet in workbook
Copy used range
Paste cells to new worksheet
Locate end of new used range for subsequent paste
Next