You need to use macros unless this is a one timer and the number of files
are not that many

http://www.rondebruin.nl/tips.htm

look under the Copy/Paste?Merge header



--
Regards,

Peo Sjoblom




"Ianwal" wrote in message
...
i have a number of one line excel sheets that i want to put into one big
one.
Is there a better way than cutting and pasting