Start here Melwin
http://www.rondebruin.nl/copy3.htm

If you need more help post back and I try to help you tomorrow


--

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


"Melwin" wrote in message ...
Thanks for the update but am not so good with xl can you give me a step by
step plan or some link where i can find the same

"Don Guillett" wrote:

You can use a DIR looping macro to open or create formulas for each workbook
desired to the next available row on the destination file.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Melwin" wrote in message
...
Want to consolidate data from many flies which are in the same format to a
sigle file how can i do it in the best way?

.