Merging all sheets present in an excel workbook into one

Hi,

I want to merge all my excel sheets present in a workbook/worksheet on a single sheet with one row gap in between them. is it possible ??

like, for e.g. 100 fields on first sheet, 250 fields on second, 300 fields on third...
result that i wish: all 650 fields (100+250+300) on one sheet with one row gap in between them.

can anyone help with this?

Try this code out -

Please Login or Register  to view this content.