Consolidate Data

  • Thread starter Thread starter Melwin
  • Start date Start date
M

Melwin

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.
 
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
 
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
 
Back
Top