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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
Help on consolidate worksheets from different workbooks into one 2
How to consolidate all worksheets data into 1 worksheets? 1
Consolidate data from multiple rows 2
consolidate data 2
Worksheet Consolidation - Repost requested 3
Worksheet Consolidation 2
Formula within filename link 2

Back
Top