Combining several Worksheets with same headers into one worksheet

**dcincala** · 10-13-2010, 10:29 AM

I cannot figure out why my macro will not run so that all my master worksheet shows ALL columns. When it runs I only receive the first column so I am halfway there. Not sure what I need to change so that all the columns 15 columns.

Here is the macro:

Please Login or Register  to view this content.

Thank you in advance for any help. I am not sure what to do

**JBeaucaire** · 10-13-2010, 10:33 AM

I have a macro that may be "almost ready to use" for merging data from multiple sheets into a "consolidation" sheet.

Sheets to One Sheets - Part 1

You can compare the techniques shown to your own macro.

**dcincala** · 10-13-2010, 02:53 PM

The problem is I do not know how to update to my worksheet information. I have 12 worksheets and each worksheet contains 15 columns (same for each worksheet) each WS contains a different amount of rows though.

I am trying to combine the info to one master sheet.

**JBeaucaire** · 10-13-2010, 04:41 PM

The macro already does the work for you to collect the varying rows of data into a single sheet.

Look at the sample workbook on that page so you can see it in action and compare that to your setup. If it's similar enough, just try it on your workbook. The only stuff that should need editing is the code colored to catch your attention on the web page.

**dcincala** · 10-14-2010, 08:46 AM

I am sorry, I did try it and it did not work. I just am not sure what "code" info is. I can guess at the one in red "INvoice#" since that seems like a page but the other stuff is like chinese to me:

Please Login or Register  to view this content.

Do you someehow click the worksheet to add the date above? This is my first macro ever and I tried recording my own-everyone is saying oh its so simple but perhaps I am simple but to me it is not simple at all. I typically "get" stuff like this but just cannot figure it out.

Any extra help for this simple person would be appreciated. I wish there was a tutorial out there that made sense to me, it seems everything is for those who know something.

**JBeaucaire** · 10-14-2010, 11:17 AM

Macros are entered into the VBEditor.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

**adarshadi24** · 10-27-2010, 03:42 PM

Hi,

I've an issue here.... I have 40 spreadsheets and at the end of the day I've to consolidate it to one sheet. Can anybody tell me how to do it??

Please share your thoughts and ideas....

**JBeaucaire** · 10-27-2010, 07:54 PM

Post #2 of this thread provides a link to a macro designed to do this very thing.

If you can, use that macro, read and learn from it and install it into your workbook (install instructions also listed in this thread) and run it to create your own Consolidate worksheet.

If you can't, start your own thread as per the Forum Rules, attach a sample workbook with a few of your data sheets and your Consolidate sheet and many will chip in to assist.

I think the macro linked on post #2 should take care of your need.

**Paul** · 10-27-2010, 11:45 PM

Adarshadi,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.