paradise
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 >>>
http://www.excelforum.com/excel-programming-vba-macros/999909-merged-mulitple-sheets-of-existing-workbook-into-one-sheet.html
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
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 >>>
http://www.excelforum.com/excel-programming-vba-macros/999909-merged-mulitple-sheets-of-existing-workbook-into-one-sheet.html
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