Combining multiple worksheets
I have a workbook that has 150 worksheets. Each worksheet has the same dimensions. I would like to combine each worksheet into one worksheet so there is only one workbook with one worksheet. Is there VBA script that would enable me to do this without manually going to each worksheet?
|