how do I combine multiple worksheets into one? not summarize
 

i have multiple worksheets from the 'old' XL that max at 65k rows. i want to
combine all of the data into one worksheet using the new XL that allows 1mil
rows of data. from there I will manipulate, make changes, then create pivots
and charts.

how do I combine multiple worksheets into one? not summarize
 

See
http://www.rondebruin.nl/copy2.htm


--

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


"lcjwhth2o" wrote in message ...
i have multiple worksheets from the 'old' XL that max at 65k rows. i want to
combine all of the data into one worksheet using the new XL that allows 1mil
rows of data. from there I will manipulate, make changes, then create pivots
and charts.