Try this Hank
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Hank" wrote in message ...
Hi, I need to merge all data to one tab from other tabs in one work file, I
have 20 tabs with all same format columns, I want to copy paste from each tab
to cosolidated tab, how can I do it faster rather than copy and paste from
each tabs??

Thanks a lots.

hank