combining worksheets into one sheet
 

I have created a new workbook then started uploading data. The data then got
divided into 1,233 seperate sheets. I would like to combine all the data on
to one sheet regardlessof the long scroll time. The reason is when
customizing the columns with different colors and added percentages, I have
to not only do it on one sheet but all 1,233 sheets. If it was all on the
same sheet I would do it just once.

combining worksheets into one sheet
 

Hi acremax

Start here
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"acremax" wrote in message ...
I have created a new workbook then started uploading data. The data then got
divided into 1,233 seperate sheets. I would like to combine all the data on
to one sheet regardlessof the long scroll time. The reason is when
customizing the columns with different colors and added percentages, I have
to not only do it on one sheet but all 1,233 sheets. If it was all on the
same sheet I would do it just once.