combining to worksheets in same workbook

[krispar]

hi,How can combine multiple sheets worksheets in a same workbook without concoslidating data...

 

[vijay.vizzu]

Dear Krispar

Can you elaborate more. What does it mean "combine". If you want to merge all the sheets into one sheet with the same standard structure, please upload sample file with explanation

 

[krispar]

Dear Vijay,
i wanna merge multiple sheets in one sheet in same workbook without consolidating the same data, the same thind we can do by 'copy & paste' but i have 25 sheets in one workbook and i wanna combine the data of all the sheets in a single sheet at once .
i hope i made it clear.(is it possible to do that at once)

 

[sgmpatnaik]

@krispar

Please Check this link may be it will help full

http://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html

if any issue then please inform us

Thanks

SP