Combine multiple sheets into one

[stonyt10]

Hi all.. if anyone can guide me in the right direction I would totally appreciate it.

I have Excel 97 and a workbook with 33 sheets in it. Each sheet is the same... name/address/city/state/zip. I need to output mailing labels of each sheet, but I don't want to process each sheet individually. When I try the Avery Label wizard with Microsoft Word 97, it will only let me do one sheet at a time

[ravishankar]

Hi
Can you give more details on the layout of your data and how label wizard works?
Ravi

[stonyt10]

I actually found a solution to this problem. The mailing label software is irrelevant as long as the workbook is combined into one sheet, which was my issue. I could not find anything to help me on the Excel end, but I *did* find a solution with Perl programming. I wrote a program to combine the sheets for me and it works beautifully. Thanks all who put some thought into this! I'll post my Perl script below.. it's customized to my need for 5 columns per sheet, but is easily adaptable:

Please Login or Register  to view this content.