Combine data from multiple worksheets into a new worksheet

**sh3ll3tt3** · 10-29-2012, 05:49 PM

How can I combine the entries for 6 different worksheets?

GEO101
CBD100
EPY102
CCM118
ACP171
DNB111

into a dumpfile worksheet so I can do a pivot table. Each worksheet has the same row heading anyway.

EID Employee Name Object ID XMID Position Team Leader OM Course

I wanted to figure out a macro for that or if i copy pasted it 2 hours ago then it's finished BUT creating a macro for this is WAAAAY cooler. HELP PLEASE?

(this post removed from this thread)

**arlu1201** · 10-30-2012, 05:22 AM

You have a summary file in your attachment. Do you want the data to be consolidated in that format?

Or you are just looking to have the data one below the other?

**sh3ll3tt3** · 10-30-2012, 07:49 AM

Just one after the other. The summary table just counts how many names appear every instance but for my pivot I want the hierarchy of names to appear that's why I need a dump file. Thanks!

**mike7952** · 10-30-2012, 08:33 AM

Give this a try

Please Login or Register  to view this content.

**sh3ll3tt3** · 10-30-2012, 02:54 PM

IT'S SO COOL IT WORKS REALLY WELL. Just a few questions though. How do I modify the code if another worksheet is added and what if it's the other way around (removed for compilation?). Another is what do i change in the code if the worksheet was modified with additional columns or we lessen the columns?

Thank you very much for assisting me this well.

**mike7952** · 10-30-2012, 03:02 PM

To add or remove sheets.

Please Login or Register  to view this content.

To adjust range

Please Login or Register  to view this content.

**sh3ll3tt3** · 10-30-2012, 07:34 PM

I've played around with it and it does the trick. I don't know if I'm asking too much but is it possible for the compiled data to be dynamic if ever the data that's in the different worksheets gets changed? Can it do an auto-update? Thank you for the millionth time.