VBA code to consolidate multiple sheets

**kashaikh78** · 11-26-2019, 01:50 PM

Hi all,

I have multiple sheets that I wanted to consolidate. I attached a sample test file that have 2 tabs with same columns and headings and looking for some VBA coding to consolidate data in both tabs into one.

I usually have up to 15 - 20 sheets with similar data, and it takes a lot of time to consolidate. I hope I can get some quick solution to that.

**Logit** · 11-26-2019, 02:33 PM

Please Login or Register  to view this content.

**kashaikh78** · 11-26-2019, 03:19 PM

Gives me Run time error

**Logit** · 11-26-2019, 04:20 PM

.
Change : Set wsM = Sheets("Master") MASTER to the name of the primary sheet where all the other sheets will be copied to.

Also, place this Dim statement at the top of your macro : Dim x As Long

**kashaikh78** · 11-26-2019, 05:46 PM

It's worked. Thanks

**Logit** · 11-26-2019, 06:19 PM

.
You are welcome. Glad to help.

VBA code to consolidate multiple sheets

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to consolidate multiple sheets

Re: VBA code to consolidate multiple sheets

Re: VBA code to consolidate multiple sheets

Re: VBA code to consolidate multiple sheets

Re: VBA code to consolidate multiple sheets

Re: VBA code to consolidate multiple sheets

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code to Consolidate Multiple Sheets with Multiple Criteria

[SOLVED] Vba code to consolidate multiple sheets to one

Consolidate Multiple Sheets into Two Master Sheets

VBA Code to consolidate sheets from multiple workbooks into one workbook

VBA code to consolidate coloumns in muliple sheets into multiple coloumns in one sheet?

[SOLVED] VBA code to consolidate coloumns in muliple sheets into multiple coloumns in one sheet?

[SOLVED] Modification to code to consolidate two sheets...

Bookmarks

Bookmarks

Posting Permissions