Combining different worksheets of same xls file into a single worksheet

[pavan.polish]

Dear Friends,

I have a requirement to combine different worksheets of the same xls file. file into single worksheet.

Assume this can be done using VB script and it will be great if you share the script for the same.

Thanks a lot in advance.

Regards,
Pavan

[Kaper]

To do it properly one needs to know the structure of your data file.

Assuming the data layout is the seme each sheet and always column A is filled ina, and row 1 contains headers you could do this with simple macro like (no tested as no sample attached):

Please Login or Register  to view this content.