How to make one worksheet from multiple worksheets?

  • Thread starter Thread starter John Rugo
  • Start date Start date
J

John Rugo

Hi All,
Can someone tell me how to do the following:

I have several worksheets of data in a file.
All the worksheets have exactly the same Columns.
I want to create a single worksheet with all the data from all the existing
worksheets.

Up to now I have been copy/pasting the data into a single worksheet.
Is there a programmatic way of doing this for me?

Thanks,
John.
 
Back
Top