Importing an excel sheet into another

[Kapellu2]

Hey everyone,

I am trying to combine a bunch of summary sheets into one main sheet and was curious as to how to approach it.

Basically I have one common summary sheet filled in for about 100 different products. I was wondering if I could open up a new excel sheet, and somehow import the 100 different summary sheets into one large sheet.

Any help would be greatly appreciated.

[psrs0810]

Kapellu2

Take a look at http://excel.tips.net/Pages/T003005_..._Into_One.html

There is a macro in there that takes multiple sheets into 1 sheet.
Read the commentary to see if that will be the best resolution

HTH

[royUK]

That suggested code is very ineficient. try this

Please Login or Register  to view this content.