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.