How to append or consolidate sheets into 1 final results sheet

[Cakin]

Hello

I'm trying to take several sheets inside an excel work book and combine them together without the hassle of copy and pasting them all in.

The sheets all have the 3 same columns and the same headers, so there's nothing tricky there.

I tried out the consolidate command and but it errors on me and says no data was consolidated... I thought it would be nice if it auto updated like it says it will, but if that's not how that all works then i guess i can't use that.

So i guess my question is how do I combine all my work sheets into a single sheet?

Attached is an example in the real book there's some extra sheets after the results sheets with a bunch of formulas and such so if there's a way to pick just the sheets with the data (like a range (sheets 2-4 for example) that would be great.

[tigeravatar]

Cakin,

Attached is a modified version of your example workbook. Is that what you're looking for?

Hope this helps,
~tigeravatar

[MarvinP]

Hi Cakin,
See if the attached, with code, does what you want. Read the code and learn.

Better yet is to read both of our codes and realize there are a lot of different ways to program.

[Cakin]

Hi Cakin,
See if the attached, with code, does what you want. Read the code and learn.

Better yet is to read both of our codes and realize there are a lot of different ways to program.

Both macros work great thanks to both of you, i really appreciate the help.