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?

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?

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?

.

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?

.

Here is the basic idea for using DIR
Sub FindFilesToChangeSAS()' Bare bones version to test for DIR
Dim FN As String
FN = Dir(ThisWorkbook.Path & "\*.*")
Do Until FN = ""

MsgBox FN 'Name of each file in the directory(folder) displayed
'Do what is desired with the workbook

Loop
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?

.