View Full Version : Merged mulitple sheets of existing workbook into one sheet

03-26-2014, 11:27 PM
Dear Sir,

I want to merge different worksheet of an existing workbook(http://www.excelforum.com/excel-programming-vba-macros/999909-merged-mulitple-sheets-of-existing-workbook-into-one-sheet.html) into one by macro .I did not want to repeat the rows label for each worksheet data.Also I want to get at right hand side i.e in G column the data to be extracted for respective worksheet in the merged data.I have enclosed in attachment (http://www.excelforum.com/excel-programming-vba-macros/999909-merged-mulitple-sheets-of-existing-workbook-into-one-sheet.html)an expected solution in a sheet name "merged".However the number of worksheet is here only 3 for sample purposes.However,in reality there is more than 3 .

In addition to it,I did not like to get total row which is present in respective worksheets.This will be cleared in the "merged sheet" which I have presented. I have asked this question to another www.excelforum.com at below link >>>


I have enclosed a workbook in the above link.If any info if required,kindly do let me know.

Hope anyone could help in this regard for macro formulation.

With Best Rgds

03-27-2014, 01:47 AM
I have enclosed workbook here.Kindly find in attachment.

Hoping a prompt reply in this regard.